SET--Set Session Options
Valid in: EQUEL
Sets a session option.
This statement has the following format:
[##] set aggregate [no]project
[##] set joinop [no]timeout
[##] set journaling|nojournaling [on tablename]
[##] set lockmode session|on tablename where
[level = page|table|session|system]
[, readlock = nolock|shared|exclusive|session|system]
[, maxlocks = n|session|system]
[, timeout = n|session|system|nowait]
[##] set [no]logging
[##] set nomaxio | maxio value
[##] set nomaxquery | maxquery value
[##] set nomaxrow | maxrow value
[##] set [no]printqry
[##] set [no]qep
[##] set ret_into heap|cheap|heapsort|cheapsort|hash|
chash|isam|cisam|btree|cbtree
[##] set [no]optimizeonly
[##] set session with on_error = rollback
statement | transaction
[##] set update_rowcount changed | qualified
The set statement specifies a runtime option for a single session (interactive or embedded). The option remains in effect until the end of the session, or until changed by another set statement.
Last modified date: 01/30/2023