SQLMESSAGES

The SQLMESSAGES option controls whether error messages are sent to the current output file.

Data type

BOOLEAN

Syntax

SQLMESSAGES = {YES|NO}

Arguments

YES

Error messages are sent to the current output file.

NO

Error messages are only stored as values of SQLERRM. (Default)

Notes

Typical Usage

You will want to set SQLMESSAGES to YES while you are developing an application so that you can diagnose errors quickly. When your application is in use, you will probably want it to capture and handle errors in a different manner with SQLMESSAGES set to NO.