JCL to Load multiple tables from files
Moderators: Frank Yaeger, DikDude, Moderator Group
JCL to Load multiple tables from files
Does anyone have JCL to load Multiple tables from different files?
-
- Moderator
- Posts: 1625
- Joined: Sat Aug 09, 2008 9:02 am
- Location: Mumbai, India
-
- Member
- Posts: 2
- Joined: Wed Nov 16, 2011 2:35 pm
- Location: bangalore
-
- Member
- Posts: 2
- Joined: Wed Nov 16, 2011 2:35 pm
- Location: bangalore
#
//UCSA15UL JOB 'UNLOAD',NOTIFY=UCSA015
#
//STEPNA EXEC DSNUPROC,UID='SMPLUNLD',UTPROC='',SYSTEM='DB2A'
#
//SYSREC DD DSN=UCSA015.SMPLUNLD.SYSREC3,
#
// DISP=SHR
#
//SYSPRINT DD SYSOUT=*
#
//SYSIN DD *
#
LOAD DATA INDDN SYSREC LOG NO RESUME YES
#
EBCDIC CCSID(00037,00000,00000)
#
INTO TABLE "UCSA004"."EMP"
//UCSA15UL JOB 'UNLOAD',NOTIFY=UCSA015
#
//STEPNA EXEC DSNUPROC,UID='SMPLUNLD',UTPROC='',SYSTEM='DB2A'
#
//SYSREC DD DSN=UCSA015.SMPLUNLD.SYSREC3,
#
// DISP=SHR
#
//SYSPRINT DD SYSOUT=*
#
//SYSIN DD *
#
LOAD DATA INDDN SYSREC LOG NO RESUME YES
#
EBCDIC CCSID(00037,00000,00000)
#
INTO TABLE "UCSA004"."EMP"
vinay kona
- dbzTHEdinosauer
- Moderator
- Posts: 981
- Joined: Mon Oct 02, 2006 8:31 pm
again, look at the manual for the 'load/unload' utility that you want to use
and the syntax will there for you to learn.
asking your site support for basic jcl used by the site to load/unload db2 tables
is one of those questions an experienced programmer always asks.
to use some jcl found on the web is something a rookie programmer would do.
and the syntax will there for you to learn.
asking your site support for basic jcl used by the site to load/unload db2 tables
is one of those questions an experienced programmer always asks.
to use some jcl found on the web is something a rookie programmer would do.
Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.
-
- Moderator
- Posts: 1625
- Joined: Sat Aug 09, 2008 9:02 am
- Location: Mumbai, India
Hi vinay kona - when I asked archup20 that does s/he know "how to load a single table "using JCL"?" - I was trying to say, if you can load one table, possibly by modifying the same JCL you can load multiple/more tables as well. I was not looking for a load JCL for myself at all.
And as Dick has pointed out such JCLs are usually specific to respective shops and we should not be using a JCL from online Forums like this. We can take references from here, however, using the exact syntax might lead to unforeseen consequences, may be nasty.
And as Dick has pointed out such JCLs are usually specific to respective shops and we should not be using a JCL from online Forums like this. We can take references from here, however, using the exact syntax might lead to unforeseen consequences, may be nasty.
Regards,
Anuj
Anuj
FREE TUTORIALS
Tutorials
Free tutorials from mainframegurukul
- JCL Tutorial
Covers all important JCL concepts. - Cobol Tutorial
This tutorials covers all Cobol Topics from STRING to COMP-3. - DB2 Tutorial
DB2 Tutorial focuses on DB2 COBOL Programming. - SORT Tutorial
This Tutorial covers all important aspects of DFSORT with examples - CICS Tutorial
This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program - FILEAID Reference
Explains how to browse , edit and delete datasets - Change Man Reference
Quick Start tutorial on Changeman - Abend Reference
Important Abend codes explained - FaceBook Page
MainframeGurukul FaceBook Page - LinkedIn Page
MainframeGurkul Linkedin Page