By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,586 Members | 2,347 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,586 IT Pros & Developers. It's quick & easy.

Multiple connections to the same database in Cobol

P: n/a
We are developping an application. The application is written in Cobol,
for the database the client can use either a DB2 UDB on Unix systems or
a DB2 V 7 on z/OS. The application itself can run on Windows or z/OS,
if the database is on z/OS, we are using DRDA for the dataaccess for
the GUI parts.
We have to insert and commit messages in a database table, although the
enclosing transaction should be rollbacked.
By using only one connection, the messages are rollbacked if the whole
transaction is rollbacked.
Is it possible to use two transations and to write data on the first
connection, write and commit messages on the second connection and then
rollback the written data?
Thanx

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
tilmann wrote:
We are developping an application. The application is written in Cobol,
for the database the client can use either a DB2 UDB on Unix systems or
a DB2 V 7 on z/OS. The application itself can run on Windows or z/OS,
if the database is on z/OS, we are using DRDA for the dataaccess for
the GUI parts.
We have to insert and commit messages in a database table, although the
enclosing transaction should be rollbacked.
By using only one connection, the messages are rollbacked if the whole
transaction is rollbacked.
Is it possible to use two transations and to write data on the first
connection, write and commit messages on the second connection and then
rollback the written data?


The usual technique for that is to use multiple threads. I don't know if
Cobol supports threads.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.