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 11 12 13 .. 241 >> Next


GRANT Statement (SQL)..............................8-152

GRANT Statement (MONITOR)..........................8-163

GRANT LOGON........................................8-166

GROUP BY Clause....................................8-169

HAVING Clause......................................8-170

HELP...............................................8-171

HELP COLUMN........................................8-175

HELP CONSTRAINT....................................8-179

HELP DATABASE HELP USER..........................................8-182

xvi

Teradata RDBMS for UNIX SQL Reference
Table of Contents

HELP INDEX............................................8-183

HELP SESSION..........................................8-184

HELP STATISTICS.......................................8-185

HELP TABLE

HELP VIEW

HELP MACRO..........................................8-186

HELP (OnLine).........................................8-189

INSERT................................................8-192

LOCKING Modifier......................................8-199

MODIFY DATABASE.......................................8-207

MODIFY USER...........................................8-213

ORDER BY Clause.......................................8-221

RENAME................................................8-222

REPLACE MACRO.........................................8-223

REPLACE VIEW..........................................8-225

REVOKE................................................8-232

REVOKE Statement (SQL)................................8-233

REVOKE Statement (MONITOR) ...........................8-236

REVOKE LOGON..........................................8-240

ROLLBACK..............................................8-243

SELECT................................................8-245

SET SESSION COLLATION.................................8-246

SHOW MACRO

SHOW TABLE

SHOW VIEW...........................................8-249

UPDATE................................................8-254

USING Modifier........................................8-260

WHERE Clause .........................................8-263

WITH Clause...........................................8-264

Chapter 9

Advanced SQL

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

Transaction Semantics: Operating in ANSI or Teradata Mode...........9-2

ANSI Mode............................................................9-5

Teradata Mode........................................................9-6

SQL Flagger..........................................................9-7

Correlated Subqueries ...............................................9-9

Correlated Subqueries and SELECT....................................9-12

Correlated Subqueries and UPDATE....................................9-13

Correlated Subqueries and DELETE....................................9-14

Teradata RDBMS for UNIX SQL Reference xvii
Table of Contents

Correlated Subqueries and ABORT/ROLLBACK..................9-16

SELECT COUNT(*)...........................................9-17

Referential Integrity.....................................9-18

Updatable Cursors.........................................9-25

EXPLAIN Modifier: Examples of Complex Queries.............9-26

Appendix A

Teradata SQL Keywords

Teradata SQL Keywords...............................................A-1

Appendix B

Teradata SQL Versus ANSI SQL

Teradata SQL Versus ANSI SQL: Introduction.......................B-1

Teradata SQL Versus ANSI SQL: Summarized.........................B-2

Appendix C

Comparing Teradata SQL and DB2

Teradata SQL and DB2 Compatibilities................................C-1

DB2 and Teradata SQL Differences....................................C-3

DB2 Version 2 Release 3.0 Changes...................................C-8

DB2 Version 2 Release 2.0 Changes..................................C-11

DB2 Version 3.0 Changes............................................C-12

DB2 Version 4.0 Changes............................................C-13

DB2 Extensions Not Supported in Teradata SQL.......................C-16

Teradata SQL Extensions Beyond DB2.................................C-20

Reserved Words Comparison..........................................C-23

Limitations: DB2 Vs. Teradata SQL .................................C-27

Appendix D

Sample Personnel Database

Personnel Database .............................................. D-1

Appendix E

ASCII Hexadecimal Translation Tables

About This Appendix...........................................E-1

xviii

Teradata RDBMS for UNIX SQL Reference
Table of Contents

Appendix F

Data Conversion

Data Conversion......................................................F-1

Teradata RDBMS Internal Format ..................................... F-2

AT&T 3B-Series Internal Format.......................................F-3
Previous << 1 .. 2 3 4 5 6 < 7 > 8 9 10 11 12 13 .. 241 >> Next