Bhagyalakshmi C
New User
Joined: 24 Jul 2007 Posts: 38 Location: Bangalore
|
|
|
|
Hi all,
I want to load a table with the data from a dataset. I learned that this can be done using a load utility.
//EXESTP EXEC PGM=DSNUTILB
// REGION=1024K,
// PARM='V51A,DSNTEX'
// STEPLIB DD DSN=DSN510.SDSNLOAD,DISP=SHR
//**********************************************************
//* DATA SETS USED BY THE UTILITY
//**********************************************************
//SORTOUT DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)
//SORTWK01 DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)
//SYSDISC DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)
//SYSERR DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)
//SYSMAP DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)
//TABLDS DD DSN=BHAGYA.SAMP.DB2TAB,
// DISP=SHR
//SYSUT1 DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)
//SYSPRINT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSIN DD *
LOAD DATA INDDN TABLDS
INTO TABLE EMPLOYEE
/*
this is my JCL. Here BHAGYA.SAMP.DB2TAB is the dataset which contains the data and EMPLOYEE is the table which needs to be populated.
I am doing((want to do)) a load-replace.
I am getting the error as
DSNUTILB - DB2 SYSTEM DOES NOT EXIST
DSNUTILB - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8
I wrote this JCL after reading the manuals only, but not getting the output.
Can any one help me in this!!!
Tell me what are all the changes i need to do in this..
Thank you!!!!!!!!!
[/code] |
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
If you talk with your database support people, they can tell you what you need to load data in your environment - assuming of course, that you have the proper permissions to do this. |
|