The only AGENT_NO try unloading the entire key fields from the file if you haveĪll the fields.If you query the table with out key fields, there will be tremendous You need to handle duplicates by -811 or code a CURSOR.Ģ-> It is always good to query the table using the full key. Other wise there is a posibility that you will get duplicates for that either
We need to consider few things in the above queryġ-> IT will give correct results only if you have UNIQUE AGENT_NO in the AGENT TABLE. No problem, please let me know how it goes by.WHERE AGENT_NO = :WS-Agent_No -> This field should be from ur TRANS FILE. Thanx for your prompt reply.i will try that out.Bye LOAD DATA LOG YES RESUME YES INDDN SYSREC00 INTO TABLE DSNUPROC.SYSMAP DD DSN=YourRACF.SYSMAP, DSNUPROC.SYSERR DD DSN=YourRACF.SYSERR,
DSNUPROC.SORTOUT DD DSN=YourRACF.SORTOUT, DSNUPROC.SYSUT1 DD DSN=YourRACF.SYSUT1, DSNUPROC.SYSREC00 DD DSN=your Input file here, DSNUPROC.SORTWK04 DD DSN=YourRACF.SORTWK04, DSNUPROC.SORTWK03 DD DSN=YourRACF.SORTWK03, DSNUPROC.SORTWK02 DD DSN=YourRACF.SORTWK02, DSNUPROC.SORTWK01 DD DSN=YourRACF.SORTWK01, UTIL EXEC DSNUPROC,SYSTEM= DSNC,UID='UKMG',UTPROC=''
Please get back to me if you have any questions. Add RESUME YES as highlighted in BLUE below if you want to apend the table. You'll get the table structure if you run the DSNTIAUL utility for SELECT * FROM CREATOR.TABLE_NAME in SYSPUNCH. Here's a JCL you're looking for, please copy this to your job library and do the following changes:ī) C ALL 'YourRACF' RACFID -> give your id or an HLQ that you've CREATE/DELETE accessĬ) give the input file in DSNUPROC.SYSREC00ĭ) give the DB2 subsystem of your table inplace of DSND (highlighted in RED), don't worry about UID/UTPROCĮ) in DSNUPROC.SYSIN, you specify your table structure. 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.Īnd 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. Load a database with existing data through a flat file Load a database with existing data through a flat file -IBM Mainframes
0 kommentar(er)
