Set commands affect only the connection on which they are issued. Other connections and the configuration file remain unchanged.
Commands |
Description |
|---|---|
set autocommit |
Turns autocommit on or off.
set autocommit on | off | 0 | 1 |
set rowcount |
Limits the number of rows returned in a result set. The default is to return all rows.
set rowcount value |
set textsize |
Limits the size of a text or image column that is returned through a select statement. The default is 32K.
set textsize value |
set sql_transform |
Enables or disables Transact SQL transformation. The default is off. When enabled, the ECDA Option for Oracle parser can parse a limited
subset of Transact SQL statements and recognize Transact SQL datatype
names.
set sql_transform on | off | 0 | 1 |
set traceon |
Turns on the specific trace flags in the program.
set traceon [traceflag] |
set traceoff |
Turns
off specific trace flags. If no trace flag is provided, all trace
flags are cleared.
set traceoff [traceflag] |