Valid in: ESQL

The SET_SQL statement specifies runtime options for the current session.

The SET_SQL statement can switch sessions in a multiple session application, specify the type of DBMS error to be returned to an application, change the default behavior when a connection error is experienced, set trace functions, and set other session characteristics.

SET_SQL can be used to override II_EMBED_SET. For more information about II_EMBED_SET, see the Ingres System Administrator Guide.