Equivalent of Sybase's @@transtate in DB2

[pankaj_wolfhunter]

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

[Knut Stolze]

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

[pankaj_wolfhunter]

thanks knut.