Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Load a table with the data from a dataset

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Bhagyalakshmi C

New User


Joined: 24 Jul 2007
Posts: 38
Location: Bangalore

PostPosted: Tue Aug 21, 2007 5:18 pm    Post subject: Load a table with the data from a dataset
Reply with quote

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]
Back to top
View user's profile Send private message

saiprasadh

Active User


Joined: 20 Sep 2006
Posts: 154
Location: US

PostPosted: Tue Aug 21, 2007 5:40 pm    Post subject:
Reply with quote

Hi lakshmi,

Can you explain about the parameter 'V51A,DSNTEX' mention in the PARM.


Thanks
sai
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Aug 21, 2007 10:34 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Tue Aug 21, 2007 10:58 pm    Post subject:
Reply with quote

PARM needs to point to the actual subsystem you need, examples from my site:
DB2P
DB2B
DB2A
DB2U

Other than that I can't say on the rest of it.
Back to top
View user's profile Send private message
Bhagyalakshmi C

New User


Joined: 24 Jul 2007
Posts: 38
Location: Bangalore

PostPosted: Wed Aug 22, 2007 10:47 am    Post subject:
Reply with quote

Thanks all!!!!

I will find it out.

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 Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Copy 4 byte of data from the last rec... arunsoods DFSORT/ICETOOL 9 Fri Oct 06, 2017 12:15 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts opening a dataset after reading it fr... arunsoods DFSORT/ICETOOL 5 Wed Oct 04, 2017 3:54 pm
This topic is locked: you cannot edit posts or make replies. PS file data should be passed as symb... d_sarlie JCL & VSAM 15 Tue Oct 03, 2017 5:18 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us