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 (787)
  • add database wizard (917)
  • Administration Guide (547)
  • ALL, using in a query (754)
  • ALTER TABLE statement (786)
  • ANY keyword (755)
  • Application Development Guide (548)
  • arithmetic operators (658)
  • AS clause (660)
  • authorization ID (573)
    • B
  • back up database wizard (919)
  • base table (560)
  • BETWEEN predicate (744)
  • BIGINT, data type (596)
  • binary integer, description (606)
  • BLOB data type (843)
  • BLOB string (840)
  • books (889), (902)
    • C
  • case expression
  • description (696)
  • SIGN function (697)
  • casting data types
  • description (695)
  • CHAR, data type (588)
  • character string
  • fixed length (602)
  • as data type (601)
  • varying length (603)
  • CLOB data type (842)
  • CLOB string (839)
  • CL_SCHED sample table (874)
  • column
  • ASC, ascending order sort (652)
  • definition of (562)
  • DESC, descending order sort (651)
  • column function (671)
  • AVG (675)
  • COUNT (676)
  • MAX (677)
  • MIN (678)
  • column functions (673)
  • combining, queries (719)
  • command line processor (556)
  • common table expression
  • description (701)
  • comparison operator used in a subquery (759)
  • composite key (766)
  • configure multisite update wizard (921)
  • CONNECT statement (634)
  • explicit (635)
  • implicit (636)
  • connecting queries (730)
  • constraints
  • referential constraints (614)
  • unique constraints (615)
  • correlated reference, description (709)
  • correlated subquery
  • description (708)
  • when to use (712)
  • correlation
  • description (707)
  • name (711)
  • subqueries using joins (714)
  • subquery (710)
  • correlation-name
  • qualified reference of column name (705)
  • rules for (706)
  • create database wizard (923)
  • CREATE DISTINCT TYPE (825)
  • CREATE FUNCTION (837)
  • create table space wizard (927)
  • CREATE TABLE statement (613)
  • NOT NULL/NOT NULL WITH DEFAULT value for column (616)
  • create table wizard (925)
  • CREATE TRIGGER (793)
  • CREATE VIEW statement (627)
  • WITH CHECK OPTION (629)
  • creating the sample database (870)
  • cross product (806)
  • cross-tabulation rows (813)
  • CUBE (810)
  • cross-tabulation rows (814)
  • sub-total rows (815)
  • CURRENT DATE special register (855)
  • CURRENT FUNCTION PATH special register (856)
  • CURRENT SERVER special register (857)
  • CURRENT TIME special register (858)
  • CURRENT TIMESTAMP special register (860)
  • CURRENT TIMEZONE special register (862)
    • D
  • data conversion
  • join conditions (808)
  • set operators (735)
  • data structure
  • column (567)
  • row (566)
  • value (565)
  • data type
  • distinct (826)
  • data types
  • BIGINT (583)
  • CHAR (575)
  • DATE (585)
  • DATETIME (584)
  • DECIMAL (577)
  • DOUBLE (578)
  • FLOAT (579)
  • INTEGER (581)
  • REAL (580)
  • SMALLINT (582)
  • TIME (586)
  • TIMESTAMP (587)
  • VARCHAR (576)
  • database manager (554)
  • DATE, data type (598)
  • datetime values, description (611)
  • DATETIME, data type (597)
  • DB2 library
  • books (888)
  • Information Center (910)
  • language identifier for books (893)
  • late-breaking information (895)
  • online help (903)
  • ordering printed books (901)
  • printing PDF books (898)
  • searching online information (936)
  • setting up document server (934)
  • structure of (887)
  • viewing online information (905)
  • wizards (913)
  • DBLOB data type (844)
  • DBLOB string (841)
  • DECIMAL, data type (590)
  • decimal, description (607)
  • DELETE statement (626)
  • DEPARTMENT sample table (875)
  • distinct data type (824)
  • DISTINCT keyword (654), (679)
  • DOUBLE, data type (591)
    • E
  • EMPLOYEE sample table (876)
  • EMP_ACT sample table (877)
  • EMP_PHOTO sample table (878)
  • EMP_RESUME sample table (879)
  • erasing the sample database (873)
  • error messages
  • message identifier (639)
  • SQLSCODE (638)
  • SQLSTATE (637)
  • EXCEPT ALL (726)
  • EXCEPT operator (725)
  • ordering results (737)
  • usage restrictions involving (740)
  • data types (733)
  • EXISTS predicate (750)
  • expressions (659)
  • expressions, naming (661)
  • external scalar function (832)
  • external table function (834)
    • F
  • FLOAT, data type (592)
  • foreign key (779)
  • FROM clause (642)
  • FULL OUTER join (799)
  • fullselect (694)
  • ALL keyword (756)
  • ANY keyword (752)
  • subquery (620), (753)
  • with INSERT statement (621)
  • fullselect, definition (619)
  • function
  • built-in (667)
  • column (669)
  • description (666)
  • online analytical processing (OLAP) (823)
  • scalar (670)
  • table (686)
  • user-defined (668)
    • G
  • graphic string
  • fixed length (604)
  • varying length (605)
  • GROUP BY (656)
  • GROUP BY clause
  • grouping column (689)
  • with HAVING clause (692)
  • grouping column, definition (688)
    • H
  • HAVING (657)
  • HAVING clause
  • description (691)
  • HTML
  • sample programs (892)
    • I
  • IN predicate (742)
  • index wizard (929)
  • Information Center (911)
  • inner join (807)
  • INSERT statement (617)
  • NOT NULL/NOT NULL WITH DEFAULT value for column (618)
  • installing
  • Netscape browser (908)
  • INTEGER, data type (594)
  • interactive SQL, definition (555)
  • INTERSECT ALL (728)
  • INTERSECT operator (727)
  • ordering results (738)
  • usage restrictions involving (741)
  • data types (734)
  • IN_TRAY sample table (880)
    • J
  • join
  • correlated subqueries (715)
  • cross product (805)
  • data conversion (809)
  • definition (664)
  • join conditions (803)
  • without join conditions (802)
  • join condition (804)
    • K
  • key
  • composite (764)
  • definition (765)
  • foreign (777)
  • primary (772)
  • unique (767)
    • L
  • language identifier
  • books (894)
  • large object location, definition (846)
  • late-breaking information (896)
  • LEFT OUTER join (801)
  • LIKE predicate (746)
  • LOB
  • locator, definition (847)
  • string, definition (845)
  • locator (848)
    • M
  • merging results of queries (720)
  • modifying tables through a view (631)
  • WITH CHECK OPTION (632)
  • multiple node relational database, definition (552)
    • N
  • nested table expressions, description (699)
  • nesting correlated subqueries (716)
  • Netscape browser
  • installing (909)
  • NOT BETWEEN predicate (745)
  • NOT EXISTS predicate (751)
  • NOT IN predicate (743)
  • NOT LIKE predicate (747)
  • null value (717)
  • delete column value (624)
  • null value, description (612)
  • numbers, description (608)
    • O
  • OLAP functions (818)
  • aggregate group (819)
  • ordering rows in (820)
  • partitioning rows in (821)
  • OLE DB external table function (835)
  • online analytical processing (822)
  • online help (904)
  • online information
  • searching (938)
  • viewing (907)
  • ORDER BY clause (650)
  • set operators (736)
  • order of operations (655), (674)
  • ORG sample table (881)
  • outer join
  • description (795)
  • FULL OUTER join (796)
  • LEFT OUTER join (798)
  • RIGHT OUTER join (797)
  • outer-level predicate (758)
  • outer-level query, correlation (713)
    • P
  • parent key, definition (783)
  • partitioned relational database, definition (553)
  • PDF (899)
  • performance configuration wizard (931)
  • precision, as a numeric attribute (610)
  • predicate
  • IS NOT NULL (648)
  • IS NULL (647)
  • primary key (774)
  • printing PDF books (900)
  • PROJECT sample table (882)
    • Q
  • qualifying objects (571), (633)
  • queries, connecting (729)
  • Quick Beginnings (545)
    • R
  • REAL, data type (593)
  • recursive queries, description (817)
  • referential integrity constraints
  • definition (761)
  • description (780)
  • foreign key (782)
  • parent key (781)
  • Related Documentation (544)
  • relational database, definition (550)
  • relationship between tables and views (628)
  • release notes (897)
  • removing duplicate rows (653)
  • reserved schemas (572)
  • restore wizard (933)
  • restrictions
  • for set operators (731)
  • result table (561)
  • retrieving data (640)
  • RIGHT OUTER join (800)
  • ROLL-UP
  • sub-total rows (816)
  • ROLLUP (811)
  • row
  • definition of (563)
  • selecting (644)
    • S
  • SALES sample table (883)
  • Sample Database (868)
  • sample database
  • creating (871)
  • erasing (872)
  • sample programs
  • cross-platform (891)
  • HTML (890)
  • sample tables (869), (886)
  • scalar fullselects
  • description (693)
  • Scalar function
  • scalar function (672)
  • ABS (680)
  • DECIMAL (700)
  • HEX (681)
  • LENGTH (682)
  • SIGN (684)
  • YEAR (683)
  • schema
  • definition of (570)
  • search condition (646)
  • searching
  • online information (912), (937)
  • select list (643)
  • SELECT statement (641)
  • SET clause
  • with UPDATE statement (625)
  • SET CONSTRAINTS statement (788)
  • setting up document server (935)
  • sign, as a numeric attribute (609)
  • SMALLINT, data type (595)
  • SmartGuides
  • wizards (914)
  • SOME keyword (757)
  • sorting rows (649)
  • sourced function (833)
  • special register (849)
  • CURRENT DATE (850)
  • CURRENT DEGREE (851)
  • CURRENT FUNCTION PATH (853)
  • CURRENT PATH (852)
  • CURRENT SERVER (854)
  • CURRENT TIME (859)
  • CURRENT TIMESTAMP (861)
  • CURRENT TIMEZONE (863)
  • USER (865)
  • SQL procedure language (549)
  • SQL Reference (546)
  • STAFF sample table (884)
  • STAFFG sample table (885)
  • string
  • LOB (838)
  • Structured Query Language (SQL), definition (551)
  • sub-total rows (812)
  • subquery
  • definition (665)
  • system catalogs (866)
    • T
  • table
  • base table (558)
  • combine data (join) (662)
  • definition of (557)
  • foreign key (778)
  • functions (687)
  • primary key (773)
  • qualifying a column name (703)
  • result table (559)
  • Sample Database (867)
  • unique constraint (775)
  • unique key (768)
  • table check constraints
  • deferred constraint checking (785)
  • definition (762)
  • description (784)
  • table expressions
  • description (698)
  • table function
  • SQLCACHE_SNAPSHOT (685)
  • testing for existence (748)
  • testing, existence (749)
  • TIME, data type (599)
  • TIMESTAMP, data type (600)
  • triggers
  • after trigger (790)
  • before trigger (791)
  • CREATE TRIGGER (792)
  • definition (763)
  • description (789)
  • transition variables (794)
    • U
  • UNION ALL (722)
  • UNION operator (721), (724)
  • description (718)
  • ordering results (723)
  • usage restrictions involving (739)
  • data types (732)
  • unique constraint (771), (776)
  • unique constraints
  • definition (760)
  • unique key (769)
  • unique constraint (770)
  • UPDATE statement (623)
  • USER special register (864)
  • user-defined functions (836)
  • defining (827)
  • external scalar function (828)
  • external table function (831)
  • OLE DB external table function (829)
  • sourced function (830)
    • V
  • value
  • definition of (564)
  • value in SQL (574)
  • VALUES clause
  • with INSERT statement (622)
  • VARCHAR, data type (589)
  • View
  • view
  • advantages (569)
  • description (568)
  • qualifying a column name (704)
  • viewing
  • online information (906)
    • W
  • WHERE clause (645)
  • combine table data (join) in SELECT statement (663)
  • grouping considerations (690)
  • WITH CHECK OPTION (630)
  • WITH clause (702)
  • wizard
  • restore database (932)
  • wizards
  • add database (916)
  • back up database (918)
  • completing tasks (915)
  • configure multisite update (920)
  • create database (922)
  • create table (924)
  • create table space (926)
  • index (928)
  • performance configuration (930)

    • [ Top of Page | Previous Page | Next Page ]