Index

Special Characters
A B C D E F G H I J K L M N O P Q R S T U V W X

Special Characters

% (percent sign)

use with LIKE (3494)

access plan

definition (3104)

in a package (3109)

in a program (3105)

accessing remote databases

interactive SQL (4122)

activation groups

connection management

example (4414)

add row to table (3205)

adding a column (3591)

adding data to end of table (4292)

adding indexes (3613)

address variable, in dynamic SQL (3949)

advanced coding technique

complex search condition (3478)

inserting multiple rows into a table (3460)

joining data from multiple tables (3515)

aggregating functions (3787)

ALIAS names

creating (3362)

ALIAS statement (3359)

ALL (3560)

allocating storage for SQLDA (4016)

ALTER TABLE (3588)

AND keyword

description (3503)

multiple search condition (3501)

ANY (3561)

API

QSQCHKS (2963)

QSQPRCED (2960)

application

dynamic SQL

designing and running (3965)

overview (3946)

application design

user-defined function (UDF) (3889)

application domain and object-orientation (3685)

application forms using CREATE TABLE example (3857)

application program

creating (3079)

testing SQL statements in (4252)

application requester (4312)

application requester driver (ARD) programs See also ARD (application requester driver) programs

package creation (4513)

running statements (4514)

application server (4313)

ARD (application requester driver) programs (4512)

arithmetic error

in UDFs (3899), (3935)

arithmetic expression error (3257), (3266)

arranging rows (3304)

assignments in dynamic SQL example (3872)

assignments involving different UDTs example (3874)

assignments involving UDTs example (3870)

asterisk (select all columns) (3272)

atomic operation

data definition statements (DDL) (4216)

data integrity (4213)

definition (4212)

Auditing

C2 security (4171)

authority, public (4155) See also public authority

authorization

Create SQL Package (CRTSQLPKG) command (4377)

for creating package (4364)

for running using a package (4365)

ID (4164)

testing (4254), (4264)

auxiliary storage pools (4202), (4246), (4247), (4248)

AVG over a UDT example (3809)

basic SQL statements and clauses (3194)

BETWEEN clause, multiple search condition (3485)

BETWEEN keyword (3484)

bibliography (4601)

Binary Large OBjects (3712) See also BLOBs (Binary Large OBjects)

BLOBs (Binary Large OBjects)

uses and definition (3709)

blocked insert statement (3466)

C2 security

auditing (4172)

call level interface (2956)

call-type

contents with table functions (3914)

call-type, passing to UDF (3911), (3912)

CAST FROM clause (3893), (3927), (3940)

castability (3765)

casting, UDFs (3836)

catalog

database design, use in (3615)

definition (3045)

getting information about (3618)

column (3627)

integrity (4244)

LABEL ON information (3369)

QSYS2 views (3046)

table (3619)

CCSID

connection to non-DB2 UDB for AS/400 (4413)

delimited identifier effect (4411)

dynamic SQL statement (3972)

package considerations (4410)

Change Class (CHGCLS) command (4196)

change information

in table

host variables (3219), (3239)

Change Job (CHGJOB) command (4193)

Change Logical File (CHGLF) command (4185)

Change Physical File (CHGPF) command (4184)

change session attributes

interactive SQL (4092)

changing

data (3218)

information in a table (3161)

table definition (3589), (4308)

changing a column (3593)

Character Large OBjects (3713) See also CLOBs (Character Large OBjects)

check constraints (3632)

check pending (3652), (4226)

checking syntax in interactive SQL (4065)

CHGPF command (3215)

class schedule table (4546)

clause (3344)

AND (3507)

DISTINCT (3473)

FROM (3249)

GROUP BY

example (3303)

HAVING (3310)

INTO

example (3208)

PREPARE statement, use with (3995)

restriction (4015)

NOT (3509)

null value (3318)

OR (3508)

ORDER BY (3311)

SELECT (3271)

SET (3222)

USING DESCRIPTOR (4035)

VALUES (3198)

WHENEVER NOT FOUND (3419)

WHERE

character string (3197)

example (3275), (4030)

expression (3282)

joining tables (3519)

multiple search condition within (3500)

NOT keyword (3301)

WHERE CURRENT OF (3425)

CLI (2958)

CLOBs (Character Large OBjects)

uses and definition (3710)

CLOSQLCSR parameter

effect on implicit disconnect (4429)

CL_SCHED table (4545)

coded character set conversion error (3267)

coding techniques (3191), (3400), (3453)

collating rows (3307)

collection

changing

table definition (4307)

creating (3120)

definition (2992), (3027)

solving problem

paging through retrieved data (4285)

retrieving data a second time (4304)

column

adding (3592)

defining heading (3137), (3368)

definition (2995), (3051)

deleting (3596)

FOR UPDATE OF clause (3413)

getting catalog information about (3628)

name

definition (3284)

SET clause, value (3223)

updating view (3178)

column definition

changing (3594)

column functions (3786)

combining

information from multiple tables (3156)

SELECT statement (3537)

subselect with UNION

example (3536)

command

RUNSQLSTM

errors (4137)

command (CL)

Change Class (CHGCLS) (4197)

Change Job (CHGJOB) (4194)

Change Logical File (CHGLF) (4188)

Change Physical File (CHGPF) (4187)

CHGCLS (Change Class) (4198)

CHGJOB (Change Job) (4195)

CHGLF (Change Logical File) (4190)

CHGPF (Change Physical File) (4191)

Create Duplicate Object (CRTDUPOBJ) (4261)

Create SQL Package (CRTSQLPKG) (4354), (4585)

Create User Profile (CRTUSRPRF) (4167)

CRTDUPOBJ (Create Duplicate Object) command (4262)

CRTUSRPRF (Create User Profile) (4168)

Delete Library (DLTLIB) (4219)

Delete SQL Package (DLTSQLPKG) (4358), (4594)

Display Message Description (DSPMSGD) (4558)

DLTLIB (Delete Library) (4220)

DSPMSGD (Display Message Description) (4559)

Edit Check Pending Constraints (EDTCPCST) (4228)

Edit Rebuild of Access Paths (EDTRBDAP) (4224)

Edit Recovery for Access Paths (EDTRCYAP) (4239)

EDTCPCST (Edit Check Pending Constraints) (4229)

EDTRBDAP (Edit Rebuild of Access Paths) (4225)

EDTRCYAP (Edit Recovery for Access Paths) (4240)

