SQL Commands

SET

SET [options | ?]

The SET command allows the setting of options to help control the way in which SQL statements are processed. It is also useful with the OdxSQL utility to aid in application prototyping, benchmarking, and testing.

A SQL SET statement can be passed in OdxSql or in a JDBC or ODBC CLI application in the same manner as any other SQL statement that does not return a result data set.

SET options are divided into two categories: Options available to all applications and options available only in the OdxSQL utility.

Syntax

SET [options | ?]

SET

Required

options

Optional. A comma separated list of options to be applied to the current application.

?

ODXSQL Only. Optional. Enter a ? (question mark) to display a list of available set options.
Or, enter SET with no arguments to display a list of current settings.

top

Options

SET Options Available to All Applications (Including ODXSQL)

AUTOSPEUDOCOLUMNS
CHAR
DEBUG
OPTIMIZATION
PREPROCESSOR
PSEUDOCOLUMNS
REDEF_ROWIDS
REQUIRED_OPTIMIZATION
TIMEOUT

SET Options available only in ODXSQL

AUTODISPLAY
AUTOEXPLAIN
AUTOFETCH
CURSOR
CURSORDISPLAY
DEFAULTS
EDITOR
ENDIAN
ERRORDISPLAY
ERRORS
EXPLAIN
HEX
HISTORY
INSTANCE
INTERRUPTS
NULL_INDICATORS
ODXSQL_DEBUG
PAGELENGTH
PAGEWIDTH
PROMPT
TIMER
QUALIFY_COUNTS

OdxSQL Example

Use SET to display cursor and instance numbers:

>SET CURSORDISPLAY ON

>OPEN CURSOR
Opened cursor 2

>SET DEFAULTS
All settings are returned to their defaults

>

top