JCL to Load multiple tables from files

In this Mainframe Forum - You can post your queries on JCL, OS/390 JCL, MVS JCL, z/OS JCL, JES2 & JES3

Moderators: Frank Yaeger, DikDude, Moderator Group

Post Reply
archup20
Member
Posts: 31
Joined: Thu Dec 09, 2010 9:53 am

JCL to Load multiple tables from files

Post by archup20 » Thu Oct 13, 2011 9:24 am

Does anyone have JCL to load Multiple tables from different files?

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Thu Oct 13, 2011 8:21 pm

You need to more clearly explain what you want.

I suspect this is not a JCL question, but a database questoin of some kind.

Show what you "have" and what you want to do with it.
Have a good one

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Sat Oct 15, 2011 5:50 pm

archup20 wrote:Does anyone have JCL to load Multiple tables from different files?
Do you know how to load a single table "using JCL"?
Regards,
Anuj

vinay kona
Member
Posts: 2
Joined: Wed Nov 16, 2011 2:35 pm
Location: bangalore

Post by vinay kona » Wed Nov 16, 2011 3:43 pm

hi anuj,
this is vinay kona
i will give u load jcl.it might be useful to u .just let me know u have any doubt in the above parameters
:|
vinay kona

vinay kona
Member
Posts: 2
Joined: Wed Nov 16, 2011 2:35 pm
Location: bangalore

Post by vinay kona » Wed Nov 16, 2011 3:44 pm

#
//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

User avatar
dbzTHEdinosauer
Moderator
Posts: 981
Joined: Mon Oct 02, 2006 8:31 pm

Post by dbzTHEdinosauer » Wed Nov 16, 2011 7:09 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.
Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Thu Nov 17, 2011 12:02 pm

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.
Regards,
Anuj

Post Reply

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



Other References
Mainframe Tools and others