![]() Migrate from PaaS: Cloud Foundry, OpenshiftĬOVID-19 Solutions for the Healthcare Industry No problem, please let me know how it goes by.Observe and troubleshoot a Looker (Google Cloud core) instance 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |