Attaching a CLI-Connection to the static SQL connection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dominik Stadler - 02 Jan 2006 12:07 GMT

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.

Reply to this Message

Knut Stolze - 02 Jan 2006 14:08 GMT

> 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/infocenter/db2luw/v8//topic/com.ibm.db2.udb.doc/ad
/c0004150.htm

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message

Dominik Stadler - 02 Jan 2006 17:36 GMT

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.

Reply to this Message