469,951 Members | 2,706 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Equivalent of Sybase's @@transtate in DB2

Greetings,

In Sybase global variable @@transtate keeps track of the current state
of a transaction. Sybase server determines what state to return by
keeping track of any transaction changes after a statement executes.
@@transtate may contain the following values:

0
Transaction in progress. A transaction is in effect; the previous
statement executed successfully.

1
Transaction succeeded. The transaction completed and committed its
changes.

2
Statement aborted. The previous statement was aborted; no effect on
the transaction.

3
Transaction aborted. The transaction aborted and rolled back any
changes.
In DB2, is this the same as checking the SQLCODE after each transaction
or something else?

Any help would be appreciated.

TIA

Jan 16 '06 #1
2 1795
pa***************@yahoo.co.in wrote:
Greetings,

In Sybase global variable @@transtate keeps track of the current state
of a transaction. Sybase server determines what state to return by
keeping track of any transaction changes after a statement executes.
@@transtate may contain the following values:

0
Transaction in progress. A transaction is in effect; the previous
statement executed successfully.

1
Transaction succeeded. The transaction completed and committed its
changes.

2
Statement aborted. The previous statement was aborted; no effect on
the transaction.

3
Transaction aborted. The transaction aborted and rolled back any
changes.
In DB2, is this the same as checking the SQLCODE after each transaction
or something else?


After each SQL statement.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Jan 16 '06 #2
thanks knut.

Jan 16 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

14 posts views Thread by John | last post: by
2 posts views Thread by Michael Foord | last post: by
6 posts views Thread by Frank Rachel | last post: by
7 posts views Thread by Tim Conner | last post: by
10 posts views Thread by karch | last post: by
9 posts views Thread by Alan Silver | last post: by
14 posts views Thread by grid | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.