Command

Keyword

Value

Developer notes

SET

ONERROR

*ROLLBACK

Optional. The keyword is used to indicate the action you want to take if an exception is encountered during the execution of the SQL statement.

If an exception is encountered during the execution of the SQL statement, a rollback will be initiated.

*CONTINUE

If an exception is encountered during the execution of the SQL statement, the processing will continue.

*DISCONNECT

If an exception is encountered during the execution of the SQL statement, the database connection will be closed.

Default.

ONWARNING

*STOP

Optional. This keyword is used to indicate the action you wish to take if a warning message is issued during the execution of the SQL statement.

If a warning is encountered during the execution of the SQL statement, the command will be stopped.

Default.

*CONTINUE

If a warning is encountered during the execution of the SQL statement, the processing will continue.

READONLY

*YES

Optional. Enables database connection read-only mode.

No default.

*NO

Disables database connection read-only mode.

AUTOCOMMIT

*YES

Optional. Enables database connection auto-commit mode.

No default.

*NO

Disables database connection auto-commit mode.

ISOLATION

*NONE

Optional. Set connection transaction isolation level to NONE.

No default.

*READCOMMITTED

Set connection transaction isolation level to READ COMMITTED.

*READUNCOMMITTED

Set connection transaction isolation level to READ UNCOMMITTED.

*REPEATABLEREAD

Set connection transaction isolation level to REPEATABLE READ.

*SERIALIZABLE

Set connection transaction isolation level to SERIALIZABLE.

SQLSTATE

*NONE

Optional. SQLException returns ERROR status.
SQLWarning returns WARNING status.

Default.

*ALL

SQLException and SQLWarning return SQLxxxxx status.

*ERROR

SQLException returns SQLxxxxx status.
SQLWarning returns WARNING status.

*WARNING

SQLWarning returns SQLxxxxx status.
SQLException returns ERROR status.

MAXROWS

integer

Optional. Specifies the maximum number of rows to be returned by a query.

*NOMAX

Default.

PARAMETER

*NONE

Optional. The PARAMETER keyword can be used to prepare the SQL statement prior to running the EXECUTE or READ commands. The value you specify here depends very much on the type of activity you wish to perform on the database.

Use the *NONE value to clear the current map, list and SQL statements.

*LIST

Use this value if you intend to use the UPDATE keyword of the EXECUTE command. When taking this approach, the values that you intend to add to, update, or delete from the database will be specified in a list that is included in the SERVICE_LIST of this command. It is recommended that you use this option if you will be updating (or inserting or deleting) more than a single record. If you have multiple records and don't use this value, you would have to run the EXECUTE as many times as there are records, and this would place unnecessary load on your system and network. Please refer to the following Lists and Variables and the Examples for this command.

*SQL

Set this value if to intend to prepare the SQL statement in advance of the EXECUTE command. By doing so, you place your SQL statement into a working list that is passed in the SERVICE_LIST of this command.
This feature is particularly useful if you are going to be using long SQL statements. It is particularly useful for RDML applications where the longest field length can only be 256 characters. Please refer to the following Lists and Variables and Examples following this table for further information.

*CALL

Set this value if you intend to use call procedures that have IN, OUT and INOUT parameters.

*MAP

If you are expecting a large result set to be returned from a query, then you should choose to use the READ command to receive the list of values. To use the READ command you need to set this keyword to *MAP to indicate that the SERVICE_LIST of this command will contain the column and field mapping information. For further information, refer to the following Lists and Variables and the Examples for this command.