Your application must not issue the following statements in an Ingres multi-statement transaction:

However, when your application issues these statements, they must be issued with an XA transaction, demarcated as required by your TP vendor software. To determine whether your application is in a transaction, issue the following Ingres SQL statement:

For details about INQUIRE_SQL, see the SQL Reference Guide.

To avoid conflicts with Ingres transaction states, you can use environment variables to specify a set of SQL statements to be sent to the Ingres DBMS whenever Ingres DTP creates a connection to an Ingres database. The following environment variables are listed in the order in which their corresponding statements are sent to the DBMS:

For details about these environment variables, see the System Administrator Guide. To set the environment variables for your entire Ingres installation, use the following command:

To set the environment variables for your current session, use the following command:

Any SET statements issued by your application after a connection is made override the settings established by the preceding environment variables.

Non-DTP Ingres SQL applications establish connections by issuing the CONNECT statement. In Ingres DTP applications, the CONNECT statement is not required (and is not valid). Connections to databases are made by Ingres DTP on behalf of your application-typically (though not always), a connection is established the first time your application accesses the RMI for which the connection is required.