Pb load command JDBC driver

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lm - 21 Feb 2006 17:57 GMT

Hi,

How can i use JDBC driver to load some datas from DB2 DBMS with the load
command
and a specific delimiter ?
Can u give me a sample ?
[please i'm a newbie and it's very important]

Best regards

Reply to this Message

Eugene F - 21 Feb 2006 18:07 GMT

There is no java API to DB2 load facility, only C/C++.

-Eugene

Reply to this Message

Knut Stolze - 21 Feb 2006 18:18 GMT

> There is no java API to DB2 load facility, only C/C++.

You could wrap the call to the LOAD in a (C/C++) stored procedure and invoke
the procedure through the usual means. But that would require that the
file to be loaded resides on the database server.

Otherwise, you have to resort to JNI or so...

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message

Eugene F - 21 Feb 2006 19:23 GMT

Some time back there was a promise to publish a SQL API to the LOAD as
part ADMIN_CMD procedure along with SQL calls to EXPORT, RUNSTATS etc ,
but it's still not there with the current V8fp11, may be in Viper?
Making call from java to a SQL stored proc like that would be much
easier that using C/C++ API or a JNI wrapper to LOAD (IMHO).

-Eugene

Reply to this Message