SQL Reference Guide > SQL Reference Guide > H. 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, specifies which type of DBMS server error is returned to an application, changes the default behavior when a connection error is experienced, and sets 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: 04/03/2024