| Author |
Running the sql files against database
|
Parameswaran Thangavel
Ranch Hand
Joined: Mar 01, 2005
Posts: 485
|
|
Hi all
I am having a n number of sql files which i need to execute against database.
Is there any easier way to execute all those sql files against database.
something like bat file or java class to invoke.
Any pointer will be greatly appreciated.
The database is DB2
OS: windows
|
 |
Jeanne Boyarsky
internet detective
Marshal
Joined: May 26, 2003
Posts: 26218
|
|
Parameswaran,
You can write a bat file that uses the db2 command line to run each file. I think the option is "-f" to run the sql in a file.
|
[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
|
|
 |
|
|
subject: Running the sql files against database
|
|
|
0
