ROLLBACK

Syntax

ROLLBACK

Description

An automatic rollback is performed whenever SQR ends due to program errors. ROLLBACK is useful for testing or for certain error conditions.

ROLLBACK is an SQR command and should not be used inside an SQL paragraph.

Note:

The ROLLBACK command can be used with Oracle, DB2 , and ODBC (Microsoft SQL Server is accessible only with SQR Server for ODBC). For Microsoft SQL Server , use BEGIN TRANSACTION and ROLLBACK TRANSACTION within SQL paragraphs as in the following example. See the COMMIT command for an example of ROLLBACK.

Example

The following example shows the ROLLBACK command:

if #error-status = 1
   rollback
   stop
end-if

See The COMMIT command