Grant Object Authority (GRTOBJAUT) (4159)

GRTOBJAUT (Grant Object Authority) (4161), (4192)

Override Database File (OVRDBF) (3431), (4182), (4189)

OVRDBF (Override Database File) (3432), (4183)

Reclaim DDM connections (RCLDDMCNV) (4500)

Retrieve Message (RTVMSG) (4563)

Revoke Object Authority (RVKOBJAUT) (4158)

RTVMSG (Retrieve Message) (4566)

Run SQL Statements (RUNSQLSTM) (2951)

RUNSQLSTM (Run SQL Statements) (4132), (4596)

RUNSQLSTM (Run SQL statements) (2952)

RVKOBJAUT (Revoke Object Authority) (4160)

Send Program Message (SNDPGMMSG) (4564)

Send User Message (SNDUSRMSG) (4565)

SNDPGMMSG (Send Program Message) (4567)

SNDUSRMSG (Send User Message) (4568)

Start Commitment Control (STRCMTCTL) (4208)

Start Journal Access Path (STRJRNAP) (4242)

STRCMTCTL (Start Commitment Control) (4209)

STRJRNAP (Start Journal Access Path) (4243)

STRSQL (Start SQL) (4599)

command, CL

Create Structured Query Language Package (CRTSQLPKG) (4580)

CRTSQLPKG (Create Structured Query Language Package) (4579)

Delete Structured Query Language Package (DLTSQLPKG) (4589)

DLTSQLPKG (Delete Structured Query Language Package) (4588)

comment

for RUNSQLSTM (4135)

getting (3377)

COMMENT ON statement

using, example (3372)

COMMIT

keyword (4210)

prepared statements (3978)

statement (4389)

statement description (3042)

commitment control

activation group

example (4417)

committable updates (4463)

description (4204)

distributed connection restrictions (4469)

DRDA resource (4464)

INSERT statement (3213)

job-level commitment definition (4420), (4474)

protected resource (4450)

rollback required (4482)

RUNSQLSTM command (4141)

SQL statement processor (4139)

sync point manager (4448)

two-phase commit (4449)

unprotected resource (4451)

common database problem

solving (4280)

comparison operators (3296)

comparisons involving UDTs example (3862), (3866)

compiled application program object

managing object (3084)

output source file member (3092)

program (3085)

user source file member (3086)

compiling

application program object

output source file member (3093)

program (3098)

user source file member (3087)

compiling a UDF (3791)

completing a unit of work (3452)

complex search condition

performing (3475)

keyword for use in (3482)

multiple search condition (3486)

WHERE clause (3199)

concurrency

data (4177)

definition (4179)

condition

keyword for use in search (3481)

multiple search within a WHERE clause (3498)

performing complex search (3477)

CONNECT statement (4336), (4391)

interactive SQL (4128)

connection

DDM (4496)

determining type (4460)

ending DDM (4498)

protected (4458)

unprotected (4459)

connection management

ARD programs (4516)

commitment control restrictions (4471)

distributed unit of work considerations (4486)

ending connections

DDMCNV effect on (4497)

DISCONNECT statement (4490)

RELEASE statement (4491)

example (4415)

implicit connection

default activation group (4422)

nondefault activation group (4430)

implicit disconnection

default activation group (4423)

nondefault activation group (4431)

multiple connections to same relational database (4418)

connection status

determining (4477)

example (4505)

consistency token (4409)

consistent behavior and UDTs (3840)

constant

definition (3289)

SET clause, value (3225)

constraint (4221)

definition (3061)

referential (3063)

unique (3062)

constraint mechanisms on large objects (3705)

constraints

check (3633)

referential

check pending (3651)

creating tables (3637)

delete rules (3649)

deleting from tables (3647)

inserting into tables (3641)

removing (3639)

update rules (3645)

updating tables (3643)

control information to access large object data (3728)

control structures (3108)

control, commitment (4205)

convention

SQL naming (3015)

system naming (3009)

conversion error (3259)

CORPDATA.DEPARTMENT (department) (4528)

CORPDATA.EMPLOYEE table (4532)

CORPDATA.EMP_ACT (employee to project activity) (4535)

CORPDATA.EMP_ACT table (4536)

CORPDATA.PROJECT (project) (4540)

CORPDATA.PROJECT table (4541)

correlated

names (3581)

references (3582)

correlated subquery

definition (3574)

DELETE statement, use in (3585)

examples

HAVING clause (3578)

UPDATE statement (3583)

WHERE clause (3576)

note on using (3587)

correlation

definition (3555)

name (3159), (3532)

using subquery (3554)

cost of a UDT example (3807)

counter for UDFs example (3942)

counting and defining UDFs example (3811)

CREATE COLLECTION statement (3121)

CREATE DISTINCT TYPE statement

and castability (3767)

examples of using (3847)

to define a UDT (3845)

Create Duplicate Object (CRTDUPOBJ) command (4260)

CREATE FUNCTION statement (3918)

to register a UDF (3797)

CREATE INDEX

sort sequence (3398)

CREATE SCHEMA

statement (4145)

Create SQL Package (CRTSQLPKG) command (4355), (4584)

authority required (4376)

Create Structured Query Language Package (CRTSQLPKG) command (4578)

CREATE TABLE

prompting (4074)

CREATE TABLE statement (3127)

examples of using (3853)

Create User Profile (CRTUSRPRF) command (4166)

CREATE VIEW statement (3176)

creating

index

example (3612)

SQL collection

example (3119)

structured query language package (4582)

table

description (3124)

example (3132)

view (3599)

description (3173)

on a table (3179)

over multiple tables (3184)

creating ALIAS names (3361)

cross join (3529)

CRTDUPOBJ (Create Duplicate Object) command (4263)

CRTSQLPKG (Create SQL Package) command (4583)

CRTSQLPKG (Create Structured Query Language Package) command (4577)

CRTSQLxxx commands (3010)

CRTUSRPRF command

create user profile (4162)

ctr() UDF C program listing (3944)

CURDATE scalar function (3338)

CURRENT DATE special register (3332)

current row (3422)

CURRENT SERVER special register (3336)

current session

printing (4094)

removing all entries from (4097)

CURRENT TIME special register (3333)

CURRENT TIMESTAMP special register (3334)

CURRENT TIMEZONE special register (3335)

cursor

distributed unit of work (4509)

example overview (3408)

example steps (3412), (3428)

