The set autocommit on statement causes an implicit commit to occur after every successfully executed query, except those executed with prepare and describe statements. Set autocommit off means an explicit commit statement is required to commit a transaction. By default, autocommit is off. The set autocommit statement cannot be issued in an open transaction.

If autocommit is on and a cursor is opened, Enterprise Access does not issue a commit until the close cursor statement is executed because cursors are logically a single statement. A rollback statement can be issued when a cursor is open. To restore the default behavior (and enable multi-query transactions), issue the set autocommit off statement.

The set trace statement enables tracing of individual gateway sessions. For information on set trace syntax, trace identifiers and examples, see Debugging with the Tracing Facility in the Enterprise Access Administrator Guide.

The set random_seed statement sets the beginning value for the random functions. Note that the seed value can be any integer. If the seed value is omitted, Enterprise Access multiplies the process ID of the slave by the number of seconds past 1/1/1970 until now.