o .ini configuration file, changing database (or data source) name (388)

o access sets

 creating (380)

o adding rows and data (539)

o applications, sample database

 editing (550)

 running (548)

 base database classes (532)

o closing windows (424)

o Computed Column Details window (569)

o connection specification (382)

o creating a new database (536)

o creating tables (537)

o Current Row part (591)

o data link classes (535)

o data manipulation classes (534)

o data source name, changing (387)

o database applications

 developing (468)

 using stored procedures (524), (528)

o database class functions (531)

o database classes, structure (530)

o Database connection specifications window (563)

o database definition classes (533)

o Database Functions category (587)

o database manager, connecting (384)

o database name, changing (386)

o database support (374)

 applying changes to a database (410)

 commit (411)

 connecting to a database manager (379)

 creating a connection specification (383)

 creating a query (389)

 example settings (390)

 creating an access set (381)

 defining a DELETE statement (459)

 defining a SELECT statement (395)

 defining an INSERT statement (455)

 defining an UPDATE statement (449)

 displaying a single column (421)

 dynamic WHERE clause, using (440)

 establishing a database connection (385)

 fetch and update policy (398)

 formatting rows as strings (425)

 high-level qualifiers, using (427)

 host variables (414)

 loading database features (376)

 nesting SELECT statements (443)

 quick form of a database query (404)

 restricting rows in a result table (435)

 results of a database query, using (401)

 rollback (412)

 running a database query (406), (417)

 saving changes (423)

 sorting rows in a result table (430)

 SQL Editor, using (391)

 tearing off results of a database query (402)

 transactions (420)

o DB2

 binding (522)

 developing an application for (499)

 developing applications for (471)

 host variables

 as instances of AbtRecord (496)

 methods for interacting with (478)

 SQL statements

 dynamic definition (503)

 static definition (502)

 using Smalltalk classes (479)

o DB2 applications

 developing (470)

o DB2 classes

 introduction (476)

o DB2 database

 cleaning up (484)

 deleting a row (488)

 MVS Native

 obtaining a database connection (482)

 obtaining an active connection (480)

 outputting messages (490)

 running dynamic SQL (485)

 running non-SELECT statements statically (486)

 running SELECT statements statically (487)

 updating a row (489)

o DB2 development process

 applications required and optional (505)

 coding SQL statements into Smalltalk applications (512)

 creating an SQL statement (509)

 introduction (498)

 precompiling (520)

o DB2 for workstation

 setup (472)

o DB2 services (474)

o DB2 workstation application development (507)

o DELETE statement (567)

o DELETE statement, defining (458)

o deleting databases (540)

o developing database applications (469)

o development process

 DB2

 applications required and optional (504)

 coding SQL statements into Smalltalk applications (513)

 creating an SQL statement (510)

 introduction (497)

 precompiling (521)

o Dumper policy type (517)

o Edit host variable window (580)

o editors

 SQL Editor (393)

o embedded SQL (495)

o ensuring row schema consistency (542)

o error handling

 UNIX (562)

o error handling and overriding (541)

o error messages

 from an ODBC driver (559)

 from the database system (560)

 from the driver manager (561)

o examples

 DELETE statement (461)

 displaying a single column from a query result (422)

 displaying rows as strings (426)

 dynamic WHERE clause (442)

 host variable (415)

 INSERT statement (457)

 multi-row query (375)

 nested SELECT statement (446)

 ORDER BY clause (432)

 restricting result rows (438)

 sample database visual part (400)

 searching databases (419)

 single-row query (462)

 specifying column sequence (434)

 UPDATE statement (451)

o Expression Details window (576)

o fetch and update policy (397)

o GROUP BY Details window (572)

o HAVING Details window (573)

o high-level qualifiers (428)

o host variables (413)

o Host variables for window (579)

o INSERT Details window (566)

o INSERT statement, defining (454)

o installing features (378)

o loading features (377)

o methods for interacting with DB2 (477)

o MPR files (514)

o Multi-Row Query - Settings window (589)

o Multi-row Query part (588)

o MVS Native

 obtaining a database connection (481)

 using the call attach facility (483)

o ODBC (Open Database Connectivity) (544)

o ODBC Administrator

 UNIX alternative (557)

o ODBC.INI

 creating (546)

 UNIX (555)

 Windows (551)

o ODBC specification

 definition (543)

o Open Database Connectivity (545)

o ORDER BY Details window (574)

o packaging

 MPR files (518)

 setting policies (519)

o Packeting Container Details part

 changing column headings of (408)

 resizing (409)

 working with (407)

o policy type (516)

o Query Result Table part (590)

o query specs

 using the Trailblazer browser to code (493)

o quick forms (403)

o Result Row part (594)

o result sets, handling (466)

o result table

 restricting rows (437)

 sorting rows (429)

o running queries (405), (416)

o sample database applications

 editing (549)

 running (547)

o sample database visual part (399)

o searching databases (418)

o Select a query window (575)

o SELECT Details window (564)

o SELECT statements

 defining (394)

 nesting (445)

o separating strings (515)

o services

 DB2 (475)

o settings, Stored Procedure part (464)

o setup

 DB2 for workstation (473)

o Single-Row Query - Settings window (593)

o Single-Row Query part (592)

o SQL DELETE statement (586)

o SQL Details window (568)

o SQL editor

 add to operand lists, using (453)

 column sequence, specifying (433)

 column values, setting (452)

 computed columns, working with (447)

 defining a DELETE statement (460)

 defining a SELECT statement (396)

 defining an INSERT statement (456)

 defining an UPDATE statement (450)

 dynamic WHERE clause, defining (441)

 nesting SELECT statements (444)

 restricting rows in a result table (436)

 sorting rows in a result table (431)

 using (392)

o SQL Editor

o SQL INSERT statement (585)

o SQL SELECT statement (583)

o SQL Statement - Settings window (596)

o SQL statement examples (582)

o SQL Statement part (595)

o SQL Statement window (570)

o SQL statements

 applications required and optional (506)

 creating (511)

 dynamic definition (501)

 static definition (500)

 using embedded SQL (494)

 writing

 using Smalltalk (491)

o SQL UPDATE statement (584)

o Stored Procedure - Settings window (598)

o Stored Procedure Host Variable window (581)

o Stored Procedure part (597)

o Stored Procedure part, using (463)

o Stored Procedure Specifications - Settings window (577), (578)

o stored procedures (523)

 creating with visual parts (527)

 examples for creating (526)

 implementing (525)

 registering (529)

o stored procedures, handling result sets (465)

o summary of changes

 new and changed information (373)

o tables, creating in Smalltalk (538)

o UNIX

 alternative to starting the ODBC Administrator (558)

 ODBC.INI (556)

o UPDATE Details window (565)

o UPDATE statement, defining (448)

o WHERE clause, dynamic (439)

o WHERE Details window (571)

o Windows

 ODBC.INI (552)

o workstation application development

 DB2 (508)

o writing SQL statements (492)