open (3416)

open, effect of recovery on (3451)

retrieving SELECT statement result (4020)

scrollable

positioning within a table (3406)

serial

positioning within a table (3404)

using (3402), (3403)

WITH HOLD clause (3450)

CURTIME scalar function (3339)

damage tolerance (4232)

data

adding to the end of table (4294)

paging

retrieved (4287)

retrieving

in reverse order (4289)

updating

as it is retrieved (4296)

previously retrieved (4306)

view, processing (3252)

data definition statement (DDL) (3017)

data dictionary

WITH DATA DICTIONARY clause

CREATE COLLECTION statement (3029)

CREATE SCHEMA statement (3030)

data independence (3209), (3273)

data integrity (3630)

atomic operation (4215)

commitment control (4203)

concurrency (4176)

constraint (4222)

damage tolerance (4234)

data definition statements (DDL) (4217)

function (4173)

index recovery (4237)

journaling (4201)

save/restore (4231)

data manipulation statement (DML) (3018)

data mapping error (3258), (3262)

data protection (4150)

data types

BLOBs (3723)

CLOBs (3724)

DBCLOBs (3725)

object-oriented (3694)

database

design, using the catalog in (3616)

relational (2971)

date format (3348)

specifying current value (3351)

date/time arithmetic (3358)

DB2 Multisystem (2965)

DB2 Query Manager for AS/400 (2953)

DB2 UDB for AS/400 (2937), (2938), (2941) See also DB2 UDB for AS/400, Structured Query Language

distributed relational database support (4327)

DB2 UDB for AS/400 sample table (4522), (4523)

DB2 UDB Query Manager and SQL Development Kit (2939)

distributed relational database support (4328)

DB2 UDB Symmetric Multiprocessing (2967)

DB2 Universal Database

considerations for packages (4382)

DBCLOBs (Double-Byte Character Large OBjects)

uses and definition (3711)

DBCS (double-byte character set)

considerations in interactive SQL (4079)

DBGVIEW(*SOURCE) parameter (4272)

DBINFO keyword (3919)

dbinfo, passing to UDF (3916)

dbminfo argument, elements of (3921)

deadlock detection (4199)

debugging (4256)

common database problem (4281)

program (4269)

DECLARE CURSOR statement

using (3246)

DECLARE statement (3951)

default collection name (DFTRDBCOL) parameter (3011)

DEFAULT keyword

SET clause, value (3238)

default value (3130), (3145), (3210)

inserting in a view (3603)

define

cursor (3411)

defining

column heading (3136), (3366)

table name (3365)

defining the UDT and UDFs example (3881)

definitions (4315)

access plan (3102)

authorization ID (2986)

authorization name (2985)

catalog (3048)

collection (2979), (3028)

column (2982), (3054)

column name (3283)

concurrency (4178)

constant (3288)

constraint (3064)

correlated subquery (3575)

correlation (3556)

CURRENT DATE special register (3326)

current row (3423)

CURRENT SERVER special register (3330)

CURRENT TIME special register (3327)

CURRENT TIMESTAMP special register (3328)

CURRENT TIMEZONE special register (3329)

data definition statement (DDL) (3021)

data dictionary (3034)

data manipulation statement (DML) (3020)

distributed unit of work (4324)

expression (3285)

field (2975)

host variable (3291)

index (3060)

join (3189)

join operation (3157)

journal (3040)

journal receiver (3039)

library (2972)

logical file (2976)

NULL value (3295)

null value (3315)

outer-level SELECT (3552)

output source file member (3095)

package (2984), (3076), (3111), (4353)

physical file (2973)

predicate (3278)

program (3103)

record (2974)

referential integrity (3065)

remote unit of work (4319)

row (2981), (3052)

search condition (3276)

special register (3293)

SQL package (2977)

SQLCODE (4554)

SQLSTATE (4555)

stored procedure (3073)

subquery (3550)

table (2980), (3053)

trigger (3071)

user profile (2978)

user source file member (3089)

USER special register (3331)

view (2983), (3057)

delete current row (3426)

Delete Library (DLTLIB) command (4218)

Delete SQL Package (DLTSQLPKG) command (4359), (4593)

DELETE statement

correlated subquery, use in (3586)

description (3171), (3241)

Delete Structured Query Language Package (DLTSQLPKG) command (4587)

deleting

structured query language package (4591)

deleting a column (3595)

deleting information in a table (3167)

department table

CORPDATA.DEPARTMENT (4529)

DESCRIBE statement

use with dynamic SQL (3984)

DESCRIBE TABLE statement (4388)

description

SQLCODEs and SQLSTATEs (4572)

designing

dynamic SQL application (3962)

DFTRDBCOL (default collection name) parameter (3012)

DFT_SQLMATHWARN configuration parameter (3898), (3934)

diagnostic-message, passing to UDF (3907)

DISCONNECT statement (4337), (4393)

ending connection (4492)

Display Message Description (DSPMSGD) command (4557)

displaying SQLCODE and SQLSTATE description (4556)

DISTINCT (3471)

clause (3472)

keyword (4300)

distinct type (3766)

distributed relational database

accessing remote databases (4125)

application requester (4310)

application server (4311)

committable updates (4457), (4476)

connection management (4416)

multiple connections (4419)

connection restrictions (4470)

connection type

determining (4456)

protected (4454)

unprotected (4455)

consideration for creating packages (4373)

creating packages (4374)

DB2 UDB for AS/400 support (4326)

determining connection status (4475)

distributed RUW example program (4346)

distributed unit of work (4321), (4434), (4501)

ending connections

DDMCNV effect on (4494)

DISCONNECT statement (4488)

RELEASE statement (4489)

first failure data capture (FFDC) (4518)

implicit connection

default activation group (4424)

nondefault activation group (4432)

implicit disconnection

default activation group (4425)

nondefault activation group (4433)

interactive SQL (4126)

packages (4347)

statement in (4368)

precompiler diagnostic messages (4367)

problem handling (4517)

protected connection (4443)

protected resource (4442)

remote unit of work (4316), (4435)

rollback required state (4485)

session attributes (4127)

SQL packages (4348)

sync point manager (4440)

two-phase commit (4441)

unprotected connection (4445)

unprotected resource (4444)

valid SQL statements (4366)

Distributed Relational Database Architecture (DRDA) (2944)

distributed unit of work (4322), (4438), (4502)

connection considerations (4487)

