Previous Topic

Next Topic

Set_ingres Statement

Permission required: All users.

The Set_ingres SQL 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.


© 2007 Ingres Corporation. All rights reserved.