View previous topic :: View next topic
|
Author |
Message |
faizm
New User
Joined: 13 Apr 2012 Posts: 59 Location: India
|
|
|
|
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 |
|
|
faizm
New User
Joined: 13 Apr 2012 Posts: 59 Location: India
|
|
|
|
Any help would be highly appreciated. Thanks. |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
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 |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3048 Location: NYC,USA
|
|
|
|
You probably need to look for a script under DB2's Command Line processing. |
|
Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
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 |
|
|
|