connection status (4481)

connection type (4466)

cursors (4507)

prepared statements (4508)

sample program (4503)

DLTSQLPKG (Delete SQL Package) command (4592)

DLTSQLPKG (Delete Structured Query Language Package) command (4586)

Double-Byte Character Large OBjects (3714) See also DBCLOBs (Double-Byte Character Large OBjects)

DRDA (Distributed Relational Database Architecture) (4314) See also Distributed Relational Database Architecture (DRDA)

DRDA level 1 (4436) See also remote unit of work

DRDA level 2 (4437) See also distributed unit of work

DRDA resource (4467)

DROP PACKAGE statement (4338)

duplicate rows

eliminating (3539)

preventing (3468)

DUW (distributed unit of work) (4325) See also distributed unit of work

dynamic SQL

address variable (3950)

allocating storage (3996)

application (3945), (3964)

building and running statements (3947)

CCSID (3973)

cursor, use in (3989)

DESCRIBE statement (3985)

EXECUTE statement (3956)

fixed-list SELECT statement, using (3990)

parameter marker (4033)

PREPARE statement (3957)

processing non-SELECT statements (3971)

replacing parameter markers with host variables (4036)

run-time overhead (3948)

statements (3019)

varying-list SELECT statement (3983)

Edit Check Pending Constraints (EDTCPCST) command (4227)

Edit Rebuild of Access Paths (EDTRBDAP) command (4223)

Edit Recovery for Access Paths (EDTRCYAP) command (4238)

eliminating duplicate rows (3540)

employee-to-project activity table (4537)

encapsulation and UDTs (3841)

end-of-data

reached (3417)

entering DBCS data (4077)

ERRLVL (4138)

error

data mapping

ORDER BY (3261)

error determination

in distributed relational database

first failure data capture (FFDC) (4519)

establishing

position at end of table (4290)

examples (3374), (3379)

AND (3506), (3510)

application forms using CREATE TABLE (3855)

assignments in dynamic SQL (3871)

assignments involving different UDTs (3873)

assignments involving UDTs (3869)

AVG over a UDT (3808)

BETWEEN (3488)

catalog

getting column information (3625)

getting table information (3623)

changing information in a table (3163)

changing rows in table

host variables (3220), (3240)

COMMENT ON (3375)

comparisons involving UDTs (3861), (3865)

correlated subquery

HAVING clause (3579)

WHERE clause (3577)

correlation name (3160)

cost of a UDT (3806)

counter for UDFs (3941)

counting and defining UDFs (3810)

creating

index (3611)

SQL collection (3118)

table (3133)

view on a table (3183)

views over multiple tables (3187)

ctr() UDF C program listing (3943)

CURRENT DATE (3354)

CURRENT TIMEZONE (3356)

cursor (3409)

cursor in DUW program (4511)

defining stored procedures

with CREATE PROCEDURE (3666)

defining the UDT and UDFs (3880)

deleting information in a table (3169)

determining connection status (4506)

distributed RUW program (4343)

distributed unit of work program (4504)

dynamic CALL (3671)

embedded CALL (3667), (3669)

EXISTS (3570)

exploiting LOB function to populate the database (3882)

exploiting LOB locators to manipulate UDT instances (3886)

exploiting UDFs to query instances of UDTs (3884)

exponentiation and defining UDFs (3798)

extracting a document to a file (CLOB elements in a table) (3751)

function invocations (3817)

getting catalog information about

column (3629)

table (3621)

getting comment (3378)

getting information about

column using catalog (3624)

table using catalog (3622)

getting information from

multiple tables (3155)

single table (3147)

IN (3491)

inserting

add row to table (3206)

multiple rows into a table (3459)

inserting data into a CLOB column (3757)

invoking stored procedures (3672)

where a CREATE PROCEDURE exists (3668)

where no CREATE PROCEDURE exists (3670)

join (3522)

LABEL ON statement (3138), (3371)

LIKE (3495)

list function in interactive SQL (4081)

LOBFILE.SQB COBOL program listing (3755)

LOBFILE.SQC C program listing (3753)

LOBLOC.SQB COBOL program listing (3736)

LOBLOC.SQC C program listing (3734)

money using CREATE DISTINCT TYPE (3848)

multiple search condition (WHERE clause) (3496)

OR (3511)

ORDER BY

sort sequence (3390)

parameter markers in functions (3820)

preventing duplicate rows (3470)

QSYSPRT listing

SQL statement processor (4147)

removing information

from table (3170), (3243)

resume using CREATE DISTINCT TYPE (3849)

returning completion status

to calling program (3681)

sales using CREATE TABLE (3854)

sample table (4526)

search (3487)

search string and BLOBs (3802)

SELECT records

sort sequence (3393)

SELECT statement allocating storage for SQLDA (4011)

selecting into table

host variables (3255)

special register (3355), (3357)

stored procedures

returning completion status (3680)

string search and defining UDFs (3800)

string search over UDT (3804)

subquery (3548)

UNION

Union

simple (3542)

using host variables (3541)

UNION ALL

using host variables (3546)

unqualified function reference (3826)

UPDATE statement (3166)

use of UDTs in UNION (3875)

user-defined sourced functions on UDTs (3867)

using a locator to work with a CLOB value (3732)

using index (3610)

using qualified function reference (3823)

view

sort sequence (3396)

WITH CASCADED CHECK OPTION (3661)

WITH LOCAL CHECK OPTION (3660)

working with index (3607)

exception join (3527)

EXECUTE IMMEDIATE statement (3958)

EXECUTE privileges

for packages (4363)

EXECUTE statement (3953), (3977)

EXISTS keyword, use in subquery (3568)

exiting interactive SQL (4105)

exploiting

LOB function to populate the database example (3883)

LOB locators to manipulate UDT instances example (3887)

UDFs to query instances of UDTs example (3885)

exponentiation and defining UDFs example (3799)

expression

definition (3286)

SET clause, value (3234)

using in the WHERE clause (3280)

extended dynamic

QSQPRCED (2961)

extensibility and UDTs (3838)

extracting a document to a file (CLOB elements in a table) example (3752)

failed session, recovering (4120)

FETCH

using host structure array

multiple-row (3440)

FETCH statement (4022)

FFDC (first failure data capture) (4521) See also first failure data capture (FFDC)

field (2990)

file reference variables

examples of using (3750)

for manipulating LOBs (3720)

input values (3741)

