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 (725)
  • Administering Satellites Guide and Reference (841)
  • Administration Guide (821)
  • Administrative API Reference (822)
  • ALL, using in a query (692)
  • ALTER TABLE statement (724)
  • ANY keyword (693)
  • APPC, CPI-C and SNA Sense Codes (824)
  • Application Building Guide (823)
  • Application Development Guide (825)
  • arithmetic operators (599)
  • AS clause (601)
  • authorization ID (516)
    • B
  • base table (503)
  • BETWEEN predicate (682)
  • binary integer, description (547)
  • BLOB data type (773)
  • BLOB string (770)
    • C
  • case expression
  • description (634)
  • SIGN function (635)
  • casting data types
  • description (633)
  • CHAR, data type (530)
  • character string
  • fixed length (543)
  • as data type (542)
  • varying length (544)
  • CLI Guide and Reference (826)
  • CLOB data type (772)
  • CLOB string (769)
  • CL_SCHED sample table (804)
  • column
  • ASC, ascending order sort (593)
  • definition of (505)
  • DESC, descending order sort (592)
  • column function (612)
  • AVG (616)
  • COUNT (617)
  • MAX (618)
  • MIN (619)
  • column functions (614)
  • combining, queries (657)
  • command line processor (499)
  • Command Reference (827)
  • common table expression
  • description (639)
  • comparison operator used in a subquery (697)
  • composite key (704)
  • CONNECT statement (575)
  • explicit (576)
  • implicit (577)
  • connecting queries (668)
  • Connectivity Supplement (831)
  • constraints
  • referential constraints (555)
  • unique constraints (556)
  • correlated reference, description (647)
  • correlated subquery
  • description (646)
  • when to use (650)
  • correlation
  • description (645)
  • name (649)
  • subqueries using joins (652)
  • subquery (648)
  • correlation-name
  • qualified reference of column name (643)
  • rules for (644)
  • CREATE DISTINCT TYPE (757)
  • CREATE FUNCTION (767)
  • CREATE TABLE statement (554)
  • NOT NULL/NOT NULL WITH DEFAULT value for column (557)
  • CREATE TRIGGER (731)
  • CREATE VIEW statement (568)
  • WITH CHECK OPTION (570)
  • cross product (744)
  • cross-tabulation rows (751)
  • CUBE (748)
  • cross-tabulation rows (752)
  • sub-total rows (753)
  • CURRENT DATE special register (785)
  • CURRENT FUNCTION PATH special register (786)
  • CURRENT SERVER special register (787)
  • CURRENT TIME special register (788)
  • CURRENT TIMESTAMP special register (790)
  • CURRENT TIMEZONE special register (792)
    • D
  • data conversion
  • join conditions (746)
  • set operators (673)
  • Data Movement Utilities Guide and Reference (828)
  • data structure
  • column (510)
  • row (509)
  • value (508)
  • data type
  • distinct (758)
  • data types
  • CHAR (518)
  • DATE (527)
  • DATETIME (526)
  • DECIMAL (520)
  • DOUBLE (521)
  • FLOAT (522)
  • INTEGER (524)
  • REAL (523)
  • SMALLINT (525)
  • TIME (528)
  • TIMESTAMP (529)
  • VARCHAR (519)
  • database manager (497)
  • DATE, data type (539)
  • datetime values, descritption (552)
  • DATETIME, data type (538)
  • DB2 Connect Enterprise Edition for OS/2 and Windows NT Quick Beginnings (848)
  • DB2 Connect Enterprise Edition for UNIX Quick Beginnings (849)
  • DB2 Connect Personal Edition Quick Beginnings (829)
  • DB2 Connect User's Guide (830)
  • DB2 Data Links Manager for AIX Quick Beginnings (850)
  • DB2 Data Links Manager for Windows NT Quick Beginnings (851)
  • DB2 Enterprise - Extended Edition for UNIX Quick Beginnings (846)
  • DB2 Enterprise - Extended Edition for Windows NT Quick Beginnings (847)
  • DB2 library
  • books (820)
  • Information Center (858)
  • language identifier for books (855)
  • late-breaking information (856)
  • online help (819)
  • ordering printed books (863)
  • printing PostScript books (862)
  • searching online information (861)
  • setting up document server (859)
  • SmartGuides (818)
  • structure of (817)
  • viewing online information (857)
  • DB2 Personal Edition Quick Beginnings (842)
  • DB2 Query Patroller Administration Guide (852)
  • DB2 Query Patroller Installation Guide (853)
  • DB2 Query Patroller User's Guide (854)
  • DBLOB data type (774)
  • DBLOB string (771)
  • DECIMAL, data type (532)
  • decimal, description (548)
  • DELETE statement (567)
  • DEPARTMENT sample table (805)
  • distinct data type (756)
  • DISTINCT keyword (595), (620)
  • DOUBLE, data type (533)
    • E
  • EMPLOYEE sample table (806)
  • EMP_ACT sample table (807)
  • EMP_PHOTO sample table (808)
  • EMP_RESUME sample table (809)
  • erasing the sample database (803)
  • error messages
  • message identifier (580)
  • SQLSCODE (579)
  • SQLSTATE (578)
  • EXCEPT ALL (664)
  • EXCEPT operator (663)
  • ordering results (675)
  • usage restrictions involving (678)
  • data types (671)
  • EXISTS predicate (688)
  • expressions (600)
  • expressions, naming (602)
  • external scalar function (763)
  • external table function (765)
    • F
  • FLOAT, data type (534)
  • foreign key (717)
  • FROM clause (583)
  • FULL OUTER join (737)
  • fullselect (632)
  • ALL keyword (694)
  • ANY keyword (690)
  • subquery (561), (691)
  • with INSERT statement (562)
  • fullselect, defintion (560)
  • function
  • built-in (608)
  • column (610)
  • description (607)
  • scalar (611)
  • user-defined (609)
    • G
  • Glossary (832)
  • graphic string
  • fixed length (545)
  • varying length (546)
  • GROUP BY (597)
  • GROUP BY clause
  • grouping column (627)
  • with HAVING clause (630)
  • grouping column, defintion (626)
    • H
  • HAVING (598)
  • HAVING clause
  • description (629)
    • I
  • IN predicate (680)
  • inner join (745)
  • INSERT statement (558)
  • NOT NULL/NOT NULL WITH DEFAULT value for column (559)
  • Installation and Configuration Supplement (833)
  • installing the sample database (800)
  • INTEGER, data type (536)
  • interactive SQL, definition (498)
  • INTERSECT ALL (666)
  • INTERSECT operator (665)
  • ordering results (676)
  • usage restrictions involving (679)
  • data types (672)
  • IN_TRAY sample table (810)
    • J
  • join
  • correlated subqueries (653)
  • cross product (743)
  • data conversion (747)
  • definition (605)
  • join conditions (741)
  • without join conditions (740)
  • join condition (742)
    • K
  • key
  • composite (702)
  • definition (703)
  • foreign (715)
  • primary (710)
  • unique (705)
    • L
  • large object location, definition (776)
  • LEFT OUTER join (739)
  • LIKE predicate (684)
  • LOB
  • locator, definition (777)
  • string, definition (775)
  • locator (778)
    • M
  • merging results of queries (658)
  • Message Reference (834)
  • modifying tables through a view (572)
  • WITH CHECK OPTION (573)
  • multiple node relational database, definition (495)
    • N
  • nested table expressions, description (637)
  • nesting correlated subqueries (654)
  • NOT BETWEEN predicate (683)
  • NOT EXISTS predicate (689)
  • NOT IN predicate (681)
  • NOT LIKE predicate (685)
  • null value (655)
  • delete column value (565)
  • null value, descritption (553)
  • numbers, description (549)
    • O
  • ORDER BY clause (591)
  • set operators (674)
  • order of operations (596), (615)
  • ORG sample table (811)
  • outer join
  • description (733)
  • FULL OUTER join (734)
  • LEFT OUTER join (736)
  • RIGHT OUTER join (735)
  • outer-level predicate (696)
  • outer-level query, correlation (651)
    • P
  • parent key, definition (721)
  • partitioned relational database, definition (496)
  • precision, as a numeric attribute (551)
  • predicate
  • IS NOT NULL (589)
  • IS NULL (588)
  • primary key (712)
  • PROJECT sample table (812)
    • Q
  • qualifying objects (514), (574)
  • queries, connecting (667)
  • Quick Beginnings for OS/2 (843)
  • Quick Beginnings for UNIX (844)
  • Quick Beginnings for Windows NT (845)
    • R
  • REAL, data type (535)
  • recursive queries, description (755)
  • referential integrity constraints
  • definition (699)
  • description (718)
  • foreign key (720)
  • parent key (719)
  • relational database, definition (493)
  • relationship between tables and views (569)
  • removing duplicate rows (594)
  • Replication Guide and Reference (835)
  • reserved schemas (515)
  • restrictions
  • for set operators (669)
  • result table (504)
  • retrieving data (581)
  • RIGHT OUTER join (738)
  • ROLL-UP
  • sub-total rows (754)
  • ROLLUP (749)
  • row
  • definition of (506)
  • selecting (585)
    • S
  • SALES sample table (813)
  • sample database
  • erasing (802)
  • installing (801)
  • sample tables (799), (816)
  • scalar fullselects
  • description (631)
  • Scalar function
  • scalar function (613)
  • ABS (621)
  • DECIMAL (638)
  • HEX (622)
  • LENGTH (623)
  • SIGN (625)
  • YEAR (624)
  • schema
  • definition of (513)
  • search condition (587)
  • select list (584)
  • SELECT statement (582)
  • SET clause
  • with UPDATE statement (566)
  • SET CONSTRAINTS statement (726)
  • setting up document server (860)
  • sign, as a numeric attribute (550)
  • SMALLINT, data type (537)
  • SOME keyword (695)
  • sorting rows (590)
  • sourced function (764)
  • special register (779)
  • CURRENT DATE (780)
  • CURRENT DEGREE (781)
  • CURRENT FUNCTION PATH (783)
  • CURRENT PATH (782)
  • CURRENT SERVER (784)
  • CURRENT TIME (789)
  • CURRENT TIMESTAMP (791)
  • CURRENT TIMEZONE (793)
  • USER (795)
  • SQL Getting Started (836)
  • SQL Reference (837)
  • STAFF sample table (814)
  • STAFFG sample table (815)
  • string
  • LOB (768)
  • Structured Query Language (SQL), definition (494)
  • sub-total rows (750)
  • subquery
  • definition (606)
  • system catalogs (796)
  • System Monitor Guide and Reference (838)
    • T
  • table (797)
  • base table (501)
  • combine data (join) (603)
  • definition of (500)
  • foreign key (716)
  • primary key (711)
  • qualifying a column name (641)
  • result table (502)
  • sample (798)
  • unique constraint (713)
  • unique key (706)
  • table check constraints
  • deferred constraint checking (723)
  • definition (700)
  • description (722)
  • table expressions
  • description (636)
  • testing for existence (686)
  • testing, existence (687)
  • TIME, data type (540)
  • TIMESTAMP, data type (541)
  • triggers
  • after trigger (728)
  • before trigger (729)
  • CREATE TRIGGER (730)
  • definition (701)
  • description (727)
  • transition variables (732)
  • Troubleshooting Guide (839)
    • U
  • UNION ALL (660)
  • UNION operator (659), (662)
  • description (656)
  • ordering results (661)
  • usage restrictions involving (677)
  • data types (670)
  • unique constraint (709), (714)
  • unique constraints
  • definition (698)
  • unique key (707)
  • unique constraint (708)
  • UPDATE statement (564)
  • USER special register (794)
  • user-defined functions (766)
  • defining (759)
  • external scalar function (760)
  • external table function (762)
  • sourced function (761)
    • V
  • value
  • definition of (507)
  • value in SQL (517)
  • VALUES clause
  • with INSERT statement (563)
  • VARCHAR, data type (531)
  • View
  • view
  • advantages (512)
  • description (511)
  • qualifying a column name (642)
    • W
  • What's New (840)
  • WHERE clause (586)
  • combine table data (join) in SELECT statement (604)
  • grouping considerations (628)
  • WITH CHECK OPTION (571)
  • WITH clause (640)

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

    [ DB2 List of Books | Search the DB2 Books ]