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 .. 2 3 < 4 > 5 6 7 8 9 10 .. 241 >> Next


To order Teradata publications, use the Information Products Order Order FOrm Form (form number IPP-WD02001).

Send orders to the following address:

Ordering Address

U.S. Orders

NCR IPP-DAYTON 1529 Brown Street

Dayton, OH 45479 USA

FAX: 937-445-6245 |

PHONE: 1-800-543-2010 or VP 622-3727

E-MAIL: Information+Products.Publishing@DaytonOH.NCR.COM MS-MAIL: Publishing, Information+Products

Non- U.S. Orders

NCR IPP-BRUSSELS-OTC Rue de la Fusee 50 B-1130 Brussels Belgium

FAX: 32-2-727-95-50

PHONE: 32-2-727-95-49 or 32-2-727-95-71 E-MAIL: Order.Management@OTC.NCR.COM

x

Teradata RDBMS for UNIX SQL Reference
Table of Contents

Contents

About This Book....................................................i

Changes to This Book..............................................iv

List of Acronyms...................................................v

Teradata RDBMS for UNIX Library..................................vii

Client Reference Library........................................viii

How to Order Teradata Publications.................................x

Chapter 1

Notation

About This Chapter...................................................1-1

Notation............................................................1-2

How to Read the Syntax Diagrams......................................1-3

Japanese Character Code Notation Used in this Manual.................1-7

Chapter 2

Data Handling Fundamentals

About This Chapter..................................................2-1

Standard Form for Data in the Teradata RDBMS........................2-2

Using Partial Names ................................................2-3

Basic Data Manipulation.............................................2-4

Data Definition Statements..........................................2-6

SQL Requests.......................................................2-10

Structure of a SQL Statement.......................................2-12

Data Manipulation Language (DML)...................................2-13

Default Database...................................................2-16

Macros............................................................2-17

Subqueries........................................................2-19

Supported Characters...............................................2-20

Operations on Null.................................................2-21

Statement Response.................................................2-24

Teradata RDBMS for UNIX SQL Reference xi
Table of Contents

Success Response...............................................2-25

Warning Response...............................................2-26

Failure Response...............................................2-27

Error Response (ANSI Mode Only) ...............................2-28

Session Parameters.............................................2-29

Chapter 3

Joins: Working with Multiple Tables

About This Chapter........................................................3-1

Inner Join................................................................3-2

Outer Join................................................................3-3

Cross Join...............................................................3-15

Self-Join................................................................3-16

Chapter 4

Teradata SQL Lexicon

About This Chapter................................................4-1

Words and Names (Non-Japanese Character) .........................4-2

Japanese Character Names..........................................4-5

Japanese Character Object Names...................................4-7

Rules for Non-ASCII Character Object Names.......................4-11

Object Name Translation and Storage..............................4-14

Object Name Comparisons..........................................4-15

Finding the Internal Hexadecimal Representation of a Name.......4-18

Specifying Names in a Logon String ..............................4-20

Keywords.........................................................4-21

Delimiters.......................................................4-22

Constants .......................................................4-24

Numeric Constants................................................4-25

Character Constants..............................................4-27

Hexadecimal Constants............................................4-28

Graphic Constants................................................4-32

Operators .......................................................4-33

Lexical Separators...............................................4-35

Statement Separator .............................................4-36

Request Terminator...............................................4-37

xii

Teradata RDBMS for UNIX SQL Reference
Table of Contents

Chapter 5

Data Definition
Previous << 1 .. 2 3 < 4 > 5 6 7 8 9 10 .. 241 >> Next