ROLLBACK

The ROLLBACK command is used to rollback an SQL transaction.

 

 ROLLBACK ------------- no keywords ----------------------------|

 

Keywords

There are no keywords associated with this command.

Comments / Warnings

It is your responsibility to ensure that commitment control has been started and configured if you are using an IBM i. If it is not, then an error will occur.

Examples

RDML

 

* Define the JSM message fields

DEFINE FIELD(#JSMSTS) TYPE(*CHAR) LENGTH(020)

DEFINE FIELD(#JSMMSG) TYPE(*CHAR) LENGTH(256)

 

USE BUILTIN(JSM_COMMAND) WITH_ARGS(ROLLBACK) TO_GET(#JSMSTS #JSMMSG)

 

RDMLX

 

Define Field(#JSMSTS) Type(*CHAR) Length(020)

Define Field(#JSMMSG) Type(*CHAR) Length(256)

Define Field(#JSMHND) Type(*Char) Length(4)

 

Use Builtin(JSMX_COMMAND) With_Args(#JSMHND RollBack) To_Get(#JSMSTS #JSMMSG)