SET

Changes the state of a DMQUERY utility option. 

── SET ── <option setting> ── [, <option setting>...] ─────────────────┤

<option setting>

──┬─ <Boolean option setting> ──┬──────────────────────────────────────┤
  ├─ <numeric option setting> ──┤
  ├─ <string option setting> ───┤
  ├─ <symbolic option setting> ─┤
  └─ <symbolic value> ──────────┘

<Boolean option setting>

── <Boolean option> [ = ] ─┬─ TRUE ──┬─────────────────────────────────┤
                           ├─ FALSE ─┤
                           ├─ ON ────┤
                           └─ OFF ───┘

<Boolean option>

Option

Description

DUMPONFAULT

Causes a dump to be taken if the DMQUERY utility faults. The default is ON.

ECHO

Causes the statements in a DO file to be written to the file or device indicated by the DEST option. The default is ON.

QGRAPH

Writes a query graphic (QGRAPH) file for each subsequent SQL statement.

TRUNCATE

Manages spacing of the output. The default is ON.

<numeric option setting>

── <numeric option> [ = ] <number> ────────────────────────────────────┤

<numeric option>

Option

Description

LIMIT

Designates the maximum rows to be retrieved for a SELECT statement. The default is zero (unlimited).

PAGELENGTH

The default is 24 lines.

PAGEWIDTH

The default is 80 characters.

SPACING

Designates for the FORMAT TABULAR option the minimum spacing between columns. The default is 20.

<string option setting> 

── <string option> [ = ] <string> ─────────────────────────────────────┤

<string option>

──┬─ TITLE ───┬────────────────────────────────────────────────────────┤
  └─ FOOTING ─┘

<symbolic option setting>

── <symbolic option> [ = ] <symbolic value> ───────────────────────────┤

<symbolic option>

Causes the output to be written to a printer, remote file, or a disk file named DEST. 

── DEST ──  = ─┬─ PRINTER ─┬───────────────────────────────────────────┤
               ├─ REMOTE ──┤
               └─ FILE ────┘

<symbolic value>

Causes the result of a SELECT statement to be written as a table or written one column at a time. The default is TABULAR. 

── FORMAT ──  = ─┬─ TABULAR ────┬──────────────────────────────────────┤
                 └─ STRUCTURED ─┘
Prev  Up  Next
SAVEPOINT  Home  SHOW