IBM Books

SQL Getting Started

Index

A B C D E F G H I J K L M N O P Q R S T U V W
A
  • ADD CONSTRAINT statement (682)
  • ALL, using in a query (649)
  • ALTER TABLE statement (681)
  • ANY keyword (650)
  • arithmetic operators (556)
  • AS clause (558)
  • authority (447)
  • authorization ID (473)
    • B
  • base table (460)
  • BETWEEN predicate (639)
  • binary integer, description (504)
  • BLOB data type (730)
  • BLOB string (727)
    • C
  • case expression
  • description (591)
  • SIGN function (592)
  • casting data types
  • description (590)
  • CHAR, data type (487)
  • character string
  • fixed length (500)
  • as data type (499)
  • varying length (501)
  • CL_SCHED sample table (761)
  • CLOB data type (729)
  • CLOB string (726)
  • column
  • ASC, ascending order sort (550)
  • definition of (462)
  • DESC, descending order sort (549)
  • column function (569)
  • AVG (573)
  • COUNT (574)
  • MAX (575)
  • MIN (576)
  • column functions (571)
  • combining, queries (614)
  • command line processor (456)
  • common table expression
  • description (596)
  • comparison operator used in a subquery (654)
  • composite key (661)
  • CONNECT statement (532)
  • explicit (533)
  • implicit (534)
  • connecting queries (625)
  • constraints
  • referential constraints (512)
  • unique constraints (513)
  • controlling access to data (442)
  • correlated reference, description (604)
  • correlated subquery
  • description (603)
  • when to use (607)
  • correlation
  • description (602)
  • name (606)
  • subqueries using joins (609)
  • subquery (605)
  • correlation-name
  • qualified reference of column name (600)
  • rules for (601)
  • CREATE DISTINCT TYPE (714)
  • CREATE FUNCTION (724)
  • CREATE TABLE statement (511)
  • NOT NULL/NOT NULL WITH DEFAULT value for column (514)
  • CREATE TRIGGER (688)
  • CREATE VIEW statement (525)
  • WITH CHECK OPTION (527)
  • cross product (701)
  • cross-tabulation rows (708)
  • CUBE (705)
  • cross-tabulation rows (709)
  • sub-total rows (710)
  • CURRENT DATE special register (742)
  • CURRENT FUNCTION PATH special register (743)
  • CURRENT SERVER special register (744)
  • CURRENT TIME special register (745)
  • CURRENT TIMESTAMP special register (747)
  • CURRENT TIMEZONE special register (749)
    • D
  • data conversion
  • join conditions (703)
  • set operators (630)
  • data structure
  • column (467)
  • row (466)
  • value (465)
  • data type
  • distinct (715)
  • data types
  • CHAR (475)
  • DATE (484)
  • DATETIME (483)
  • DECIMAL (477)
  • DOUBLE (478)
  • FLOAT (479)
  • INTEGER (481)
  • REAL (480)
  • SMALLINT (482)
  • TIME (485)
  • TIMESTAMP (486)
  • VARCHAR (476)
  • database manager (454)
  • DATE, data type (496)
  • datetime values, descritption (509)
  • DATETIME, data type (495)
  • DBLOB data type (731)
  • DBLOB string (728)
  • DECIMAL, data type (489)
  • decimal, description (505)
  • DELETE statement (524)
  • DEPARTMENT sample table (762)
  • distinct data type (713)
  • DISTINCT keyword (552), (577)
  • DOUBLE, data type (490)
    • E
  • EMP_ACT sample table (764)
  • EMP_PHOTO sample table (765)
  • EMP_RESUME sample table (766)
  • EMPLOYEE sample table (763)
  • erasing the sample database (760)
  • error messages
  • message identifier (537)
  • SQLSCODE (536)
  • SQLSTATE (535)
  • EXCEPT ALL (621)
  • EXCEPT operator (620)
  • ordering results (632)
  • usage restrictions involving (635)
  • data types (628)
  • EXISTS predicate (645)
  • expressions (557)
  • expressions, naming (559)
  • external scalar function (720)
  • external table function (722)
    • F
  • FLOAT, data type (491)
  • foreign key (674)
  • FROM clause (540)
  • FULL OUTER join (694)
  • fullselect (589)
  • ALL keyword (651)
  • ANY keyword (647)
  • subquery (518), (648)
  • with INSERT statement (519)
  • fullselect, defintion (517)
  • function
  • built-in (565)
  • column (567)
  • description (564)
  • scalar (568)
  • user-defined (566)
    • G
  • graphic string
  • fixed length (502)
  • varying length (503)
  • GROUP BY (554)
  • GROUP BY clause
  • grouping column (584)
  • with HAVING clause (587)
  • grouping column, defintion (583)
    • H
  • HAVING (555)
  • HAVING clause
  • description (586)
    • I
  • IN predicate (637)
  • IN_TRAY sample table (767)
  • inner join (702)
  • INSERT statement (515)
  • NOT NULL/NOT NULL WITH DEFAULT value for column (516)
  • installing the sample database (757)
  • INTEGER, data type (493)
  • interactive SQL, definition (455)
  • INTERSECT ALL (623)
  • INTERSECT operator (622)
  • ordering results (633)
  • usage restrictions involving (636)
  • data types (629)
    • J
  • join
  • correlated subqueries (610)
  • cross product (700)
  • data conversion (704)
  • definition (562)
  • join conditions (698)
  • without join conditions (697)
  • join condition (699)
    • K
  • key
  • composite (659)
  • definition (660)
  • foreign (672)
  • primary (667)
  • unique (662)
    • L
  • large object location, definition (733)
  • LEFT OUTER join (696)
  • LIKE predicate (641)
  • LOB
  • locator, definition (734)
  • string, definition (732)
  • locator (735)
    • M
  • merging results of queries (615)
  • modifying tables through a view (529)
  • WITH CHECK OPTION (530)
  • monitor (446)
  • multiple node relational database, definition (452)
    • N
  • nested table expressions, description (594)
  • nesting correlated subqueries (611)
  • NOT BETWEEN predicate (640)
  • NOT EXISTS predicate (646)
  • NOT IN predicate (638)
  • NOT LIKE predicate (642)
  • null value (612)
  • delete column value (522)
  • null value, descritption (510)
  • numbers, description (506)
    • O
  • ORDER BY clause (548)
  • set operators (631)
  • order of operations (553), (572)
  • ORG sample table (768)
  • outer join
  • description (690)
  • FULL OUTER join (691)
  • LEFT OUTER join (693)
  • RIGHT OUTER join (692)
  • outer-level predicate (653)
  • outer-level query, correlation (608)
    • P
  • parent key, definition (678)
  • partitioned relational database, definition (453)
  • performance (445)
  • precision, as a numeric attribute (508)
  • predicate
  • IS NOT NULL (546)
  • IS NULL (545)
  • primary key (669)
  • privilege (448)
  • PROJECT sample table (769)
    • Q
  • qualifying objects (471), (531)
  • queries, connecting (624)
    • R
  • REAL, data type (492)
  • recover objects (449)
  • recursive queries, description (712)
  • referential integrity constraints
  • definition (656)
  • description (675)
  • foreign key (677)
  • parent key (676)
  • relational database, definition (450)
  • relationship between tables and views (526)
  • removing duplicate rows (551)
  • reserved schemas (472)
  • restrictions
  • for set operators (626)
  • result table (461)
  • retrieving data (538)
  • RIGHT OUTER join (695)
  • ROLL-UP
  • sub-total rows (711)
  • ROLLUP (706)
  • row
  • definition of (463)
  • selecting (542)
    • S
  • SALES sample table (770)
  • sample database
  • erasing (759)
  • installing (758)
  • sample tables (756), (773)
  • scalar fullselects
  • description (588)
  • Scalar function
  • scalar function (570)
  • ABS (578)
  • DECIMAL (595)
  • HEX (579)
  • LENGTH (580)
  • SIGN (582)
  • YEAR (581)
  • schema
  • definition of (470)
  • search condition (544)
  • select list (541)
  • SELECT statement (539)
  • SET clause
  • with UPDATE statement (523)
  • SET CONSTRAINTS statement (683)
  • sign, as a numeric attribute (507)
  • SMALLINT, data type (494)
  • SOME keyword (652)
  • sorting rows (547)
  • sourced function (721)
  • special register (736)
  • CURRENT DATE (737)
  • CURRENT DEGREE (738)
  • CURRENT FUNCTION PATH (740)
  • CURRENT PATH (739)
  • CURRENT SERVER (741)
  • CURRENT TIME (746)
  • CURRENT TIMESTAMP (748)
  • CURRENT TIMEZONE (750)
  • USER (752)
  • STAFF sample table (771)
  • STAFFG sample table (772)
  • string
  • LOB (725)
  • Structured Query Language (SQL), definition (451)
  • sub-total rows (707)
  • subquery
  • definition (563)
  • system catalogs (753)
    • T
  • table (754)
  • base table (458)
  • combine data (join) (560)
  • definition of (457)
  • foreign key (673)
  • primary key (668)
  • qualifying a column name (598)
  • result table (459)
  • sample (755)
  • unique constraint (670)
  • unique key (663)
  • table check constraints
  • deferred constraint checking (680)
  • definition (657)
  • description (679)
  • table expressions
  • description (593)
  • testing for existence (643)
  • testing, existence (644)
  • TIME, data type (497)
  • TIMESTAMP, data type (498)
  • transactions (443)
  • triggers
  • after trigger (685)
  • before trigger (686)
  • CREATE TRIGGER (687)
  • definition (658)
  • description (684)
  • transition variables (689)
    • U
  • UNION ALL (617)
  • UNION operator (616), (619)
  • description (613)
  • ordering results (618)
  • usage restrictions involving (634)
  • data types (627)
  • unique constraint (666), (671)
  • unique constraints
  • definition (655)
  • unique key (664)
  • unique constraint (665)
  • unit of work (444)
  • UPDATE statement (521)
  • USER special register (751)
  • user-defined functions (723)
  • defining (716)
  • external scalar function (717)
  • external table function (719)
  • sourced function (718)
    • V
  • value
  • definition of (464)
  • value in SQL (474)
  • VALUES clause
  • with INSERT statement (520)
  • VARCHAR, data type (488)
  • View
  • view
  • advantages (469)
  • description (468)
  • qualifying a column name (599)
    • W
  • WHERE clause (543)
  • combine table data (join) in SELECT statement (561)
  • grouping considerations (585)
  • WITH CHECK OPTION (528)
  • WITH clause (597)

    • [ Top of Page | Previous Page | Table of Contents | Index ]

    [ DB2 List of Books | Search the DB2 Books ]