B. SQL Statements from Earlier Releases : Set_ingres Statement
 
Share this page                  
Set_ingres Statement
Permission required: All users.
The Set_ingres statement switches sessions in a multiple session application, specify which type of DBMS server error is returned to an application, change the default behavior when a connection error is experienced, and set trace functions.
Set_ingres can be used to override II_EMBED_SET if it is defined. For example, you can issue a set_ingres statement with the errortype object to override the error type default defined by II_EMBED_SET. Similarly, setting printqry or printgca can override the defaults defined by II_EMBED_SET. For more information about II_EMBED_SET, see the Database Administrator Guide.
This statement has the following format:
EXEC SQL SET_INGRES (object = value {, object = value})
Note:  This statement must be terminated according to the rules of your host language.