I need to load data from a flat file into a DB2 table which already contains some data in it.My requirement is to load the new data from the file while at same time retaining the existing data.
And also this has to be done thru a JCL.Can anyone of you suggest the parameter that are to be coded to perform the above step with all its requirements.
Waiting for reply and thanx in advance.
Joined: 01 Aug 2005 Posts: 105 Location: Somerset, NJ
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.