java invocation of db2 clp

[Xela]

Hello,

I am trying to implement some etl feature driven by a java application. I
must work on windows and unixes, possibly without using command scriptings
or shells. I am focussing on windows. I try to have several load operations
executed inside a single connection. I can't succeed in doing that fully
from java, with calling db2 executable. The best I can do for now is to
lauch a db2cmd, get the db2clp env variable and then pass it to the java
programs exec("db2 ...") command. But I don't see how to initiate the CLP in
java (this launches au db2bp process, and it has to give the correct ID for
the java program to comunicate with it). Any help is welcome! Have a good
day!

Alexandre

[XiaoLu Wang]

"Xela" <ab***@yahoo.com> дÈëÓʼþ news:co**********@reader1.imaginet.fr...

Hello,

I am trying to implement some etl feature driven by a java application. I
must work on windows and unixes, possibly without using command scriptings
or shells. I am focussing on windows. I try to have several load operations executed inside a single connection. I can't succeed in doing that fully
from java, with calling db2 executable. The best I can do for now is to
lauch a db2cmd, get the db2clp env variable and then pass it to the java
programs exec("db2 ...") command. But I don't see how to initiate the CLP in java (this launches au db2bp process, and it has to give the correct ID for the java program to comunicate with it). Any help is welcome! Have a good
day!

Alexandre

Maybe you can put these operations into a store procedure, and call it for
Java.

[Xela]

Thank you for your suggestion.

Nevertheless, it is not acceptable for me. What I want is to invocate the
load utility from a java application program. I don't want to put server
side objects for this purpose. I guess that there is a quite simple way to
do this. Are there any parameter to givbe to db2bp? Can the file db2clp.dat
be usefull for this purpose? Thanks for your attention.

Alexandre
"XiaoLu Wang" <ha**********@yahoo.com.cn> wrote in message
news:Ae********************@rogers.com...

"Xela" <ab***@yahoo.com> дÈëÓʼþ news:co**********@reader1.imaginet.fr...

Hello,

I am trying to implement some etl feature driven by a java application. I
must work on windows and unixes, possibly without using command
scriptings
or shells. I am focussing on windows. I try to have several load

operations

executed inside a single connection. I can't succeed in doing that fully
from java, with calling db2 executable. The best I can do for now is to
lauch a db2cmd, get the db2clp env variable and then pass it to the java
programs exec("db2 ...") command. But I don't see how to initiate the CLP

in

java (this launches au db2bp process, and it has to give the correct ID

for

the java program to comunicate with it). Any help is welcome! Have a good
day!

Alexandre

Maybe you can put these operations into a store procedure, and call it for
Java.

[Knut Stolze]

Xela wrote:

Thank you for your suggestion.

Nevertheless, it is not acceptable for me. What I want is to invocate the
load utility from a java application program. I don't want to put server
side objects for this purpose. I guess that there is a quite simple way to
do this. Are there any parameter to givbe to db2bp? Can the file
db2clp.dat be usefull for this purpose? Thanks for your attention.

Could you call the LOAD API (possibly via JNI)?

--
Knut Stolze
Information Integration
IBM Germany / University of Jena

[Xela]

That would be a solution. But I looked at this and at the data structure
used. It seems to be rather complicated, and a more natural solution would
be to call the utilities. Am I wrong?

Alexandre
"Knut Stolze" <st****@de.ibm.com> wrote in message
news:cp**********@fsuj29.rz.uni-jena.de...

Xela wrote:

Thank you for your suggestion.

Nevertheless, it is not acceptable for me. What I want is to invocate the
load utility from a java application program. I don't want to put server
side objects for this purpose. I guess that there is a quite simple way
to
do this. Are there any parameter to givbe to db2bp? Can the file
db2clp.dat be usefull for this purpose? Thanks for your attention.

Could you call the LOAD API (possibly via JNI)?

--
Knut Stolze
Information Integration
IBM Germany / University of Jena

[Knut Stolze]

Xela wrote:

That would be a solution. But I looked at this and at the data structure
used. It seems to be rather complicated, and a more natural solution would
be to call the utilities. Am I wrong?

I don't see why. Basically, the utilities just call the API themselves.
The difference is only that you have to build some sort of text string that
describes the command whereas the API expects the said data structure that
you have to fill in. You only have to fill in some of the information and
not necessarily all of it.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena

[Xela]

I suppose that the development and debugging effort is bigger using
JNI.Moreover, we know the command line syntax. But if you have some samples
or a link to siome sample using JNI, I would appreciate to see them. Thanks
anyway for your answer.

Alexandre
"Knut Stolze" <st****@de.ibm.com> wrote in message
news:cp**********@fsuj29.rz.uni-jena.de...

Xela wrote:

That would be a solution. But I looked at this and at the data structure
used. It seems to be rather complicated, and a more natural solution
would
be to call the utilities. Am I wrong?

I don't see why. Basically, the utilities just call the API themselves.
The difference is only that you have to build some sort of text string
that
describes the command whereas the API expects the said data structure that
you have to fill in. You only have to fill in some of the information and
not necessarily all of it.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena