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)