output values (3745)

first failure data capture (FFDC) (4520)

fixed-list SELECT statement

definition (3986)

using (3987)

flexibility and UDTs (3839)

FOR UPDATE OF clause

restrictions (3414)

format, SQLDA (3999)

FROM clause (3248)

function

interactive SQL (4042)

function invocations example (3818)

function path and UDFs (3774)

function references, summary for UDFs (3829)

function selection algorithm and UDFs (3776)

function-name, passing to UDF (3903)

functions

aggregating functions (3783)

column functions (3782)

scalar functions (3781)

syntax for referring to (3816)

table functions (3784)

getting

catalog information about

column (3626)

table (3617)

comment (3376)

information

from multiple table (3153)

from single table (3148)

Grant Object Authority (GRTOBJAUT) command (4157)

GRANT PACKAGE statement (4339)

GROUP BY

clause (3302)

keyword (4298)

using null value with (3305)

grouping the row you select (3306)

HAVING clause (3309)

host structure array

multiple-row FETCH (3441)

host variable

definition (3290)

SET clause, value (3230)

ID, authorization (4165)

IDDU (interactive data definition utility) (3036)

ILE programs

package (4395)

ILE service programs

package (4396)

immediate sensitivity (3436), (3445)

implementing a UDF (3790)

implicit connect (4426) See also connection management

implicit disconnect (4427) See also connection management

IN keyword

description (3490)

subquery, use in (3565)

in tray

table (4550)

index

add (3614)

definition (3059)

recovery (4235)

using (3609)

working with (3606)

indicator variables

stored procedures (3679)

indicator variables and LOB locators (3739)

infix notation and UDFs (3832)

information, inserting into

table (3142)

inner join (3516)

INSERT statement

blocked (3202)

default value (3144), (3211)

description (3200)

VALUES clause (3201)

inserting

information into table (3141)

multiple rows

into tables (3455)

note (3461)

inserting data into a CLOB column example (3758)

instances of object-oriented data types, storing (3700)

Integrated Language Environment (ILE)

module (3113)

program (3106)

service program (3116)

integrity

catalog (4245)

data (3631), (4174)

referential (3635)

interactive data definition utility (3035) See also IDDU

interactive interface

concepts (2947)

Interactive SQL (2948)

interactive SQL

accessing remote databases (4124)

adding DBCS data (4076)

change session attributes (4091)

description (4037)

exiting (4108)

function (4041)

general use (4038)

getting started (4055)

overview (4043)

package (4130)

prompting (4083)

prompting

DBCS consideration (4078)

overview (4050)

session services (4053), (4088), (4103)

statement entry (4047), (4058)

statement processing mode (4068)

syntax checking (4064)

terminology (3003)

testing your SQL statements with (4049), (4111)

INTO clause

description (3207)

PREPARE statements (3994)

restriction (4014)

invoking UDFs (3813)

IN_TRAY table (4549)

job attribute

DDMCNV (4495)

job-level commitment definition (4421), (4473)

join

cross (3530)

definitions (3190)

exception (3528)

inner (3517)

left outer (3525)

join operation

definition (3158)

in a view (3188)

joining

data from multiple tables (3512)

table with WHERE clause (3520)

technique (3531)

journal (3037)

journal receiver (3038)

journaling (4200)

keyword

AND (3502)

BETWEEN (3483)

COMMIT (4211)

DISTINCT (4303)

EXISTS (3569)

GROUP BY (4301)

IN (3489), (3566)

LIKE (3492)

NOT (3299)

OR (3504)

search condition, use in (3479)

UNION (3534), (4302)

UNION ALL, specifying (3544)

LABEL ON statement (3134), (3363)

information in catalog (3370)

package (4407)

large object descriptor (3722)

large object value (3721)

learn how to

prompt

using interactive SQL (4084)

leaving interactive SQL (4107)

left outer join (3523)

library

definition (2987)

LIKE keyword (3493)

linking a UDF (3792)

list function (4086)

list function in interactive SQL

description (4080)

LOBEVAL.SQB COBOL program listing (3756)

LOBEVAL.SQC C program listing (3754)

LOBLOC.SQB COBOL program listing (3737)

LOBLOC.SQC C program listing (3735)

LOBs (Large Objects)

and DB2 object extensions (3695)

file reference variables (3716)

examples of using (3749)

input values (3740)

output values (3744)

SQL_FILE_APPEND, output value option (3748)

SQL_FILE_CREATE, output value option (3746)

SQL_FILE_OVERWRITE, output value option (3747)

SQL_FILE_READ, input value option (3742)

large object descriptor (3718)

large object value (3715)

locators (3717), (3729)

example of using (3731)

indicator variables (3738)

manipulating (3697)

programming options for values (3730)

storing (3696)

synergy with UDTs and UDFs

examples of complex applications (3879)

locators for manipulating LOBs (3719)

logical file (2991), (3058)

LONG VARCHAR

storage limits (3707)

LONG VARGRAPHIC

storage limits (3708)

Loosely Coupled Parallelism (2966)

manipulating large objects (3702)

mapping error

data (3263)

marker, parameter (4027)

maximum size for large object columns, defining (3727)

member

output source file (3097)

user source file (3091)

mode

interactive SQL (4066)

modelling entities as independent objects (3686)

module

Integrated Language Environment (ILE)

object (3112)

money using CREATE DISTINCT TYPE example (3850)

moving large objects using a file reference variable (3726)

multiple

row

inserting into a table (3456)

notes on inserting (3462)

search condition within a WHERE clause (3497)

table

joining data from (3513)

multiple-row FETCH statement

using

descriptor area (3444)

host structure arrays (3438)

row storage area (3443)

with languages (3439)

naming convention

*SQL (3006)

*SYS (3005)

SQL (3014)

system (3008)

negative SQLCODEs (4575)

non-SELECT statements, processing (3969)

NOT keyword (3298), (3505)

NOW scalar function (3340)

NULL value (3129)

null value (3319)

definition (3294)

INSERT statement (3212)

inserting in a view (3604)

SET clause, value (3227)

UPDATE statement (3228)

used with GROUP BY clause (3308)

used with ORDER BY clause (3314)

numeric conversion error (3265)

object

application program (3080)

collection (2997)

module (3081)

Integrated Language Environment (ILE) (3114)

package (3077), (3083)

program

Integrated Language Environment (ILE) (3107)

service program (3082)

