Chapter 5 Database Options
173
SET OPTION PUBLIC.AUDITING = ’ON’
AUTO_COMMIT option [ISQL]
Controls whether a COMMIT is performed after each statement.
ON, OFF
OFF
If AUTO_COMMIT is on, a database COMMIT is performed after each
successful statement. If the COMMIT fails, you have the option to execute
additional SQL statements and perform the COMMIT again, or execute a
ROLLBACK statement.
By default, a COMMIT or ROLLBACK is performed only when the user
issues a COMMIT or ROLLBACK statement or a SQL statement that causes
an automatic commit (such as the CREATE TABLE statement).
AUTO_REFETCH option [ISQL]
Controls whether query results are fetched again after deletes, updates, and
inserts.
ON, OFF
ON
If AUTO_REFETCH is on, the current query results that are displayed in the
Data window will be refetched from the database after any INSERT,
UPDATE or DELETE statement. Depending on how complicated the query
is, this may take some time. For this reason, it can be turned off.
AUTOMATIC_TIMESTAMP option
Controls interpretation of new columns with the TIMESTAMP data type.
ON, OFF
OFF
Function
Allowed values
Default
Description
Function
Allowed values
Default
Description
Function
Allowed values
Default
To Next Page
Loading...