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: 1537
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 Db2 load job abending in SORT mistah kurtz DB2 4 Mon Jun 05, 2017 3:58 pm
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts Copy load modules and alias vasanthz IBM Tools 5 Thu Apr 20, 2017 6:31 am
No new posts Can DFSPARM override SORTKEYS paramet... ashek15 DB2 2 Tue Jan 31, 2017 11:36 pm
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm


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