| 1 | //TRANEXTR JOB 'EXTRACT TRAN TYPE', |
| 2 | // CLASS=A,MSGCLASS=0,NOTIFY=&SYSUID |
| 3 | //****************************************************************** |
| 4 | //* Copyright Amazon.com, Inc. or its affiliates. |
| 5 | //* All Rights Reserved. |
| 6 | //* |
| 7 | //* Licensed under the Apache License, Version 2.0 (the "License"). |
| 8 | //* You may not use this file except in compliance with the License. |
| 9 | //* You may obtain a copy of the License at |
| 10 | //* |
| 11 | //* http://www.apache.org/licenses/LICENSE-2.0 |
| 12 | //* |
| 13 | //* Unless required by applicable law or agreed to in writing, |
| 14 | //* software distributed under the License is distributed on an |
| 15 | //* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, |
| 16 | //* either express or implied. See the License for the specific |
| 17 | //* language governing permissions and limitations under the License |
| 18 | //****************************************************************** |
| 19 | //* This JCL will extract reference data for use in Transaction |
| 20 | //* Report generation. It runs once a day. So changes will reflect |
| 21 | //* in report only after the daily batch is run. |
| 22 | //****************************************************************** |
| 23 | //* Set Parms for this compile: |
| 24 | //********************************************************************* |
| 25 | // SET HLQ=AWS.M2.CARDDEMO |
| 26 | //********************************************************************* |
| 27 | //**** Db2 Unload using DSNTIAUL utility ****** |
| 28 | //********************************************************************* |
| 29 | //*** STEP 10 : BACKUP THE PREVIOUS VERSION OF TRANTYPE FILE TO GDG |
| 30 | //********************************************************************* |
| 31 | //STEP10 EXEC PGM=IEBGENER |
| 32 | //SYSPRINT DD SYSOUT=* |
| 33 | //SYSIN DD DUMMY |
| 34 | //SYSUT1 DD DISP=SHR,DSN=&HLQ..TRANTYPE.PS |
| 35 | //SYSUT2 DD DSN=&HLQ..TRANTYPE.BKUP(+1), |
| 36 | // DISP=(NEW,CATLG), |
| 37 | // DCB=(LRECL=60,RECFM=FB,BLKSIZE=600), |
| 38 | // SPACE=(TRK,(1,1),RLSE) |
| 39 | //********************************************************************* |
| 40 | //*** STEP 20 : BACKUP THE PREVIOUS VERSION OF TRANCATG FILE TO GDG |
| 41 | //********************************************************************* |
| 42 | //STEP20 EXEC PGM=IEBGENER,COND=(0,NE) |
| 43 | //SYSPRINT DD SYSOUT=* |
| 44 | //SYSIN DD DUMMY |
| 45 | //SYSUT1 DD DISP=SHR,DSN=&HLQ..TRANCATG.PS |
| 46 | //SYSUT2 DD DSN=&HLQ..TRANCATG.PS.BKUP(+1), |
| 47 | // DISP=(NEW,CATLG), |
| 48 | // DCB=(LRECL=60,RECFM=FB,BLKSIZE=600), |
| 49 | // SPACE=(TRK,(1,1),RLSE) |
| 50 | //********************************************************************* |
| 51 | //**** STEP 30 : DELETE FILES FROM PREVIOUS RUN ****** |
| 52 | //********************************************************************* |
| 53 | //STEP30 EXEC PGM=IEFBR14,COND=(0,NE) |
| 54 | //DD01 DD DISP=(MOD,DELETE,DELETE), |
| 55 | // UNIT=SYSDA, |
| 56 | // SPACE=(TRK,(1,1)), |
| 57 | // DSN=&HLQ..TRANTYPE.PS |
| 58 | //DD02 DD DISP=(MOD,DELETE,DELETE), |
| 59 | // UNIT=SYSDA, |
| 60 | // SPACE=(TRK,(1,1)), |
| 61 | // DSN=&HLQ..TRANCATG.PS |
| 62 | //********************************************************************* |
| 63 | //**** STEP 40 : EXTRACT DATA FROM TRANSACTION TYPE TABLE ****** |
| 64 | //********************************************************************* |
| 65 | //STEP40 EXEC PGM=IKJEFT01,COND=(0,NE) |
| 66 | //STEPLIB DD DISP=SHR,DSN=OEM.DB2.DAZ1.RUNLIB.LOAD |
| 67 | // DD DISP=SHR,DSN=OEMA.DB2.VERSIONA.SDSNLOAD |
| 68 | //SYSTSPRT DD SYSOUT=* |
| 69 | //SYSPRINT DD SYSOUT=* |
| 70 | //SYSUDUMP DD SYSOUT=* |
| 71 | //SYSPUNCH DD DUMMY |
| 72 | //SYSREC00 DD DISP=(NEW,CATLG,DELETE), |
| 73 | // DSN=&HLQ..TRANTYPE.PS, |
| 74 | // SPACE=(TRK,(1,1),RLSE) |
| 75 | //SYSIN DD * |
| 76 | SELECT CAST(CONCAT(CONCAT( |
| 77 | TR_TYPE |
| 78 | ,CAST(TR_DESCRIPTION AS CHAR(50)) |
| 79 | ) |
| 80 | ,REPEAT('0',8) |
| 81 | ) AS CHAR(60)) |
| 82 | FROM |
| 83 | CARDDEMO.TRANSACTION_TYPE |
| 84 | ORDER BY TR_TYPE; |
| 85 | /* |
| 86 | //SYSTSIN DD * |
| 87 | DSN SYSTEM(DAZ1) |
| 88 | RUN PROGRAM(DSNTIAUL) - |
| 89 | PLAN(DSNTIAUL) - |
| 90 | PARMS('SQL') |
| 91 | /* |
| 92 | //********************************************************************* |
| 93 | //**** STEP 50 : EXTRACT DATA FROM TRANSACTION TYPE TABLE ****** |
| 94 | //********************************************************************* |
| 95 | //STEP50 EXEC PGM=IKJEFT01,COND=(4,LT) |
| 96 | //STEPLIB DD DISP=SHR,DSN=OEM.DB2.DAZ1.RUNLIB.LOAD |
| 97 | // DD DISP=SHR,DSN=OEMA.DB2.VERSIONA.SDSNLOAD |
| 98 | //SYSTSPRT DD SYSOUT=* |
| 99 | //SYSPRINT DD SYSOUT=* |
| 100 | //SYSUDUMP DD SYSOUT=* |
| 101 | //SYSPUNCH DD DUMMY |
| 102 | //SYSREC00 DD DISP=(NEW,CATLG,DELETE), |
| 103 | // DSN=&HLQ..TRANCATG.PS, |
| 104 | // SPACE=(TRK,(1,1),RLSE) |
| 105 | //SYSIN DD * |
| 106 | SELECT CAST( |
| 107 | TRC_TYPE_CODE |
| 108 | || TRC_TYPE_CATEGORY |
| 109 | || CAST(TRC_CAT_DATA AS CHAR(50)) |
| 110 | || REPEAT('0',4) |
| 111 | AS CHAR(60)) |
| 112 | FROM CARDDEMO.TRANSACTION_TYPE_CATEGORY |
| 113 | ORDER BY |
| 114 | TRC_TYPE_CODE |
| 115 | , TRC_TYPE_CATEGORY; |
| 116 | /* |
| 117 | //SYSTSIN DD * |
| 118 | DSN SYSTEM(DAZ1) |
| 119 | RUN PROGRAM(DSNTIAUL) - |
| 120 | PLAN(DSNTIAUL) - |
| 121 | PARMS('SQL') |
| 122 | /* |