THROW RETRY

General Form:

THROW RETRY [ conn]

Where:

conn= any numeric expression reducing to a database connection handle


THROW RETRY allows a program to abandon the transaction specified by the optional connection number and restart it from the top level WHILE TRANS. If no connection number is specified then it will be assumed to be with respect to the current innermost transaction. It is an error to issue a THROW RETRY outside of a WHILE TRANS ... END TRANS block. The database update will be abandoned and control will resume after the WHILE TRANS for the outermost matching transaction though any FINALLY blocks will be executed to provide explicit tidy up code.

Compatibility

THROW RETRY, together with WHILE TRANS was introduced in KCML 6.60.

See also:

WHILE TRANS
THROW ROLLBACK