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 .. 241 >> Next


• Chapter 5, “Data Definition,”describes data types and their attributes and format phrases, and how to convert from one data type to another.

• Chapter 6, “SQL Expressions,”describes the SQL arithmetic, character string, logical and conditional expressions, as well as built-in values such as DATE and TIME.

• Chapter 7, “Queries: The SELECT Statement,”describes the SELECT statement and associated clauses (GROUP BY, FROM, WITH, WHERE, ORDER BY, etc.) as well as the query expressions (set operators) UNION, INTERSECT, and EXCEPT (MINUS).

Teradata RDBMS for UNIX SQL Reference

i
About This Book

Chapter 8, “Teradata SQL Syntax Guide,”provides, in alphabetical order, details of the main SQL statements. Each description contains a brief explanation of the command function, syntax, usage notes, and one or more examples of how the command is used.

Chapter 9, “Advanced SQL,”describes a few more advanced Teradata SQL features such as transaction semantics, the SQL flagger, correlated subqueries, referential integrity, EXPLAIN examples, and updatable cursors.

Appendix A, “Teradata SQL Keywords,”lists the Teradata SQL keywords reserved for use in SQL statements.

Appendix B, “Teradata SQL Versus ANSI SQL,”lists the Teradata RDBMS SQL syntax alphabetically and notes which are Entry Level, Intermediate Level, or Full ANSI, and which are Teradata extensions to ANSI. Also listed is a comparative chart of keywords and future keywords.

Appendix C, “Comparing Teradata SQL and DB2,”describes similarities and differences between Teradata SQL and DB2. It includes a description of new features in DB2 Version 2 Release 2.0 and 3.0, Version 3, and Version 4. DB2 extensions not supported by Teradata SQL, and Teradata SQL extensions not supported by DB2, are outlined, as well as a comparison of reserved words.

Appendix D, “Sample Personnel Database,”includes the SQL syntax used to create the sample Personnel database tables, along with some sample data listings in each table.

Appendix E, “ASCII Hexadecimal Translation Tables,”lists hexadecimal code used to translate standard English language characters to and from EBCDIC to ASCII

Appendix F, “Data Conversion,”lists the data types and formats of the Teradata RDBMS and various client systems including Bull HN Worldwide Information Systems, IBM, DEC VAX/VMS, and PC.

Appendix G, “International and Japanese Character Support,”covers determining site attributes, user control of character sets and collation, Kanji feature sites and compatibility, European feature sites, and user-defined character sets.

Appendix H, “Japanese Character Sets,”describes the internal and external Kanji feature character ranges supported by the Teradata RDBMS for Japan with any combination of IBM, UNIX, and DOS/V client systems.

Appendix I, “Non-valid Japanese Character Code,”lists non-valid ranges for object names for KanjiEBCDIC, KanjiEUC, and KanjiShift-JIS.

Teradata RDBMS for UNIX SQL Reference
About This Book

Prerequisites

• Appendix J, “VARGRAPHIC Conversion,”lists the conversion of a single byte character to its double byte equivalent during the VARGRAPHIC function usage.

If you are not familiar with the Teradata RDBMS, you will find it useful to read the Introduction to the Teradata RDBMS for UNIX, before reading this document.

The Teradata RDBMS for UNIX Database Design and Administration is a useful parallel text to this one.

Teradata RDBMS for UNIX SQL Reference
Changes to This Book

Changes to This Book

Changes made to the SQL Reference include:

Introduction

• DR Maintenance.

• Revision to some syntax diagrams to reflect a new presentation style.

• Large scale reformatting of the book.

iv

Teradata RDBMS for UNIX SQL Reference
List of Acronyms

List of Acronyms

The following acronyms, listed in alphabetical order, are applicable to this release:

Acronym Explanation
AP Application Processor
API Application Programming Interface
AMP Access Module Processor Access Module Process in V2R2.0 and future releases.
APPC Advanced Program to Program Communication
ASF Archive Storage Facility
AWS Administration WorkStation
BTEQ Basic TEradata Query facility
BYNET Banyan Network - High speed interconnect
CLI Call Level Interface
CNS Console Subsystem
cs0, cs1, cs2, cs3 Four code sets (codeset 0, 1, 2, and 3) used in EUC encoding for Japanese character support.
DBA Database Administrator
DBC Database Computer (Teradata)
DBMS Database Management System
DBW Database Window
DSU Disk Storage Unit
FK Foreign Key
LAN Local Area Network
LT/ST Large Table/Small Table (join)
LUN Logical Unit (disk array logical unit)
MBC Multibyte Character
MBCS Multibyte Character Set
MPP Massively Parallel Processing
NIST National Institute of Standards and Technology
NN No Nulls
NUPI Non-Unique Primary Index

Teradata RDBMS for UNIX SQL Reference

v
List of Acronyms

Acronym Explanation
NUSI Non-Unique Secondary Index
Previous << 1 < 2 > 3 4 5 6 7 8 .. 241 >> Next