is it possible to call db2 (ver 7.2 on windows) utilities such as LOAD from java code ? if yes, how ?

For export and import you have C APIs ... You can call them using JNI .. Refer the manual Adminstrative APIs for more information on these APIS

From V8, LOAD also has an API ...


The other alternative is to invoke a command line from the Java code ...

Cheers
Sathyaram
Cheers
Sathyaram

invoking the command line from java sounds like an option. Is there any code I can use to show our developers.

thanks.
Anil

This is used extensively
http://www.devdaily.com/java/edu/pj/...pj010016.shtml
gives a basic java example ..

Instead of ps -ef, you may use (this is a ksh example)
db2_export.ksh sample1 table1.ixf ixf "select * from table1"

where the db2_export.ksh script will be
#/bin/ksh
#
#
db2 connect to $1
db2 export to $2 of $3 $4 with ur
db2 terminate

Cheers
Sathyaram

Here is an example from IBM on how to use the command line from java:

http://www.developer.ibm.com/tech/sampdb2.html

Look at the runstats one in particular.

Andy