IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Explain this DB2 load jcl


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
meenu_laul

New User


Joined: 26 May 2006
Posts: 5

PostPosted: Wed Aug 16, 2006 8:43 pm
Reply with quote

Code:

//LOAD01A EXEC PGM=DSNUTILB,                                 
//             REGION=0M,                                   
//             PARM=(DB2T,'LOADNVL')                         
//ABNLIGNR  DD DUMMY                                         
//DSSPRINT  DD SYSOUT=*                                     
//SYSPRINT  DD SYSOUT=*                                     
//SYSUDUMP  DD SYSOUT=F                                     
//UTPRINT   DD SYSOUT=*                                     
//SYSOUT    DD SYSOUT=*                                     
//SYSIN     DD *                                             
             LOAD DATA  INDDN SYSREC  LOG NO   MAPDDN SYSMAP
             RESUME YES                                     
             ENFORCE NO                                     
             SORTDEVT SYSDA     SORTNUM 12                   
             WORKDDN (SYSUT1,SORTOUT)                       
             INTO TABLE NVL.RETAIL_INVOICE     
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2358
Location: Israel

PostPosted: Wed Aug 16, 2006 8:50 pm
Reply with quote

DSNUTILB is just a method to invoke regular DB2 utilities. To learn more about the LOAD utility, please refer to the fine manual.

O.
Back to top
View user's profile Send private message
guruji
Warnings : 1

New User


Joined: 13 Apr 2007
Posts: 59
Location: Chennai

PostPosted: Wed Jun 13, 2007 5:42 pm
Reply with quote

Hi,

Can you please explain the terms in SYSIN DD *?
Or please suggest some links from where I get a bettter understanding of LOAD JCL, especially DSNUTILB?

Thanks,
Reni
Back to top
View user's profile Send private message
Pandora-Box

Global Moderator


Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy

PostPosted: Wed Jun 13, 2007 5:45 pm
Reply with quote

Please go through the link provided by ofer71
Back to top
View user's profile Send private message
guruji
Warnings : 1

New User


Joined: 13 Apr 2007
Posts: 59
Location: Chennai

PostPosted: Wed Jun 13, 2007 5:53 pm
Reply with quote

Thank you
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts How to load to DB2 with column level ... DB2 6
No new posts REASON 00D70014 in load utility DB2 6
No new posts DB2 Statistics - Using EXPLAIN and qu... DB2 1
No new posts DB2 Load - Sort Or order BY DB2 1
Search our Forums:

Back to Top