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 .. 233 234 235 236 237 238 < 239 > 240 .. 241 >> Next


KanjiShift-JIS, non-valid name characters for I-5 KATAKANAEBCDIC character set,

M

MAXIMUM aggregate operator (SQL) 6-17 MINDEX function (SQL) 6-42 MINIMUM aggregate operator (SQL) 6-17 MINUS operator (SQL) 7-55 MOD operator (SQL) 6-3 MODIFY DATABASE statement (SQL) 8-207 MODIFY USER statement (SQL) 8-213 Multinational

translation tables E-1 Multiplication operator (SQL) 6-3

Index-6

Teradata RDBMS for UNIX SQL Reference
Index

N

NE operator (SQL) 6-53 Non-valid name characters for KanjiEUC I-4 Non-valid name characters for KanjiShift-JIS I-5 Non-valid object names under KANJIEBCDIC5035_0I I-1 Non-valid object names under KATAKANAEBCID I-1 Non-valid object names under the KANJIEBCDIC5026_0I I-1 NOT = operator (SQL) 6-53 NOT IN operator (SQL) 6-65 Null (SQL)

added rows 2-14 collation sequence 2-21 operations with 2-21 value returned 2-22 NULL built-in value (SQL) 6-101 NULLIF abbreviation expression (SQL) 6-95 NULLIFZERO function (SQL) 6-7, 6-9 Numeric constants (SQL) 4-25 Numeric conversion (SQL) 5-87 NUMERIC data type (SQL) 5-18 Numeric data types (SQL) 5-11 Numeric formats (SQL) 5-55 Numeric to character conversion (SQL) 5-89 Numeric to numeric conversion (SQL) 5-88

O

ON clause (SQL) 3-3

Operators (SQL) 4-33

ORDER BY clause (SQL) 7-34, 8-221

Outer join (SQL) 3-3

P

Partial names for table or column references in SQL 2-3 Personnel database D-1

Q

Query expressions (SQL) 7-43

R

REAL numeric data type (SQL) 5-23 Referential integrity (SQL) 9-18 RENAME statement (SQL) 8-222 REPLACE MACRO statement (SQL) 8-225 REPLACE VIEW statement (SQL) 8-225 Request terminator (SQL) 4-37 Requests (SQL)

multi-statement 2-10 single-statement 2-10 Reserved words

DB2 and Teradata SQL C-23 Revision record xxvii REVOKE LOGON statement (SQL) 8-240 REVOKE statement (SQL) 8-232 ROLLBACK statement (SQL) 8-243

S

Searched CASE expression (SQL) 6-91 SELECT statement ALL option 7-41 DISTINCT option 7-41 EXCEPT operator 7-55 FROM clause 7-16

Teradata RDBMS for UNIX SQL Reference

Index-7
Index

GROUP BY clause 7-30 HAVING clause 7-32 INTERSECT operator 7-54 MINUS operator 7-55 ORDER BY clause 7-34 query expressions 7-43 set operators 7-43 simple SELECT 7-l0 subqueries in search conditions 7-l4 UNION operator 7-50 WITH clause 7-24 SELECT statement (SQL) 7-2, 8-245 Self-join (SQL) 3-l6 Sequence collation

international character set G-3 Session control (SQL) 2-29 SET operators (SQL) 7-43 SET SESSION COLLATION statement (SQL) 8-246 Shift-JIS (DOS Kanji) character set (SQL) H-l6 SHOW MACRO statement,

SQL 8-249 SHOW TABLE statement (SQL) 8-249 SHOW VIEW statement (SQL) 8-249 Signed zone decimal conversion (SQL) 5-99 Simple SELECT (SQL) 7-l0 SMALLINT numeric data type (SQL) 5-2l Spool table (SQL) 3-9 SQL

character set 4-l data definition statements 2-6 lexicon 4-l structure 4-l SQL comparisons

Teradata SQL and ANSI SQL B-2 SQL expressions 6-48

aggregate operators 6-l7 AVERAGE 6-l7 COUNT 6-l7, 6-l9

DISTINCT option 6-l8 MAXIMUM 6-l7 MINIMUM 6-l7 SUM 6-l7 arithmetic functions ABS function 6-7 EXP function 6-7 LN function 6-7 LOG function 6-7 NULLIFZERO function 6-7, 6-9 SQRT function 6-7 ZEROIFNULL function 6-7, 6-l0

arithmetic operators 6-3 addition operator 6-3 division operator 6-3 double exponentiation operator 6-3 exponentiation 6-3 MOD operator 6-3 multiplication operator 6-3 subtraction operator 6-3 unary operator 6-3 built-in values 6-97 DATE 6-98 NULL 6-l0l TIME 6-99 USER 6-l00 CASE 6-88

abbreviation expressions 6-94 COALESCE abbreviation expression 6-96 NULLIF abbreviation 6-95 searched CASE 6-9l valued CASE 6-89 CASE blind comparisons 6-56 character strings 6-23

concatenation operator 6-24 string functions 6-24, 6-30 SUBSTR function 6-3l SUBSTRING function 6-3l TRIM and concatenation 6-28 conditional expressions 6-85 data and time 6-ll date and time expressions

ADD_MONTHS function 6-l6 EXTRACT function 6-l4

Index-8

Teradata RDBMS for UNIX SQL Reference
Index

Indicator variables 6-102 Japanese character set comparison operators 6-62 logical expressions 6-52 = operator 6-53 BETWEEN comparison operator 6-53 EQ comparison operator 6-53 EXISTS predicate 6-70 GE operator 6-53 GT comparison operator 6-53 IN operator 6-65 IS NOT NULL operator 6-68 IS NULL operator 6-68 LE operator 6-53 LIKE operator 6-74 LIKE operator and Japanese character sets 6-81 LT operator 6-53 NE operator 6-53 NOT = operator 6-53 NOT IN operator 6-65 string functions INDEX 6-37 MINDEX 6-42 TRIM 6-43 UPPER 6-51 SQl expressions

arithmetic functions 6-7 SQL flagger 9-7

session control 2-29 SQL lexicon

character constants 4-27 constants 4-24 delimiters 4-22 graphic constants 4-32 hexadecimal constants 4-28 Japanese character names 4-2, 4-5 Japanese character object names 4-7 keywords 4-21 lexical separators 4-35 numeric constants 4-25 Object names and rules for nonASCII characters 4-11 operators 4-33

request terminator 4-37 statement separator 4-36 SQL requests
Previous << 1 .. 233 234 235 236 237 238 < 239 > 240 .. 241 >> Next