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

•access sets

•creating (380)

•adding rows and data (539)

•applications, sample database

•editing (550)

•running (548)

•base database classes (532)

•closing windows (424)

•Computed Column Details window (569)

•connection specification (382)

•creating a new database (536)

•creating tables (537)

•Current Row part (591)

•data link classes (535)

•data manipulation classes (534)

•data source name, changing (387)

•database applications

•developing (468)

•using stored procedures (524), (528)

•database class functions (531)

•database classes, structure (530)

•Database connection specifications window (563)

•database definition classes (533)

•Database Functions category (587)

•database manager, connecting (384)

•database name, changing (386)

•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)

•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)

•DB2 applications

•developing (470)

•DB2 classes

•introduction (476)

•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)

•DB2 development process

•applications required and optional (505)

•coding SQL statements into Smalltalk applications (512)

•creating an SQL statement (509)

•introduction (498)

•precompiling (520)

•DB2 for workstation

•setup (472)

•DB2 services (474)

•DB2 workstation application development (507)

•DELETE statement (567)

•DELETE statement, defining (458)

•deleting databases (540)

•developing database applications (469)

•development process

•DB2

•applications required and optional (504)

•coding SQL statements into Smalltalk applications (513)

•creating an SQL statement (510)

•introduction (497)

•precompiling (521)

•Dumper policy type (517)

•Edit host variable window (580)

•editors

•SQL Editor (393)

•embedded SQL (495)

•ensuring row schema consistency (542)

•error handling

•UNIX (562)

•error handling and overriding (541)

•error messages

•from an ODBC driver (559)

•from the database system (560)

•from the driver manager (561)

•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)

•Expression Details window (576)

•fetch and update policy (397)

•GROUP BY Details window (572)

•HAVING Details window (573)

•high-level qualifiers (428)

•host variables (413)

•Host variables for window (579)

•INSERT Details window (566)

•INSERT statement, defining (454)

•installing features (378)

•loading features (377)

•methods for interacting with DB2 (477)

•MPR files (514)

•Multi-Row Query - Settings window (589)

•Multi-row Query part (588)

•MVS Native

•obtaining a database connection (481)

•using the call attach facility (483)

•ODBC (Open Database Connectivity) (544)

•ODBC Administrator

•UNIX alternative (557)

•ODBC.INI

•creating (546)

•UNIX (555)

•Windows (551)

•ODBC specification

•definition (543)

•Open Database Connectivity (545)

•ORDER BY Details window (574)

•packaging

•MPR files (518)

•setting policies (519)

•Packeting Container Details part

•changing column headings of (408)

•resizing (409)

•working with (407)

•policy type (516)

•Query Result Table part (590)

•query specs

•using the Trailblazer browser to code (493)

•quick forms (403)

•Result Row part (594)

•result sets, handling (466)

•result table

•restricting rows (437)

•sorting rows (429)

•running queries (405), (416)

•sample database applications

•editing (549)

•running (547)

•sample database visual part (399)

•searching databases (418)

•Select a query window (575)

•SELECT Details window (564)

•SELECT statements

•defining (394)

•nesting (445)

•separating strings (515)

•services

•DB2 (475)

•settings, Stored Procedure part (464)

•setup

•DB2 for workstation (473)

•Single-Row Query - Settings window (593)

•Single-Row Query part (592)

•SQL DELETE statement (586)

•SQL Details window (568)

•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)

•SQL Editor

•SQL INSERT statement (585)

•SQL SELECT statement (583)

•SQL Statement - Settings window (596)

•SQL statement examples (582)

•SQL Statement part (595)

•SQL Statement window (570)

•SQL statements

•applications required and optional (506)

•creating (511)

•dynamic definition (501)

•static definition (500)

•using embedded SQL (494)

•writing

•using Smalltalk (491)

•SQL UPDATE statement (584)

•Stored Procedure - Settings window (598)

•Stored Procedure Host Variable window (581)

•Stored Procedure part (597)

•Stored Procedure part, using (463)

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

•stored procedures (523)

•creating with visual parts (527)

•examples for creating (526)

•implementing (525)

•registering (529)

•stored procedures, handling result sets (465)

•summary of changes

•new and changed information (373)

•tables, creating in Smalltalk (538)

•UNIX

•alternative to starting the ODBC Administrator (558)

•ODBC.INI (556)

•UPDATE Details window (565)

•UPDATE statement, defining (448)

•WHERE clause, dynamic (439)

•WHERE Details window (571)

•Windows

•ODBC.INI (552)

•workstation application development

•DB2 (508)

•writing SQL statements (492)