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
 
Execute multiple DB2 Load commands in one request

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

New User


Joined: 13 Apr 2012
Posts: 59
Location: India

PostPosted: Wed Aug 03, 2016 12:53 pm    Post subject: Execute multiple DB2 Load commands in one request
Reply with quote

Hi,
I have a text file that contains multiple load commands to insert data into different tables. I want to run all these load commands in one request. Do we have any syntax so that the db2 command window picks all the load commands from the text file and execute them in one request.

Thanks
Faiz
Back to top
View user's profile Send private message

faizm

New User


Joined: 13 Apr 2012
Posts: 59
Location: India

PostPosted: Wed Aug 03, 2016 6:34 pm    Post subject: Reply to: Execute multiple DB2 Load commands in one request
Reply with quote

Any help would be highly appreciated. Thanks.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8406
Location: Dubuque, Iowa, USA

PostPosted: Wed Aug 03, 2016 6:54 pm    Post subject:
Reply with quote

People on this forum respond if and when they have time and interest and knowledge of the topic since they are all volunteers. Prompting for responses, especially after less than six hours, tends to cause the people who would have responded to not respond to avoid harassment when you don't like their answer. Furthermore, it is not unusual for responses to take a few days to show up -- and in some cases, there are no responses after weeks or months. This is normal.

If you insist on needing an answer so desperately, persuade your management to pay the money to hire a consultant to help you.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 2039
Location: NY,USA

PostPosted: Wed Aug 03, 2016 9:03 pm    Post subject:
Reply with quote

You probably need to look for a script under DB2's Command Line processing.
Back to top
View user's profile Send private message
Pandora-Box

Moderator


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

PostPosted: Thu Aug 04, 2016 12:49 pm    Post subject:
Reply with quote

DB2 Utility guide has all the details you need. Please read chapter 16 in utility guide.

Quote:
db2 command window picks all the load commands from the text file
what do you mean here?
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
This topic is locked: you cannot edit posts or make replies. DFSORT output in CSV for data spans i... hiravibk DFSORT/ICETOOL 3 Tue Nov 13, 2018 7:55 pm
No new posts Writing multiple records into a CSV r... hiravibk DFSORT/ICETOOL 2 Wed Nov 07, 2018 2:35 pm
No new posts Can we execute JES2 Commands in JES3? sakthikumarT JCL & VSAM 4 Tue Oct 02, 2018 11:55 pm
No new posts U0437 to execute IMS DC program Vkp321 IMS DB/DC 6 Wed Sep 19, 2018 8:39 pm
No new posts Need help on the multiple files refor... wik123 DFSORT/ICETOOL 7 Wed Sep 19, 2018 10:47 am

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