470,638 Members | 1,579 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,638 developers. It's quick & easy.

Attaching a CLI-Connection to the static SQL connection


Hi,

We are trying to migrate an application from Oracle to DB2. In Oracle we
used some functionality to attach a dynamic SQL - connection to the static
SQL Connection in order to perform SQL in one transaction in both static
and dynamic SQL code.

We would like to connect to the database using EXEC SQL CONNECT
TO... and then use one of the CLI-methods to perform SQL in the same
transaction.

Is something similar possible in DB2? I could not find anything useful in
the docs.

Thanks... Dominik.
Jan 2 '06 #1
2 1310
Dominik Stadler wrote:
We are trying to migrate an application from Oracle to DB2. In Oracle we
used some functionality to attach a dynamic SQL - connection to the static
SQL Connection in order to perform SQL in one transaction in both static
and dynamic SQL code.
What do you need CLI for in that case? You could also use embedded dynamic
SQL if you'd like.
We would like to connect to the database using EXEC SQL CONNECT
TO... and then use one of the CLI-methods to perform SQL in the same
transaction.

Is something similar possible in DB2? I could not find anything useful in
the docs.


There is some description and further references for the other way around
here:
http://publib.boulder.ibm.com/infoce...d/c0004150.htm

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Jan 2 '06 #2

Hi,
What do you need CLI for in that case? You could also use embedded dynamic
SQL if you'd like.


I am looking at migrating a complex suite of applications that does all
sorts of things. It consists of different parts that were written in
different decades and later connected by attaching one connection to the
other. Usage of static SQL and OCI (the Oracle equivalent of CLI) is
spread throughout big parts of the code, therefore changing it would mean
a lot of effort.

Thanks anyway for your suggestions, I'll take a look at the link...
Dominik.

Jan 2 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Ioannis Vranos | last post: by
2 posts views Thread by None | last post: by
81 posts views Thread by Don Kim | last post: by
5 posts views Thread by comp.lang.php | last post: by
5 posts views Thread by lukemack | last post: by
4 posts views Thread by Steve | last post: by
2 posts views Thread by Peter Oliphant | last post: by
???
1 post views Thread by Stoney L | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.