This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
INSERT INTO PS_LEDGER_TEMP | |
SELECT BUSINESS_UNIT | |
,LEDGER | |
,'dummy_acct' AS ACCOUNT | |
,ALTACCT | |
,DEPTID | |
,OPERATING_UNIT | |
,PRODUCT | |
,FUND_CODE | |
,CLASS_FLD |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 | |
/ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 | |
/ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 | |
/ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)) | |
/ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--- | |
:backends: | |
- eyaml | |
- yaml | |
:hierarchy: | |
- "%{::environment}/%{::environment}" | |
- "%{::region}/%{::region}" | |
- "%{::database_class}/%{::database_class}" | |
- "common/acm" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
OlderNewer