twissi
Active User
Joined: 01 Aug 2005 Posts: 105 Location: Somerset, NJ
|
|
|
|
Hi Mubashir,
Here's a JCL you're looking for, please copy this to your job library and do the following changes:
a) add a suitable job card
b) C ALL 'YourRACF' RACFID ---> give your id or an HLQ that you've CREATE/DELETE access
c) give the input file in DSNUPROC.SYSREC00
d) give the DB2 subsystem of your table inplace of DSND (highlighted in RED), don't worry about UID/UTPROC
e) in DSNUPROC.SYSIN, you specify your table structure. You'll get the table structure if you run the DSNTIAUL utility for SELECT * FROM CREATOR.TABLE_NAME in SYSPUNCH. Add RESUME YES as highlighted in BLUE below if you want to apend the table.
Please get back to me if you have any questions.
Cheers, Twissi.
//UTIL EXEC DSNUPROC,SYSTEM=DSNC,UID='UKMG',UTPROC=''
//*
//**********************************************
//*
//* GENERATING JCL FOR THE LOAD UTILITY
//*
//**********************************************
//*
//DSNUPROC.SORTWK01 DD DSN=YourRACF.SORTWK01,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(16384,(20,20),,,ROUND),
// UNIT=SYSALLDA
//DSNUPROC.SORTWK02 DD DSN=YourRACF.SORTWK02,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(16384,(20,20),,,ROUND),
// UNIT=SYSALLDA
//DSNUPROC.SORTWK03 DD DSN=YourRACF.SORTWK03,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(16384,(20,20),,,ROUND),
// UNIT=SYSALLDA
//DSNUPROC.SORTWK04 DD DSN=YourRACF.SORTWK04,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(16384,(20,20),,,ROUND),
// UNIT=SYSALLDA
//DSNUPROC.SYSREC00 DD DSN=your Input file here,
// DISP=OLD
//DSNUPROC.SYSUT1 DD DSN=YourRACF.SYSUT1,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(16384,(20,20),,,ROUND),
// UNIT=SYSALLDA
//DSNUPROC.SORTOUT DD DSN=YourRACF.SORTOUT,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(16384,(20,20),,,ROUND),
// UNIT=SYSALLDA
//DSNUPROC.SYSERR DD DSN=YourRACF.SYSERR,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(16384,(20,20),,,ROUND),
// UNIT=SYSALLDA
//DSNUPROC.SYSMAP DD DSN=YourRACF.SYSMAP,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(16384,(20,20),,,ROUND),
// UNIT=SYSALLDA
//DSNUPROC.SYSIN DD *
LOAD DATA LOG YES RESUME YES INDDN SYSREC00 INTO TABLE
CREATOR.TABLE_NAME
(
N_CLAIM_NUMBER POSITION( 1 )
CHAR( 12) ,
C_CLAIM_SEQ_EVENT POSITION( 13 )
CHAR( 5) ,
)
/* |
|