Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Explain this DB2 load jcl

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Explain this DB2 load jcl
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: 2360
Location: Israel

PostPosted: Wed Aug 16, 2006 8:50 pm    Post subject:
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: Bangalore

PostPosted: Wed Jun 13, 2007 5:42 pm    Post subject:
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

Moderator


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

PostPosted: Wed Jun 13, 2007 5:45 pm    Post subject:
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: Bangalore

PostPosted: Wed Jun 13, 2007 5:53 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm
No new posts Copybook structure in Load module Vai123 COBOL Programming 7 Fri Sep 16, 2016 8:29 pm
This topic is locked: you cannot edit posts or make replies. ERROR WHILE SUBMITTING LOAD JOB ANURADHA NEELAKANTAN JCL & VSAM 12 Thu Aug 25, 2016 11:50 am
No new posts Execute multiple DB2 Load commands in... faizm DB2 4 Wed Aug 03, 2016 12:53 pm
No new posts Search a Load Module sreekanth1984 TSO/ISPF 8 Tue Jun 07, 2016 8:45 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us