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


Teradata RDBMS for UNIX SQL Reference

Index-3
Index

DATE conversion (SQL) 5-97 Date expressions (SQL) 6-ll DATE formats (SQL) 5-6l DATE numeric data type (SQL) 5-l3 DATE value arithmetic (SQL) 5-l7 DB2

compatibility with Teradata SQL C-l DBC.CharTranslations

inserting Swedish character set into G-l8 populating DBC.Translation table G-6 DBC.CharTranslations View inserting codes G-l6 DBC.Hosts table

access via DBC.HostsInfo view G-2l DBC.Hoststable

default character sets G-20 DBC.Translation table

character translations G-6 DefaultCharSet column

in DBC.HostsInfo view G-2l DELETE DATABASE statement,

SQL 8-l25 DELETE statement (SQL) 8-ll7 DELETE USER statement (SQL) 8-l25 Delimiters (SQL) 4-22 Diacritical

character translation tables E-l Diacritical mark G-3 DISTINCT option (SQL) 6-l8, 7-4l Division operator (SQL) 6-3 Double exponentiation operator (SQL) 6-3 DOUBLE PRECISION numeric data type (SQL) 5-23 DROP DATABASE statement (SQL) 8-l27 DROP INDEX statement (SQL) 8-l29

DROP MACRO statement, SQL 8-l3l DROP STATISTICS statement (SQL) 8-l33 DROP TABLE statement (SQL) 8-l3l DROP USER statement (SQL) 8-l27 DROP VIEW statemen (SQL) 8-l3l

E

E2I

external to internal codes G-l6 E2IUp

external to internal code G-l6 EBCDIC translation code G-2l tables E-l EBCDIC Japanese extended English character set (SQL) H-l0 EBCDIC Japanese Extended English character set, defined H-5 EBCDIC Japanese extended Katakana character set (SQL) H-9 EBCDIC Japanese Extended Katakana character set, defined H-5 EBCDIC Kanji character set (SQL) H-ll EBCDIC Kanji character set, defined H-5 EBCDIC KATAKANA character set (SQL) H-8 EBCDIC Katakana character set, definfed H-5 ECHO statement (SQL) 8-l36 END LOGGING statement (SQL) 8-29 END TRANSACTION statement (SQL) 8-38 EQ comparison operator (SQL) 6-53 EUC character set (SQL) H-l3 EXCEPT operator (SQL) 7-55 EXECUTE statement (SQL) 8-l37 EXISTS predicate (SQL) 6-70

Index-4

Teradata RDBMS for UNIX SQL Reference
Index

EXP function (SQL) 6-7 EXPLAIN modifier (SQL) 8-140 Exponentiation operator (SQL) 6-3 Extended UNIX Code (EUC), defined H-13 Extended UNIX Code character set (SQL) H-13 EXTRACT function (SQL) 6-14

F

FLOAT numeric data type (SQL) 5-23 FORMAT phrase (SQL) 5-49 FROM clause (SQL) 7-16

G

GE operator (SQL) 6-53 GIVE statement (SQL) 8-148 GRANT LOGON statement )SQL) 8-166 GRANT MONITOR statement (SQL) 8-163 GRANT statement (SQL) 8-151-8-152 Graphic constants (SQL) 4-32 GRAPHIC conversion (SQL) 5-9 Graphic conversion (SQL) 5-95 Graphic formats (SQL) 5-53 GROUP BY clause (SQL) 7-30, 8-169 GT comparison operator (SQL) 6-53

H

Hash-related expressions (SQL) 5-111 HAVING clause (SQL) 7-32, 8-170 HELP (OnLine) statement (SQL) 8-189 HELP statement (SQL) 8-171

Hexadecimal

character translation tables E-1 Hexadecimal constants (SQL) 4-28 Host

connection identify with

LogicalHostId G-21

name

in HostName column G-21 HostName column

in DBC.HostsInfo view G-21

I

I2E

internal to external codes G-16 I2EUp

internal to external codes G-16 IBM Japanese Extended English, and non-valid object names I-1 IBM Japanese Extended Katakana, and non-valid object names I-1 IBM mainframe data format F-6 IN operator (SQL) 6-65 INDEX function (SQL) 6-37 Indicator variables (SQL) 6-102 Inner join (SQL) 3-2 INSERT statement (SQL) 8-192 InstallFlag

in DBC.CharTranslations view G-16 INTEGER numeric data type (SQL) 5-22 International

character set support G-3 INTERSECT operator (SQL) 7-54 IS NOT NULL operator (SQL) 6-68 IS NULL operator (SQL) 6-68

Teradata RDBMS for UNIX SQL Reference

Index-5
Index

J

Japanese character code notation, how to read 1-7 Japanese character graphic data types (SQL) 5-43 Japanese character names (SQL) 4-5 Japanese character sets

EBCDIC Japanese extended English character set H-10 EBCDIC Japanese extended Katakana character set H-9 EBCDIC Kanji character set H-11 EBCDIC KATAKANA H-8 Extended UNIX Code (EUC) H-13 IBM EBCDIC H-6 JIS-x0208 H-3

non-Kanji EBCDIC character set for Japanese locale H-7 Shift-JIS (DOS Kanji) encoding H-16 Japanese Katakana EBCDIC, and non-valid object names I-1 JIS-x0201 standard, defined H-2 JIS-x0208 standard (SQL) H-3

described G-45 KATAKANAEBCIDC, and non-valid object names I-1 Keywords (SQL) 4-21, A-1

L

LE operator (SQL) 6-53 Lexical separators (SQL) 4-35 Lexicon, Teradata SQL 4-1 LIKE operator (SQL) 6-74 LIKE operator and Japanese character sets (SQL) 6-81 LN function (SQL) 6-7 LOCKING modifier (SQL) 8-199 LOG function (SQL) 6-7 Logical expressions (SQL) 6-52 LogicalHostId column

DBC.HostsInfo view G-21 LONGVARCHAR data type (SQL) 5-27 LT operator (SQL) 6-53

K

Kanji character sets supported by Teradata DBS G-41 KanjiEBCDIC data validity criteria G-47 KANJIEBCDIC5026_0I character set, described G-43 KANJIEBCDIC5026_0I, and non-valid object names I-1 KANJIEBCDIC5035_0I character set, described G-44 KanjiEUC, non-valid name characters for I-4
Previous << 1 .. 232 233 234 235 236 237 < 238 > 239 240 .. 241 >> Next