Neoview Query Guide (R2.3, R2.4, R2.5)

ENTER RUN CODE

?123

CODE RECEIVED: 123.00

The user must press the Return key after typing the input.

[ ] Brackets Brackets enclose optional syntax items. For example:

DATETIME [start-field TO] end-field

A group of items enclosed in brackets is a list from which you can

choose one item or none. The items in the list can be arranged either

vertically, with aligned brackets on each side of the list, or

horizontally, enclosed in a pair of brackets and separated by vertical

lines. For example:

DROP SCHEMA schema [CASCADE]

[RESTRICT]

DROP SCHEMA schema [ CASCADE | RESTRICT ]

{ } Braces Braces enclose required syntax items. For example:

FROM { grantee[, grantee]...}

A group of items enclosed in braces is a list from which you are

required to choose one item. The items in the list can be arranged

either vertically, with aligned braces on each side of the list, or

horizontally, enclosed in a pair of braces and separated by vertical

lines. For example:

INTERVAL { start-field TO end-field }

{ single-field }

INTERVAL { start-field TO end-field | single-field }

| Vertical Line A vertical line separates alternatives in a horizontal list that is enclosed

in brackets or braces. For example:

{expression | NULL}

… Ellipsis An ellipsis immediately following a pair of brackets or braces indicates

that you can repeat the enclosed sequence of syntax items any number

of times. For example:

ATTRIBUTE[S] attribute [, attribute]...

{, sql-expression}...

An ellipsis immediately following a single syntax item indicates that

you can repeat that syntax item any number of times. For example:

expression-n…

Punctuation Parentheses, commas, semicolons, and other symbols not previously

described must be typed as shown. For example:

DAY (datetime-expression)