Setting Defaults › How to Set Session Options › Setting Environment Options › Miscellaneous Environment Settings

Miscellaneous Environment Settings

The following commands control plan‑exit for DB2 and what happens after an error is encountered when processing a member.

SET ENVIRONMENT DB2PLAN‑EXIT program‑name

Enables or disables CA Ideal plan name exit program for the site or for the current session. This exit program can select or modify the name of the plan CA Ideal provides to DB2.

If the plan name exit is enabled, CA Ideal calls it before the first SQL statement in a logical unit of work. That is, it is called before the first SQL statement at the beginning of each CICS transaction and before the first SQL statement following each database Commit.

The first SQL statement can be embedded SQL, SQL generated by a FOR construct for a DB2 dataview, or SQL in a non‑ideal subprogram. A Commit can be a PDL TRANSMIT, CHECKPOINT, BACKOUT statement, or an SQL COMMIT or ROLLBACK statement.

SET ENVIRONMENT EXECERROR option

Specifies whether to quit or continue after an error resulting from the execution of commands in a member. Including this command in a member affects all commands that follow it in the member until the next SET ENVIRONMENT EXECERROR command or until the end of the member. Valid options are:

QUIT

Stop executing the member when any of the following statements causes an error.

CONTINUE

Continue executing the member when any of the following statements causes an error.

SET ASYNCMSG

Determines whether to display asynchronous messages on the terminal. This includes all messages indicating the completion of prints and compiles for the user. Valid options are:

USER

Displays all asynchronous messages whose short IDs match the user's short ID.

NONE

Does not display asynchronous messages.