Enabling optimized message transfers

About this task

To enable optimized message transfers, or message chaining, you must set the following variables in the client environment:

Procedure

  1. Set the OPTMSG environment variable at run time to enable optimized message transfers for all qualifying SQL statements.
  2. Set the OptMsg global variable within the HCL OneDB™ ESQL/C application to control which SQL statements use message chaining.