SET
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The SET statement specifies a runtime option for the current session. The selected option remains in effect until the session is terminated or the option is changed using another SET statement.
This statement has the following format:
SET ACTUAL | ESTIMATED MAXROW n
SET AGGR_TIMESTAMPTZ ON|OFF
SET AUTOCOMMIT ON | OFF | READ
SET [NO]BATCH_COPY_OPTIM
SET [NO]CACHE_DYNAMIC
SET CONNECTION connection_name |NONE
SET DATE_FORMAT [value]
SET DECIMAL [value]
SET FLOAT_FORMAT 'format'
SET [NO]FLSQL
SET INSERTMODE DEFAULT | ROW | BULK
SET JOINOP NOTIMEOUT | TIMEOUT | TIMEOUT nnn
SET JOINOP TIMEOUTABORT nnn
SET JOINOP [NO]GREEDY
SET NOJOURNALING | JOURNALING [ON table_name]
SET MAXROWSTEP n
SET MONEY_FORMAT [value]
SET MONEY_PREC [value]
SET [NO]OJFLATTEN
SET [NO]OPTIMIZEONLY
SET NOPARTITION_PARTS | PARTITION_PARTS n
SET NOPARTITION_SCHEME | PARTITION_SCHEME {AUTO | NONE | HASH}
SET [NO]PRINTQRY
SET [NO]QEP [CONCISE | SEGMENTED]
SET QUERY_RESULT_CACHE {ON | OFF | X100 | INGRES}
SET RANDOM_SEED [value]
SET RESULT_STRUCTURE X100 | X100_ROW | HEAP
SET [NO]REUSE
SET [NO]SCHEMA
SET SERVER_TRACE ON | OFF [with-clause]
SET SESSION session access mode
[ADD PRIVILEGES (priv {,priv})
| DROP PRIVILEGES (priv {,priv})]
[WITH
ON_ERROR = ROLLBACK STATEMENT | TRANSACTION
| ON_USER_ERROR = NOROLLBACK | ROLLBACK TRANSACTION
| ON_LOGFULL = ABORT | COMMIT | NOTIFY
| DESCRIPTION = 'session description'
| NODESCRIPTION
| PRIORITY = INITIAL | MINIMUM | MAXIMUM | priority
| PRIVILEGES = (priv {,priv}) | ALL | DEFAULT
| NOPRIVILEGES]
SET SESSION READ ONLY | READ WRITE
[, ISOLATION LEVEL SERIALIZABLE | REPEATED READ |
READ COMMITTED | READ UNCOMMITTED]
SET SESSION AUTHORIZATION username | USER | CURRENT_USER
| SESSION_USER | SYSTEM_USER | INITIAL_USER
SET SESSION [NO]CACHE_DYNAMIC
SET SESSION COLLATION collation_name
SET SESSION [NO]OLD_COPY_DN
SET SESSION_TRACE ON | OFF [with-clause]
SET [NO]STATISTICS tablename
SET STRING_TRUNCATION IGNORE | WARN | FAIL
SET NOTRACE OUTPUT | TRACE OUTPUT 'filename'
SET [NO]TRACE POINT [value]
SET [NO]TRACE TERMINAL
SET TRANSACTION READ ONLY | READ WRITE
SET [NO]UNION_FLATTENING
Last modified date: 06/28/2024