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 .. 4 5 6 7 8 9 < 10 > 11 12 13 14 15 16 .. 241 >> Next


(2 of 2)...............................................C-26

Table C-3 Limitations, Teradata SQL and DB2 ......................C-27

Table C-4 Numeric Limits: Teradata SQL Vs. DB2....................C-28

Table C-5 String Length Limits: Teradata SQL Vs. DB2.............C-28

Table C-6 Datetime Limits: Teradata SQL Vs. DB2...................C-29

Teradata RDBMS for UNIX SQL Reference

xxv
List of Tables

Appendix E

ASCII Hexadecimal Translation Tables

Table E-1 EBCDIC to ASCII Translation..............................E-2

Table E-2 ASCII to EBCDIC Translation............................. E-4

Appendix G

International and Japanese Character Support

Table G-1 Teradata Internal Form for International

Character Support.................................G-24

Table G- 1 Equivalence Classes and Ordering Within Class

(Teradata Standard Multinational Collation) ...... G-29

Table G-2 Teradata RDBMS Kanji Character Sets................ G-41

Table G-3 KanjiEBCDIC Character Data Validity Criteria.......G-47

Table G-4 KanjiEBCDIC Graphic Data Validity Criteria.........G-47

Appendix H

Japanese Character Sets

Table H-1 IBM Kanji Encoding.......................................H-12

Table H-2 Selected Characters for EBCDIC Kanji...................H-12

Table H-3 EUC Code Set Localization................................H-14

Table H-4 Selected Characters for EUC Kanji......................H-14

Table H-5 Shift-JIS Encoding.......................................H-16

Table H-6 Selected Characters for Shift-JIS Kanji................H-16

xxvi

Teradata RDBMS for UNIX SQL Reference
Revision Record

Revision Record

Date Description
September 1996 Initial printing. Supports Teradata DBS for UNIX V2R2.0.
April 1997 Supports Teradata RDBMS for UNIX V2R2.0.1
June 1997 Supports Teradata RDBMS for UNIX V2R2.0.2

Teradata RDBMS for UNIX SQL Reference

xxvii
xxviii Teradata RDBMS for UNIX SQL Reference
Notation

Chapter 1

Notation

Teradata RDBMS for UNIX SQL Reference
Notation

Teradata RDBMS for UNIX SQL Reference
About This Chapter

This chapter describes the following:

• Notation

• How to read syntax diagrams

• Japanese character (Kanji) conventions

Notation About This Chapter

Teradata RDBMS for UNIX SQL Reference

1-1
Notation

Notation

Notation1

Throughout this manual, three conventions are used to describe the SQL syntax and code:

• Syntax diagrams - used to describe SQL syntax form, including options. See “How to Read Syntax diagrams” in the next section.

• Square braces in the text, used to represent options. For example:

• DECIMAL [(n[,m])] means the decimal data type can be defined optionally:

• without specifying the precision value n or scale value m

• specifying precision value (n) only

• specifying scale value (m) only

• specifying both values (n,m)

The parentheses are required when specifying n and/or m.

• GRAPHIC [(n)] means that use of (n) double-byte zeros is optional. The parentheses are required when using n.

• Japanese character code shorthand notation, used to represent unprintable Japanese characters. See later in this chapter.

1-2

Teradata RDBMS for UNIX SQL Reference
Notation

How to Read the Syntax Diagrams

How to Read the Syntax Diagrams

This section describes the rules that apply to the syntax diagrams used in this book.

The following table defines the notation used in this section:

Notation Conventions

Item Definition / Comments
Letter An uppercase or lowercase alphabetic character ranging from A through Z.
Number A digit ranging from 0 through 9. Do not use commas when entering a number with more than three digits.
Word Variables and reserved words.

IF a word is shown in . . . THEN it represents . . .
UPPERCASE LETTERS a keyword. Syntax diagrams show all keywords in uppercase, unless operating system restrictions require them to be in lowercase. If a keyword is shown in uppercase, you may enter it in uppercase or mixed case.
lowercase letters a keyword that you must enter in lowercase, such as a UNIX command.
lowercase italic letters a variable such as a column or table name. You must substitute a proper value.
lowercase bold letters a variable that is defined immediately following the diagram that contains it.
UNDERLINED LETTERS the default value. This applies both to uppercase and to lowercase words.

Spaces

Use one space between items, such as keywords or variables.

Punctuation

Enter all punctuation exactly as it appears in the diagram.

Teradata RDBMS for UNIX SQL Reference

1-3
Notation

How to Read the Syntax Diagrams

Paths

The main path along the syntax diagram begins at the left, and proceeds, left to right, to the vertical bar, which marks the end of the diagram. Paths that do not have an arrow or a vertical bar only show portions of the syntax.

The only part of a path that reads from right to left is a loop.
Previous << 1 .. 4 5 6 7 8 9 < 10 > 11 12 13 14 15 16 .. 241 >> Next