Books
in black and white
Main menu
Share a book About us Home
Books
Biology Business Chemistry Computers Culture Economics Fiction Games Guide History Management Mathematical Medicine Mental Fitnes Physics Psychology Scince Sport Technics
Ads

Teradata RDBMS forUNIX SQL Reference - NCR

NCR Teradata RDBMS forUNIX SQL Reference - NCR, 1997. - 913 p.
Download (direct link): teradataforunix1997.pdf
Previous << 1 .. 5 6 7 8 9 10 < 11 > 12 13 14 15 16 17 .. 241 >> Next


Paths that are too long for one line use continuation links. Continuation links are small circles with letters indicating the beginning and end of a link:

&

When you see a circled letter in a syntax diagram, go to the corresponding circled letter and continue.

Required Items

Required items appear on the main path: SHOW---------------------------------------

If you can choose from more than one item, the choices appear vertically, in a stack. The first item appears on the main path:

SHOW------------,— CONTROLS—,-------------------------------------

-,— CONTROLS—p

Lversions___I

Optional Items

Optional items appear below the main path: SHOW —

Ã

CONTROLS

If choosing one of the items is optional, all the choices appear below the main path:

SHOW

CONTROLS — . VERSIONS —

You can choose one of the options, or you can disregard all of the options.

FE0CA002

FE0CA003

FE0CA005

FE0CA004

FE0CA006

1-4

Teradata RDBMS for UNIX SQL Reference
Notation

How to Read the Syntax Diagrams

Abbreviations

Loops

If a keyword or a reserved word has a valid abbreviation, the unabbreviated form always appears on the main path. The shortest valid abbreviation appears beneath.

SHOW------,-CONTROLS —,

L CONTROL—I

In the above syntax, the following formats are valid:

• SHOW CONTROLS

• SHOW CONTROL

FE0CA042

A loop is an entry or a group of entries that you can repeat one or more times. Syntax diagrams show loops as a return path above the main path, over the item or items that you can repeat.

³— .------

FE0CA015

The following rules apply to loops:

IF... THEN...
there is a maximum number of entries allowed the number appears in a circle on the return path. In the example, you may enter cname a maximum of 4 times.
a separator character is required between entries the character appears on the return path. If the diagram does not show a separator character, use one blank space. In the example, the separator character is a comma.
a delimiter character is required around entries the beginning and end characters appear outside the return path. Generally, a space is not needed between delimiter characters and entries. In the example, the delimiter characters are the left and right parentheses.

Teradata RDBMS for UNIX SQL Reference

1-5
Notation

How to Read the Syntax Diagrams

Excerpts

Sometimes a piece of a syntax phrase is too large to fit into the diagram. Such a phrase is indicated by a break in the path, marked by | terminators on either side of the break. A name for the excerpted piece appears between the break marks in boldface type.

The named phrase appears immediately after the complete diagram, as illustrated by the following example.

LOCKING-----------------------1 excerpt I------------------------(a)

-------------------1--------------------------------------H

I—HAVING — con —I

excerpt

JC01A014

1-6

Teradata RDBMS for UNIX SQL Reference
Notation

Japanese Character Code Notation Used in this Manual

Japanese Character Code Notation Used in this Manual

Japanese character code provides support for mixed multibyte/single byte characters in the following character sets:

• KanjiEBCDIC

• KanjiEUC

• KanjiShift-JIS.

Normally multibyte characters and some of the single byte characters (e.g., Katakana) are not printable. To represent the unprintable characters in this manual, a notation shorthand has been adopted, as shown in Table 1-1.

Table 1-1

Kanji Code Shorthand Notation

Code Set Symbol Meaning
KanjiEBCDIC < Shift Out [SO] (0x0E) - used to indicate transition from single to multibyte character in KanjiEBCDIC.
KanjiEBCDIC > Shift In [SI] (0x0F) - used to indicate transition from multibyte to single byte KanjiEBCDIC.
Any T Any multibyte character or graphic. Its encoding depends on the current character set.May be used in conjunction with KanjiEUC code set 1 data.
Any I Single byte Hankaku Katakana character - especially as stored in the canonical form of JIS-x0201.
Any a..z A..Z 0..9 Any single byte Latin letter or digit. Internal storage requires one byte.
KanjiEUC ss2B Multibyte character representing code set 2 data (Hankaku Katakana) in KanjiEUC. In this manual, “ss2” represents the code set 2 identifier (0x8E); letter “B” represents a single byte of storage. Internal storage requires two bytes.
KanjiEUC E 3 s s Multibyte character representing code set 3 data in KanjiEUC. In this manual, “ss3” represents the code set 3 identifier (0x8F); E represents a multibyte character. Internal storage requires three bytes.
Any A Represents either a single or multibyte blank, depending on context.

Teradata RDBMS for UNIX SQL Reference

1-7
Notation

Japanese Character Code Notation Used in this Manual

Code Set Symbol Meaning
KanjiEUC ss2 Represents the EUC code set 2 introducer (0x8E).
KanjiEUC ss3 Represents the EUC code set 3 introducer (0x8F).
Previous << 1 .. 5 6 7 8 9 10 < 11 > 12 13 14 15 16 17 .. 241 >> Next