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


Figure H-10 Shift-JIS Encoding-Detailed View.......................H-18

........................................................H-18

Teradata RDBMS for UNIX SQL Reference xxi
List of Figures

xxii Teradata RDBMS for UNIX SQL Reference
List of Tables

List of Tables

Chapter 1 Notation

Table 1-1 Kanji Code Shorthand Notation..........................1-7

Chapter 2

Data Handling Fundamentals

Table 2-1 Returned Nulls..........................................2-23

Chapter 4

Teradata SQL Lexicon

Table 4-1 KanjiEBCDIC Object Name Examples.....................4-12

Table 4-2 KanjiEUC Object Name Examples........................4-13

Table 4-3 KanjiShift-JIS Object Name Examples..................4-13

Table 4-4 Delimiters in Teradata SQL...........................4-23

Table 4-5 Hexadecimal Values Internal ASCII....................4-29

Table 4-6 Forms for Hexadecimal Graphic Constants..............4-31

Table 4-7 Operator Precedence..................................4-34

Chapter 5

Data Definition

Table 5-1 Data Type Declaration....................................5-6

Table 5-2 Data Type Attributes.....................................5-7

Table 5-3 Data Conversion Results..................................5-9

Table 5-4 Effects of Rounding.....................................5-12

Table 5-5 Effect of Converting to Uppercase on Japanese

Character Data.........................................5-26

Table 5-6 Numeric Format Results..................................5-58

Teradata RDBMS for UNIX SQL Reference xxiii
List of Tables

Table 5-7 European Alternative Currency Symbols..........5-59

Table 5-8 Japanese Alternative Currency Symbols..........5-59

Table 5-9 DATE Format Characters.........................5-61

Table 5-10 DATE Format Results............................5-62

Table 5-11 Data Type Format Defaults......................5-64

Table 5-12 FORMAT Displays................................5-64

Table 5-13 Values for DEFAULT Phrase Keywords.............5-74

Table 5-14 System Values for WITH DEFAULT Phrase..........5-75

Table 5-15 Signed Zoned Decimal Character Set.............5-99

Table 5-16 KanjiEBCDIC - CHARACTERS(string_expr).........5-108

Table 5-17 KanjiEUC - CHARACTERS(string_expr)............5-109

Table 5-18 KanjiShift-JIS - CHARACTERS(string_expr)......5-109

Table 5-19 KanjiEBCDIC - MCHARACTERS(string_expr)........5-109

Table 5-20 Results from OCTET_LENGTH (string-expr).......5-110

Chapter 6

SQL Expressions

Table 6-1 Binary Arithmetic Result Data Types.................6-4

Table 6-2 Aggregate Operators................................6-17

Table 6-3 Default Attributes of Aggregate Results............6-19

Table 6-4 KanjiEBCDIC - SUBSTR(string_expr,

n1 [, n2]).........................................6-35

Table 6-5 KanjiEUC - SUBSTR(string_expr, start

[, len])...........................................6-35

Table 6-6 KanjiShift-JIS - SUBSTR(string_expr, start [, len]) ...6-35

Table 6-7 KanjiEBCDIC - MSUBSTR(string_expr, n1 [, n2])....6-36

Table 6-8 KanjiEBCDIC - INDEX(string_expr1,

string_expr2) .....................................6-41

Table 6-9 KanjiEUC - INDEX(string_expr1,

string_expr2) .....................................6-41

Table 6-10 KanjiShift-JIS - INDEX(string_expr1,

string_expr2) .....................................6-41

Table 6-11 KanjiEBCDIC - MINDEX(string_expr1,

string_expr2) .....................................6-42

Table 6-12 KanjiEBCDIC - VARGRAPHIC(string_expr)..............6-49

Table 6-13 Comparison Operators...............................6-53

Table 6-14 Implicit Conversions for Comparisons...............6-55

Table 6-15 KanjiEBCDIC - (expr LIKE pattern-string)...........6-83

Table 6-16 KanjiEUC - (expr LIKE pattern-string)..............6-83

Table 6-17 KanjiShift-JIS - (expr LIKE pattern-string)........6-83

Table 6-18 AND Truth Table (x AND y)..........................6-86

xxiv

Teradata RDBMS for UNIX SQL Reference
List of Tables

Table 6-19 OR Truth Table (x OR y)............................................6-86

Chapter 7

Queries: The SELECT Statement

Table 7-1 European Sort Order......................................7-37

Chapter 8

Teradata SQL Syntax Guide

Table 8-3 Restrictions on Granted Privileges........................8-159

Table 8-4 HELP COLUMN Information and Attributes....................8-177

Table 8-5 Table, View, or Macro Attributes..........................8-187

Appendix B

Teradata SQL Versus ANSI SQL

Table B-1 Teradata SQL Vs. ANSI SQL, Summarized...................B-2

Appendix C

Comparing Teradata SQL and DB2

Table C-1 GRANT Database Privileges: Differences in

DB2 and Teradata SQL...................................C-18

Table C-2 Teradata SQL Reserved Words (not in DB2)

(1 of 2)...............................................C-25

Teradata SQL Reserved Words (not in DB2)
Previous << 1 .. 3 4 5 6 7 8 < 9 > 10 11 12 13 14 15 .. 241 >> Next