SQL Reference Guide > SQL Reference Guide > B. SQL Statements from Earlier Releases > Set_ingres Statement
Was this helpful?
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.
 
Last modified date: 01/30/2023