OPTMSG environment variable

Set the OPTMSG environment variable at runtime before you start the application to enable (or disable) optimized message transfers (message chaining) for all SQL statements in the application.

1  setenv OPTMSG
2.1! 0
2.1 1
disables optimized message transfers.
enables optimized message transfers and implements the feature for any subsequent connection.

The default value is 0 (zero), which explicitly disables message chaining. You might want, for example, to disable optimized message transfers for statements that require immediate replies, for debugging, or to ensure that the database server processes all messages before the application terminates.

When you set OPTMSG within an application, you can activate or deactivate optimized message transfers for each connection or within each thread. To enable optimized message transfers, you must set OPTMSG before you establish a connection.

For more information about setting OPTMSG and defining related global variables, see the HCL OneDB™ ESQL/C Programmer's Manual.