SQL Language Guide : 8. SQL Statements : SET
 
Share this page                  
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 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 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 MONEY_FORMAT [value]
SET MONEY_PREC [value]
SET [NO]OJFLATTEN
SET [NO]OPTIMIZEONLY
SET [NO]PRINTQRY
SET [NO]QEP [CONCISE | SEGMENTED]
SET RANDOM_SEED [value]
SET RESULT_STRUCTURE VECTORWISE | VECTORWISE_ROW | HEAP
SET [NO]REUSE
SET [NO]SCHEMA
SET SERVER_TRACE ON | OFF [with-clause]
SET SESSION
       [ADD PRIVILEGES ( priv {,priv} )
       |DROP PRIVILEGES ( priv {,priv}) ]
       [WITH
             ON_ERROR = ROLLBACK STATEMENT | TRANSACTION
             ON_USER_ERROR = ROLLBACK TRANSACTION | NOROLLBACK
             | DESCRIPTION ='session_description'
             | NODESCRIPTION
             | PRIORITY = INITIAL | MINIMUM | MAXIMUM | priority
             | PRIVILEGES = ( priv {, priv}) |ALL | DEFAULT
             | NOPRIVILEGES
              ON_LOGFULL = COMMIT | ABORT | NOTIFY]
SET SESSION AUTHORIZATION username | USER | CURRENT_USER
                   SESSION_USER | SYSTEM_USER | INITIAL_USER
SET SESSION [NO]CACHE_DYNAMIC
SET SESSION READ ONLY | READ WRITE
SET SESSION_TRACE ON | OFF [with-clause]
SET SESSION WITH
             ON_ERROR = ROLLBACK STATEMENT | TRANSACTION
             ON_USER_ERROR = ROLLBACK TRANSACTION | NOROLLBACK
               | DESCRIPTION ='session_description'
               | NODESCRIPTION
               | PRIORITY = INITIAL | MINIMUM | MAXIMUM | priority
SET [NO]STATISTICS tablename
SET NOTRACE OUTPUT | TRACE OUTPUT filename
SET [NO]TRACE POINT [value]
SET TRANSACTION READ ONLY | READ WRITE
SET [NO]UNION_FLATTENING