A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Running the sql files against database
Joined: Mar 01, 2005
Jan 19, 2007 09:11:00
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
class to invoke.
Any pointer will be greatly appreciated.
The database is DB2
Joined: May 26, 2003
Jan 19, 2007 17:28:00
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.
How To Ask Questions The Smart Way
Blogging on Certs:
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
I agree. Here's the link:
- if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
subject: Running the sql files against database
Execute .sql file using java
PL/SQL query vs Stored Procs in JDBC
Statements executing VERY slowly
Web Application Design
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013