Sample JCL for DSNUTILB required!!!

Balaji_Gowda

Sample JCL for DSNUTILB required!!!
Hi,

I want to upload data from a flat file to a DB2 table using the DB2
utility DSNUTILB.

Can someone please provide me with a sample JCL?




Regards
Balaji.H.M

**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Avram Friedman

Re: Sample JCL for DSNUTILB required!!!
(in response to Balaji_Gowda)
From you use of the word JCL
I assume you mean DB2 for Z/os
You may find instructions for the LOAD utility including the required JCL at
http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnugh17/2.1.6?DT=20050720160716 for V7

I would also think you would need far more than the JCL which is trivial.

Here is a snip form SDSNSAMP(DSNTEJ1) a DB2 sample job.
Step 12 (displayed in part) loads a sample table from a flat file

//*
//* STEP 12: LOAD DATA INTO SAMPLE PROGRAM TABLES
//*
//PH01S12 EXEC DSNUPROC,PARM='DBT1,DSNTEX',COND=(4,LT)
//SORTLIB DD DSN=SYS1.SORTLIB,DISP=SHR
//SORTOUT DD UNIT=VIO,SPACE=(4000,(20,20),,,ROUND)
//DSNTRACE DD SYSOUT=*
//SYSRECDT DD DSN=DBSSHR.SOFT.DB2.V810.SDSNSAMP(DSN8LDT),
// DISP=SHR
//SYSUT1 DD UNIT=VIO,SPACE=(4000,(50,50),,,ROUND)
//SYSIN DD *
LOAD DATA INDDN(SYSRECDT) CONTINUEIF(72:72)='X' RESUME(YES)
INTO TABLE DSN8810.TDSPTXT
(DSPINDEX POSITION( 2) CHAR(2),
LINENO POSITION( 6) CHAR(2),
DSPLINE POSITION(80) CHAR(71))
SORTDEVT SYSDA SORTNUM 4
//*




Balaji_Gowda <[login to unmask email]> wrote:
Hi,

I want to upload data from a flat file to a DB2 table using the DB2
utility DSNUTILB.

Can someone please provide me with a sample JCL?




Regards
Balaji.H.M

**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm




Avram Friedman
(877)311-0480 Voice Mail
[login to unmask email]
Http://www.IBMsysProg.com




---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm