2. Statements : OpenROAD SQL Statements : Set Statement
 
Share this page                  
Set Statement
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.
Note:  This statement has additional considerations when used in a distributed environment. For more information, see the Ingres Star User Guide.
This statement has the following syntax:
set autocommit on | off
set [no]batch_copy_optim
set [no]cache_dynamic
set [no]cardinality_check
set cpufactor [value]
set date_format [value]
set decimal [value]
set [no]flatten
set [no]hash
set [no]io_trace
set joinop notimeout | timeout | timeout 'nnn'
set joinop timeoutabort 'nnn'
set joinop [no]greedy
set nojournaling | journaling [on table_name]
set lockmode session|on table_name where
              [level = page | table | session | system | row | mvcc]
              [, readlock = nolock | shared | exclusive
                               | session | system]
              [, maxlocks = n | session | system]
              [, timeout = n | session | system | nowait]
set [no]lock_trace
set [no]logdbevents
set [no]logging
set [no]log_trace
set nomaxconnect | maxconnect value
set nomaxcost | maxcost value
set nomaxcpu | maxcpu value
set nomaxidle | maxidle value
set nomaxio | maxio value
set nomaxpage | maxpage value
set nomaxquery | maxquery value
set nomaxrow | maxrow value
set money_format [value]
set money_prec [value]
set [no]ojflatten
set [no]optimizeonly
set [no]parallel [degree of parallelism]
set [no]printdbevents
set [no]printqry
set [no]printrules
set [no]qep
set random_seed [value]
set result_structure
                heap | cheap | heapsort | cheapsort | hash | chash
               | isam | cisam | btree | cbtree
set role none | rolename [with password = 'pwd'];
set [no]rules
set session
                [with
                      on_error = rollback statement | transaction
                      on_user_error = rollback transaction | norollback
set session authorization username | user | current_user
                   session_user | system_user | initial_user
set [no]statistics tablename
set notrace output | trace output filename
set [no]trace point [value]
set update_rowcount changed | qualified