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


single-statement

multi-statement 2-10 SQL statement, WHERE clause 7-11 SQL statements abbreviations 8-1 ABORT 8-4 ALTER TABLE 8-7 BEGIN LOGGING 8-29 BEGIN TRANSACTION 8-38 CHECKPOINT 8-42 COLLECT STATISTICS 8-44 COMMENT 8-48 COMMIT 8-51 CREATE DATABASE 8-53 CREATE INDEX 8-59 CREATE MACRO 8-62 CREATE TABLE 8-69 CREATE USER 8-95 CREATE VIEW 8-104 data definition 2-6 data manipulation language 2-13 DATABASE 8-116 DELETE 8-117 DELETE DATABASE 8-125 DELETE USER 8-125 DROP DATABASE 8-127 DROP INDEX 8-129 DROP MACRO 8-131 DROP STATISTICS 8-133 DROP TABLE 8-131 DROP USER 8-127 DROP VIEW 8-131 ECHO 8-136 END LOGGING 8-29 END TRANSACTION 8-38 EXECUTE 8-137 EXPLAIN modifier 8-140 GIVE 8-148 GRANT 8-151-8-152 GRANT LOGON 8-166 GRANT MONITOR 8-163

Teradata RDBMS for UNIX SQL Reference

Index-9
Index

GROUP BY clause 8-l69 HAVING clause 8-l70 HELP 8-l7l HELP (OnLine) 8-l89 how names are resolved 2-3 INSERT 8-l92 LOCKING modifier 8-l99 MODIFY DATABASE 8-207 MODIFY USER 8-2l3 ORDER BY clause 8-22l partial names for table or column references 2-3 RENAME 8-222 REPLACE MACRO 8-225 REPLACE VIEW 8-225 REVOKE 8-232 REVOKE LOGON 8-240 ROLLBACK 8-243 SELECT 8-245

SET SESSION COLLATION 8-246 SHOW MACRO 8-249 SHOW TABLE 8-249 SHOW VIEW 8-249 UPDATE 8-254 USING modifier 8-260 WHERE clause 8-263 WITH clause 8-264 SQL statements, basic structure 2-4 SQRT function (SQL) 6-7 Statement separator (SQL) 4-36 String functions (SQL) 6-24, 6-30 VARGRAPHIC 6-48 Subqueries (SQL) 7-l4 Subquery 2-l9 SUBSTR function (SQL) 6-3l SUBSTRING function (SQL) 6-3l Subtraction operator (SQL) 6-3 SUM aggregate operator (SQL) 6-l7 Syntax, how to read l-3

T

Table

character translation E-l Table constraints (SQL) 5-47 Teradata DBS Kanji character sets G-4l Teradata SQL

compatibility with DB2 C-l extension beyond DB2 C-20 Teradata transaction mode 9-2 TIME built-in value (SQL) 6-99 Time expressions (SQL) 6-ll TITLE phrase (SQL) 5-69 TITLE phrase (SQL), column definition 4-4 Transaction modes

ANSI and Teradata 9-2 session control 2-29 TranslateName

translation code G-2l Translation code

ASCII G-2l EBCDIC G-2l example install G-l8 table

character E-l

international characters G-6, G-23

TRIM function (SQL) 6-43 TRIM function and concatenation (SQL) 6-28

U

Unary operator (SQL) 6-3 Unconstrained join (SQL) 3-l5 UNION operator (SQL) 7-50 Updatable cursors (SQL) 9-25 UPDATE statement (SQL) 8-254 UPPER function (SQL) 6-5l

Index-10

Teradata RDBMS for UNIX SQL Reference
Index

USER built-in value (SQL) 6-100 USING modifier (SQL) 8-260 UTS

data format F-8

V

Valued CASE expression (SQL) 6-89 VARBYTE data type (SQL) 5-41 VARCHAR character data type (SQL) 5-27 VARGRAPHIC function (SQL) 6-48 VARGRAPHIC function conversion tables J-1 VAX

data format F-9 Views, joins on 3-14 VMS

data format F-9

W

WHERE clause (SQL) 7-11, 8-263 WITH clause (SQL) 7-24, 8-264

Z

ZEROIFNULL function (SQL) 6-7, 6-10

Teradata RDBMS for UNIX SQL Reference

Index-11
Index

Index-12
Cut

0) NCR User Feedback Form

Title: Teradata RDBMS for UNIX SQL Reference

Number: BD10-4957-C Release No: V2R2.0.2 Date: June, 1997

NCR welcomes your feedback on this publication. Your comments can be of great value in helping to improve our information products. To send your comments by email use the following email address: info.products@sandiegoca.ncr.com.

Circle the numbers below that best represent your opinion of this publication.

Ease of use 5 4 3 2

Accuracy 5 4 3 2

Clarity 5 4 3 2

Completeness 5 4 3 2

Organization 5 4 3 2

Appearance 5 4 3 2

Examples 5 4 3 2

Illustrations 5 4 3 2

Job performance 5 4 3 2

Question resolution 5 4 3 2

Overall satisfaction 5 4 3 2

Excellent

Good

Adequate

Fair

Poor

0 = Not applicable

Indicate the ways you feel we could improve this publication.

? Improve the table of contents ? Add more/better quick reference aids
? Improve the overview/introduction ? Add more examples
? Improve the organization ? Add more illustrations
? Improve the index ? Add more step-by-step procedures
? Make it less technical ? Add more troubleshooting information
? Make it more concise/brief ? Add more detail
Write any additional comments you may have below and on additional sheets, if necessary. Include page numbers where applicable.

Fold

If we may contact you concerning your comments, please fill in the information below.

Name: ________________________________________________________________________

Organization: __________________________________________________________________________

Company: ________________________________________________________________________

Address: ________________________________________________________________________

Phone: __________________________________________ FAX:

Thank you for your evaluation of this publication. Fold the form where indicated, tape (please do not staple), and drop in the mail.
Previous << 1 .. 234 235 236 237 238 239 < 240 > 241 >> Next