COMMIT

The COMMIT command is used to commit an SQL transaction.

 

 COMMIT ------------- 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(COMMIT) 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 Commit) To_Get(#JSMSTS #JSMMSG)