Integrated Language Environment (ILE) (3117)

SQL (3026)

object-orientation and UDFs (3764)

object-oriented extensions and UDTs (3843)

object-relational

application domain and object-orientation (3684)

constraint mechanisms (3692)

data types (3688)

definition (3683)

LOBs (3690)

support for (3706)

triggers (3691)

UDTs and UDFs (3689)

why use the DB2 object extensions (3687)

ODBC (3966)

open cursor

during a unit of work (3449)

open database connectivity (ODBC) (3967)

OPEN statement (4031)

operation, atomic (4214)

operators, comparison (3297)

ORDER BY

clause (3312)

using null values with (3313)

data mapping errors (3260)

sort sequence, using (3385)

using (3388)

outer join (3524)

outer-level SELECT (3551)

output source file member

definition (3094)

overloaded function names and UDFs (3775)

Override Database File (OVRDBF) command (3430), (4181), (4186)

overview, interactive SQL (4044)

package

authority to create (4361)

authority to run (4362)

bind to an application (3075)

CCSID considerations for (4412)

consistency token (4408)

Create SQL Package (CRTSQLPKG) command (4351)

authority required (4375)

creating

authority required (4360)

effect of ARD programs (4515)

errors during (4378)

on local system (4402)

RDB parameter (4352)

RDBCNNMTH parameter (4398)

TGTRLS parameter (4384)

type of connection (4397)

unit of work boundary (4399)

creating on a non-DB2 UDB for AS/400

errors during (4379)

required precompiler options for DB2 Common Server (4381)

unsupported precompiler options (4380)

DB2 UDB for AS/400 support (4349)

definition (3074), (3110), (4350)

Delete SQL Package (DLTSQLPKG) command (4356)

deleting (4357)

interactive SQL (4129)

labeling (4406)

restore (4404)

save (4403)

SQL statement size (4385)

statements that do not require package (4386)

paging

retrieved data (4286)

parameter markers

in functions example (3821)

parameter passing

stored procedures (3674), (3678)

table (3676)

parameters

marker (4026)

passing argument to UDF

call-type (3913)

dbinfo (3917)

diagnostic-message (3908)

function-name (3904)

scratchpad (3910)

specific-name (3906)

SQL-argument (3923), (3929)

SQL-argument-ind (3895)

SQL-argument-ind-array (3931)

SQL-result (3925), (3938)

SQL-result-ind (3897), (3933)

SQL-state (3902)

pending

check (3653)

performance

UDFs (3763)

performance and UDTs (3842)

performance verification (4274)

performing complex search condition (3474)

physical file (2988), (3055)

positive SQLCODEs (4573)

precompiler

concepts (2946)

diagnostic messages (4372)

precompiler command

CRTSQLxxx (3387), (4383)

precompiler parameter

DBGVIEW(*SOURCE) (4273)

predicate

definition (3279)

PREPARE statement

non-SELECT statement (3976)

restrictions (3952)

using (4024)

prepared statement

distributed unit of work (4510)

preventing duplicate rows (3467)

printing current session (4093)

problems, solving database (4284) See also collection solving problem

processing

data in a view (3251)

non-SELECT statements (3968)

SELECT statement with SQLDA (3980)

program

application (4253) See also application program

debugging (4270)

definition (3099)

Integrated Language Environment (ILE) object (3100)

non-ILE object (3101)

performance verification (4276)

project table (4542)

prompt

using interactive SQL (4052), (4085)

prompting

CREATE TABLE (4075)

function (4040), (4062)

overview (4051)

subqueries (4073)

protected connections

dropping (4472)

protected resource (4452)

protection, data (4151) See also security

public authority (4153)

QSQCHKS (2962)

QSQPRCED (2959)

package (3078)

QSYS2

catalog views (3047)

QSYSPRT listing

SQL statement processor

example (4148)

re-use and UDFs (3762)

read-only

table (3415)

view (3601)

read-only connection (4468)

receiver, journal (3041)

Reclaim DDM connections (RCLDDMCNV) command (4499)

record selection (3391)

sort sequence, using (3386)

record, definition (2989)

recovering

effect on open cursor (3448)

index (4236)

interactive SQL

saved or failed session (4118)

referential constraints

check pending (3650)

creating tables (3636)

definition (3067)

delete rules (3648)

deleting from tables (3646)

inserting into tables (3640)

removing (3638)

update rules (3644)

updating tables (3642)

referential integrity (3634)

definition (3068)

registering

UDFs (3793)

related information (4602)

relational database (2969)

RELEASE statement (4340), (4394)

ending connection (4493)

remote databases

accessing from interactive SQL (4123)

remote unit of work (4317), (4439)

connection status (4480)

connection type (4465)

example program (4345)

removing all entries from current session (4096)

restriction

FOR UPDATE OF (4297)

result table (3538)

resume using CREATE DISTINCT TYPE example (3851)

Retrieve Message (RTVMSG) command (4560)

retrieving

data

from a table. (3150)

in reverse order (4288)

row

using a cursor (3420)

SELECT statement result

cursor, using (4021)

return code (3264)

RETURNS TABLE clause (3892), (3926), (3939)

reuse deleted records

INSERT (3214)

Revoke Object Authority (RVKOBJAUT) command (4156)

REVOKE PACKAGE statement (4341)

REXX (2954)

ROLLBACK

rollback

prepared statements (3979)

rollback required state (4483)

ROLLBACK statement (4390)

row

definition (2994), (3050)

delete current (3427)

inserting multiple

into a table (3457)

note (3463)

preventing duplicate (3469)

RRN scalar function (3526)

rules that govern operations on large objects (3704)

run mode

interactive SQL (4070)

Run SQL Statements (RUNSQLSTM) command (2949)

run-time support

concepts (2945)

running

dynamic SQL application (3963)

RUNSQLSTM (Run SQL Statements) (4102), (4117)

command (2950), (4131)

command errors (4136)

commitment control (4142)

RUNSQLSTM (Run SQL Statements) command (4595)

RUW (remote unit of work) (4320) See also remote unit of work

sales using CREATE TABLE example (3856)

sample programs

distributed RUW program (4344)

sample tables DB2 UDB for AS/400 (4524)

save/restore (4230)

packages (4405)

saved session

in a source file (4099), (4114)

recovering (4119)

scalar functions (3785)

schedule table

class (4547)

schema-name and UDFs (3778)

schemas

SQL statement processor (4143)

