File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
author & internet detective
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:
subject: Running the sql files against database
Execute .sql file using java
Statements executing VERY slowly
PL/SQL query vs Stored Procs in JDBC
Web Application Design
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014