accasey

UPDATE PS_VNDR_BANK_ACCT
SET BANK_ACCT_TYPE = '03'
,BANK_ACCOUNT_NUM = 'xxxxxxxxxxxxx'
,DFI_ID_QUAL = 'XX'
,IBAN_ID = 'XXXXXXXXXXXXXXXXXXXXXX'
,BENEFICIARY_BANK = 'A BANK'
,BANK_ID_QUAL = 'xxx'
,BNK_ID_NBR = 'xxxxxx'
,DFI_ID_NUM = 'xxxxxxxxxxx'
,COUNTRY = 'ABC'

accasey

INSERT INTO PS_LEDGER_TEMP  
SELECT BUSINESS_UNIT 
,LEDGER
,'dummy_acct' AS ACCOUNT 
,ALTACCT
,DEPTID
,OPERATING_UNIT
,PRODUCT
,FUND_CODE
,CLASS_FLD

accasey

    UPDATE PS_EP_APPR_SECTION SET EP_RESULTS='Data has been cleared.'
    /
    UPDATE PS_EP_APPR_ITEM SET EP_RESULTS='Data has been cleared.'
    /
    UPDATE PS_EP_APPR_ITEM SET REVIEW_RATING = 2
    /
    UPDATE PS_EP_APPR_ITEM SET REVIEW_POINTS = 2
    /

accasey

UPDATE PS_COMPENSATION SET COMPRATE = 1000.00, CONVERT_COMPRT = 1000, CHANGE_AMT = 100
/
UPDATE PS_JOB SET COMPRATE = 1000, CHANGE_AMT = 1, CHANGE_PCT =1 , ANNUAL_RT = 1000, MONTHLY_RT = 100, DAILY_RT = 10, HOURLY_RT = 1
/

accasey

UPDATE PS_GP_RSLT_ACUM SET CALC_RSLT_VAL = 0, CALC_VAL = 0
/
UPDATE PS_GP_RSLT_DELTA SET CALC_DELTA_VAL = 0,UNIT_DELTA_VAL = 0, BASE_DELTA_VAL = 0
/
UPDATE PS_GP_RSLT_ERN_DED SET CALC_RSLT_VAL = 0, BASE_RSLT_VAL = 0, RATE_RSLT_VAL = 0, UNIT_RSLT_VAL = 0, RSLT_XFER_VAL = 0
/
UPDATE PS_GP_RSLT_PIN SET CALC_RSLT_VAL = 0
/
UPDATE PS_GP_RSLT_PI_DATA SET GP_AMT = 0, GP_PCT = 0, GP_BASE = 0, GP_UNIT = 0
/

accasey

TRUNCATE TABLE PSAPMSGDOMSTAT
/
TRUNCATE TABLE PSAPMSGDSPSTAT
/
INSERT INTO PSAPMSGDOMSTAT (MACHINENAME,APPSERVER_PATH,DOMAIN_STATUS,IBFAILOVERPRIORITY,IBFAILOVERGROUP,IB_SLAVEMODE,IB_LOADBALANCE,IB_SERVERURL,IB_DOMAIN_POOLING) 
VALUES (UPPER('MYSERVERNAME'),'PATH TO DOMAIN FOLDER', 'A', 0, 0, 0, 1, ' ', 0)
/
INSERT INTO PSAPMSGDSPSTAT (DISPATCHERNAME,MACHINENAME,APPSERVER_PATH,DSPSTATUS,STATUSSTRING,IB_SLAVEMODE,DSPRESET,CLEANUP_DTTM,DSPHEALTHDTTM)
VALUES ('PSPUBDSP_dflt', UPPER('MYSERVERNAME'), 'PATH TO DOMAIN FOLDER', 0, 'ACT', 0, 0, NULL, CAST(SYSTIMESTAMP AS TIMESTAMP))
/

accasey

SELECT Y.RECNAME, LTRIM(MAX(SYS_CONNECT_BY_PATH(Y.FIELDNAME  ,',')) KEEP (DENSE_RANK LAST  ORDER BY Y.CURR_FIELD)   ,',') AS FIELDNAMES
FROM ( 
  SELECT Z.RECNAME 
  ,Z.FIELDNAME  
  ,ROW_NUMBER() OVER (PARTITION BY Z.RECNAME ORDER BY Z.FIELDNUM) AS CURR_FIELD 
  ,ROW_NUMBER() OVER (PARTITION BY Z.RECNAME ORDER BY Z.FIELDNUM) - 1 AS PREV_FIELD  
  FROM PSRECFIELDDB Z  
  WHERE 1 = 1  
  AND Z.RECNAME='PSAPMSGDOMSTAT') Y
GROUP BY Y.RECNAME

accasey

Function unzip(&inputZipFile, &targetDir);
   Local JavaObject &zipFileInputStream = CreateJavaObject("java.io.FileInputStream", &inputZipFile);
   Local JavaObject &zipInputStream = CreateJavaObject("java.util.zip.ZipInputStream", &zipFileInputStream);
   Local JavaObject &zipEntry = &zipInputStream.getNextEntry();
   Local JavaObject &buf = CreateJavaArray("byte[]", 1024);
   Local number &byteCount;
   
   While &zipEntry <> Null;
      If (&zipEntry.isDirectory()) Then;
         REM ** do nothing;

accasey

---
:backends:
  - eyaml
  - yaml

:hierarchy:
  - "%{::environment}/%{::environment}"
  - "%{::region}/%{::region}"
  - "%{::database_class}/%{::database_class}"
  - "common/acm"

accasey

cd /d d:\psoft\dpk\puppet\production\manifests
rem like this:
"C:\Program Files\Puppet Labs\Puppet\bin\puppet.bat" apply --confdir=d:\psoft\dpk\puppet --environment=CMADEV02 setWinServiceUser.pp --modulepath d:\psoft\dpk\puppet\production\modules --debug --trace
rem or like this:
"C:\Program Files\Puppet Labs\Puppet\bin\puppet.bat" apply -e "include ::pt_profile::pt_tools_preboot_config" --environment=CMASBX90 --modulepath d:\psoft\dpk\puppet\production\modules --confdir=d:\psoft\dpk\puppet site.pp --debug --trace