scratchpad, passing to UDF (3909)

scrollable cursor (3407)

search condition

definition (3277)

performing complex (3476)

subqueries (3558)

using keyword in (3480)

security (4152)

authorization (4266)

authorization ID (4163)

commitment control (4206)

data integrity (4175)

concurrency (4180)

public authority (4154)

view (4169)

SELECT clause (3270)

select information

into host variables (3254)

SELECT INTO statement

restriction (3960)

retrieving row (3244)

SELECT statement

definition (3151)

example of allocating storage for SQLDA (4012)

processing and using SQLDA (3981)

using fixed-list (3988)

using varying-list (3993)

selecting

column (3464)

semantic behavior of stored objects (3703)

Send Program Message (SNDPGMMSG) command (4561)

Send User Message (SNDUSRMSG) command (4562)

sensitivity

immediate (3437), (3446)

serial cursor (3405)

service program

Integrated Language Environment (ILE)

object (3115)

services, session (4090) See also session services

session (4121)

printing current (4095)

removing all entries from current (4098)

saving in a source file (4100), (4115)

session services

in interactive SQL (4054), (4089), (4104)

SET clause

description (3221)

value

column name (3224)

constant (3226)

expression (3235)

host variable (3231)

null (3229)

scalar subselect (3237)

special register (3233)

SET CONNECTION statement (4342), (4392)

SET CURRENT FUNCTION PATH statement (3789)

SET TRANSACTION statement

effect on implicit disconnect (4428)

not allowed in package (4371)

SEU (source entry utility) (4113)

signature, two functions and the same (3779)

SMALLINT (3900), (3936)

solving (4283) See also collection, solving problem

common database problem (4279)

solving common problems (4278)

SOME (3562)

sort sequence

CREATE INDEX (3397)

used with ORDER BY (3382)

used with record selection (3383)

using (3381)

views (3394)

source entry utility (SEU) (4112)

source file

for RUNSQLSTM (4134)

member, output

definition (3096)

member, user (3090)

saving a session in (4101), (4116)

sourced UDF (3863)

special register

CURRENT DATE (3320)

CURRENT SERVER (3324)

CURRENT TIME (3321)

CURRENT TIMESTAMP (3322)

CURRENT TIMEZONE (3323)

definition (3292)

SET clause, value (3232)

USER (3325)

specific-name, passing to UDF (3905)

specifying

column, SELECT INTO statement (3269)

UNION ALL (3543)

SQL (2942)

call level interface (2955)

introduction (2943)

object (3025)

statements

types (3016)

SQL collection (3123)

SQL naming convention (3013)

SQL package (2998)

SQL statement processor

commitment control (4140)

example

QSYSPRT listing (4149)

schemas (4144)

using (4133)

SQL-argument, passing to UDF (3922), (3928)

SQL-argument (3890)

SQL-argument-ind, passing to UDF (3894)

SQL-argument-ind-array, passing to UDF (3930)

SQL-result, passing to UDF (3924), (3937)

SQL-result (3891)

SQL-result-ind, passing to UDF (3896), (3932)

SQL-state, passing to UDF (3901)

SQLCODEs

definition (4552)

description (4570)

negative (4576)

positive (4574)

testing application program (4267)

SQLD (4003)

SQLDA (SQL descriptor area)

allocating storage for (4018)

format (3998)

processing SELECT statement (3982)

programming language, use in (3997)

SELECT statement for allocating storage for SQLDA (4013)

SQLDABC (4001)

SQLDAID (4000)

SQLDATA (4008)

SQLERRD field of SQLCA

SQLERRD(3) field of SQLCA

determining connection status (4479)

determining number of rows fetched (3433)

SQLERRD(4) field of SQLCA (4478)

determining connection type (4461)

determining length of each row retrieved (3434)

SQLERRD(5) field of SQLCA

determining end-of-file (3435)

SQLIND (4009)

SQLLEN (4006)

SQLN (4002)

SQLNAME (4010)

SQLRES (4007)

SQLSTATEs

code definition (4569)

definition (4553)

description (4571)

testing application program (4268)

SQLTYPE (4005)

sqludf.h include file for UDFs (3920)

SQLVAR (4004)

SQL_FILE_READ, input value option (3743)

Start Commitment Control (STRCMTCTL) command (4207)

Start Journal Access Path (STRJRNAP) command (4241)

Start SQL (STRSQL) command (4598), (4600)

starting interactive SQL (4057)

statement entry (4048), (4059)

statement processing mode

interactive SQL (4067)

statements (3317)

ALIAS statement

example (3360)

basic, using (3193)

COMMENT ON statement (3373)

COMMIT (3043)

CONNECT (4329)

CREATE COLLECTION (3122)

CREATE INDEX

sort sequence (3399)

CREATE PROCEDURE

external procedure (3664)

SQL procedure (3665)

CREATE SCHEMA (4146)

CREATE TABLE (3128)

CREATE VIEW (3177)

data definition (DDL) (3023)

data manipulation (DML) (3022)

date value (3341)

DECLARE CURSOR (3247)

DELETE

example (3242)

WHERE clause (3172)

DISCONNECT (4330)

DROP PACKAGE (4331)

dynamic (3024)

EXECUTE (3955), (3959), (3975)

FETCH (4023)

multiple-row (3429)

GRANT PACKAGE (4332)

INSERT

using (3203)

LABEL ON statement

example (3364)

examples (3135)

multiple-row FETCH (3442)

OPEN (4032)

package not required (4387)

packages (4369)

PREPARE

cursor (4025)

non-SELECT statement (3974)

using (3954)

processing non select (3970)

RELEASE (4333)

REVOKE PACKAGE (4334)

ROLLBACK (3044)

select (3152)

SELECT INTO

example (3245)

processing data (view) (3250)

restriction (3961)

specifying column (3268)

SET CONNECTION (4335)

SQL packages (4370)

testing

in application program (4251)

using interactive SQL (4046), (4110)

time value (3342)

timestamp value (3343)

UPDATE

changing data value (3165)

example (3217)

stopping interactive SQL (4106)

storage, allocating for SQLDA (4017)

stored procedures (3663), (3682)

definition (3072)

parameter passing (3673)

indicator variables (3677)

table (3675)

storing large objects (3701)

string search and defining UDFs example (3801)

string search on BLOBs (3803)

string search over UDT example (3805)

strong typing and UDTs (3860)

STRSQL (Start SQL) command (4056), (4597)

Structured Query Language (2940)

structured query language package

creating (4581)

deleting (4590)

subquery (3571)

basic comparison (3559)

correlated (3553), (3573)

correlated names and references (3580)

definition (3549)

examples (3547)

EXISTS keyword (3567)

IN keyword (3564)

notes on using

with UPDATE and DELETE (3572)

prompting (4072)

quantified comparison (3563)

search condition (3557)

subselect

combining with the UNION keyword, example (3535)

SET clause, value (3236)

Symmetric Multiprocessing (2968)

sync point manager (4446)

syntax check

QSQCHKS (2964)

syntax check mode

interactive SQL (4069)

syntax for referring to functions (3815)

system naming convention (3007)

system table name (3139)

table

adding data to the end (4293)

changing definition (3590), (4309)

changing information in (3162)

CL_SCHED (class schedule) (4548)

CORPDATA.DEPARTMENT (department) (4531)

CORPDATA.EMPLOYEE (4534)

CORPDATA.EMP_ACT (employee to project activity) (4539)

CORPDATA.PROJECT (project) (4544)

creating

CREATE TABLE statement (3125)

view (3180)

DB2 UDB for AS/400 sample (4525)

defining name (3367)

definition (2993), (3049)

deleting information in (3168)

establishing position at the end (4291)

getting catalog information

about column (3620)

getting information

from multiple (3154)

from one (3149)

inserting

information into (3143)

multiple rows into (3458)

IN_TRAY (4551)

joining (3514)

the WHERE clause (3521)

multiple

creating view over (3186)

sample (4527)

used in examples

CORPDATA.DEPARTMENT (department) (4530)

CORPDATA.EMPLOYEE (4533)

CORPDATA.EMP_ACT (employee to project activity) (4538)

CORPDATA.PROJECT (project) (4543)

using (3126)

table functions (3788)

contents of call-type argument (3915)

table name

system (3140)

technique

coding (3192), (3401), (3454)

solving database problem (4282) See also collection solving problem

terminology

interactive SQL (3004)

relational database (2970)

relationship table

*SQL (3002)

*SYS (3001)

testing

authorization (4255), (4265)

debugging your program (4271)

input data (4257)

performance verification (4277)

SQL statements using interactive SQL (4045), (4109)

statements in application program (4250)

view (4259)

time format (3349)

specifying current value (3352)

timestamp format (3350)

specifying current value (3353)

tolerance, damage (4233)

trigger

definition (3069)

event (3070)

trigger support (3662)

triggers

and DB2 object extensions (3693)

truncation error (3256)

two-phase commit (4447)

typing

interactive SQL (4061)

UDFs (User-defined functions)

and DB2 object extensions (3699)

casting (3835)

concepts (3768)

definition (3759)

function path (3770)

function selection algorithm (3772)

general considerations (3830)

implementing UDFs (3761)

infix notation (3831)

invoking

examples of invocations (3812)

parameter markers in functions (3819)

qualified function reference (3822)

unqualified function reference (3825)

LOB types (3833)

overloaded function names (3771)

process of implementation (3794)

referring to functions (3814)

registering UDFs (3796)

examples of registering (3795)

schema-name and UDFs (3773)

sourced (3864)

summary of function references (3828)

synergy with UDTs and LOBs

examples of complex applications (3878)

type of functions (3780)

unqualified reference (3769)

why use UDFs (3760)

writing your own UDF (3888)

UDFs and LOB types (3834)

UDTs (User-defined types)

and DB2 object extensions (3698)

defining a UDT (3844)

defining tables (3852)

manipulating

examples of (3858)

resolving unqualified UDTs (3846)

strong typing (3859)

synergy with UDFs and LOBs

examples of complex applications (3877)

why use UDTs (3837)

UNION ALL, specifying (3545)

UNION keyword

restriction (4299)

using to combine subselects (3533)

unique constraint

definition (3066)

unit of work

distributed (4323)

effect on open cursor (3447)

package creation (4401)

remote (4318)

rollback required (4484)

unit of work boundary

package creation (4400)

unprotected resource (4453)

unqualified function reference example (3827)

unqualified reference (3777)

UPDATE statement

correlated subquery, using in (3584)

description (3216)

WHERE clause (3164)

updating data

as it is retrieved, restrictions (4295)

committable updates (4462)

previously retrieved (4305)

use of UDTs in UNION example (3876)

user auxiliary storage pool (ASP) (4249)

user profile

authorization ID (3000)

authorization name (2999)

user source file member

definition (3088)

USER special register (3337)

user-defined sourced functions on UDTs example (3868)

USING

Using

using

blocked insert statement (3465)

clause (4019)

cursor

example (3410)

retrieve row (3421)

date value (3345)

DESCRIPTOR clause (4034)

index (3608)

null value (3316)

ORDER BY (3389)

parameter markers (4028)

record selection (3392)

sort sequence (3380), (3384)

time value (3346)

timestamp value (3347)

views (3600)

using a locator to work with a CLOB value example (3733)

using interactive SQL (4039)

after first time (4087)

list selection function (4082)

prompting (4063)

statement entry (4060)

using qualified function reference example (3824)

validate mode

interactive SQL (4071)

value

default (3131), (3146)

inserting

into table or view (3204)

VALUES clause (3196)

varying-list SELECT statement

definition (3991)

using (3992)

verification

performance (4275)

view

creating (3597)

CREATE VIEW statement (3175)

on a table (3181), (3182)

over multiple tables (3185)

definition (2996), (3056)

limiting access (3174)

processing data in (3253)

read-only (3602)

security (4170)

sort sequence (3395)

testing (4258)

using (3598)

WITH CASCADED CHECK (3657)

WITH CHECK (3654)

WITH LOCAL CHECK (3658)

WHENEVER NOT FOUND clause (3418)

WHERE clause

character string (3195)

constant (3287)

description (3274)

example (4029)

expression in, using (3281)

joining tables (3518)

multiple search condition within a (3499)

NOT keyword (3300)

WHERE CURRENT OF clause (3424)

WITH CASCADED CHECK OPTION (3656)

WITH CHECK OPTION (3655)

WITH DATA DICTIONARY clause

CREATE COLLECTION statement (3031)

CREATE SCHEMA statement (3032)

creating data dictionary (3033)

WITH LOCAL CHECK OPTION (3659)

working with

index (3605)

X/Open call level interface (2957)

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