DB2 Server for VSE & VM: Application Programming

Index

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

Special Characters

convention (3000)

See also shift-out character (3265)

referential

integrity

new tables (4230)

Numerics

24-bit addressing (3515)

31-bit addressing (3514)

access

concurrent (4048)

table belonging to other users (3153)

adding

columns

to a table (4098)

in SQL expressions (3274)

additional predicates (3236)

ALL

select-clause (3144)

ALL keyword

subqueries (3428)

ALLOCATE statement of PL/I (4576)

ALTER TABLE

privileges (4232)

altering

table (4096)

AND operator (3225)

ANSI (3664), (3873)

ANY (3426)

APOST preprocessor parameter (3557), (3787)

application

CMS (3034)

application epilog

batch applications (3046)

CICS/VSE applications (3061)

ICCF applications (3047)

application program

example (3100)

ARIDBS (3706)

ARIDDFP (3919)

ARIDSQLA (3918)

ARIPADR4 (3705), (3915)

ARIPEIFA (3702)

ARIPRDID

DB2 Server for VSE linkage module (3912)

ARIPRPA preprocessor (3751)

ARIPRPC preprocessor (3752)

ARIPRPF preprocessor (3753)

ARIPRPP preprocessor (3750)

ARIPSTR (3703)

ARIRCAN (3039)

ARIRRTED, DB2 Server for VSE linkage module (3914)

ARIS6ASC

sample program (4255)

ARIS6ASD

sample program (4252)

source code (4251)

ARIS6CBC

sample program (4394)

source code (4391)

ARIS6CBD

sample program (4390)

source code (4387)

ARIS6CC

sample program (4315)

source code (4312)

ARIS6CD

sample program (4311)

source code (4308)

ARIS6FTC (4474)

sample program (4478)

source code (4475)

ARIS6FTD (4468)

sample program (4472)

source code (4469)

ARIS6PLC

sample program (4535)

source code (4532)

ARIS6PLD

sample program (4531)

source code (4528)

ARISSMA (3707)

ARISSMF (3704)

ARISYSDD (3917)

arithmetic error

outer select (4187)

arithmetic operator

in syntax diagrams (2989)

ASM preprocessor parameter (3538)

assembler

acquiring the SQLDSECT area (4257)

data types (4288)

declaring host variables (4262)

declaring the SQLCA (4281)

declaring the SQLDA (4283)

embedding SQL statements

example (3014), (4270)

sample program (4250)

stored procedures (4305)

atomic integrity (4200)

authority

granting (4139)

overview (4146)

revoking from others (4162), (4163)

authorization-ID

naming conventions (3127)

automatic

revocation of privileges (4170)

automatic rollback

data definition statements (4077)

deadlocks (4063)

backing out

changes (3092)

backout

definition (4062)

backslash

hex value (4320)

based structures (3969)

basic form

description (3005)

batch, application programs

remote CICS/VSE transactions (3742)

batch applications, modules required (3910)

batch program termination (3044)

BEGIN DECLARE SECTION (3010)

BIND preprocessor parameter (3795)

BLocK

preprocessor parameter (3565)

blocking (3687), (3894)

remote unit of work (3569), (3689)

blocks

pages (4032)

C programming language

C (4371)

C compiler preprocessor (4330)

case sensitivity (4325)

character constants in SQL statements (4327)

considerations (4307)

data conversion considerations (4342)

data types (4365)

date calculations (4346)

DBCS data (4351)

declaring host variables (4332)

declaring SQLCA (4357)

declaring SQLDA (4361)

delimiting SQL statements (4322)

dynamic allocation of SQLDA (4363)

embedding SQL statements

example (3015)

INCLUDE statement (4328)

NUL-terminated strings and truncation (4344)

placement of SQL statements (4319)

preprocessor generated statements (4353)

preprocessor parameter (3540)

reentrant programs (4383)

stored procedures (4385)

trigraphs (4348)

case sensitivity

C (4324)

catalog tables (4180)

CBND transaction (3929)

CCSIDGraphic preprocessor parameter (3571)

CCSIDMixed preprocessor parameter (3573), (3797)

CCSIDSbcs preprocessor parameter (3575), (3799)

CESN transaction (3733)

changing

data type of a column (4093)

CHAR data type

assembler (4294)

COBOL (4451), (4452)

FORTRAN (4517)

PL/I (4585)

character

data (3312)

string

constant (3311)

character constant

SQL statements

C (4326)

character subtype

CCSID (3258)

constant (3314)

default values (3260)

overriding defaults (3261)

CHARSUB preprocessor parameter (3577), (3801)

CHECK preprocessor parameter (3806)

checking

SQLCA (3953)

choose

in syntax diagrams (2992)

CICS/VSE

CONNECT considerations (3031), (3729)

DB2 Server for VSE linkage module (3913)

logical unit of work considerations (3072)

program termination (3058)

running in batch (3743)

table entries required (3074)

use of WHENEVER (3957)

CICS/VSE default rules

user IDs (3735)

CICSUSER default user ID (3740)

CIRB transaction (3739)

clause

order (3412)

format (3206)

closed state of cursor (3174)

CMS

applications (3032)

work units (4193)

CMS SUBSET

LUW (4194)

SQLRMEND EXEC (4195)

COB2 preprocessor parameter (3810), (4415), (4419)

COBOL

31-bit addressing (3513)

COB2 compiler option consideration (4417), (4421)

COBRC compiler option consideration (4427)

column 7 (4433)

continuation of SQL statements (4398)

COPYBOOKs (4423)

data conversion considerations (4430)

data types (4445)

DBCS data (4435)

declaring host variables (4403)

declaring SQLCA (4439)

delimiting SQL statements (4400)

DYNAM compiler option (4465)

dynamic statement restrictions (4442)

embedding SQL statements

example (3016)

module required (3916)

placement of SQL statements (4396)

preprocessor parameter (3537)

QUOTE compiler option consideration (4413)

sample program (4386)

stored procedures (4467)

using the COB2 parameter (4418)

using the COBRC parameter (4424)

using the INCLUDE statement (4428)

COBRC preprocessor parameter (3812), (4425)

colon

used in indicator variables (3331)

column

correlation function (3450)

join considerations (3372)

naming convention (3117)

virtual (3343)

combining

queries (3469)

COMma preprocessor parameter (3615)

COMMENT ON (4126)

COMMIT (3085)

recommendations (3054)

committing changes

tables (3088)

common column names (3373)

comparison

operator (3231)

compiling

program (3696), (3900)

concatenation

EXECUTE IMMEDIATE (3963)

operator (3299)

symbol (3300)

concurrent

access (4046)

CONNECT

application programs (3029)

statement (3521)

CONNECT authority

description (4138)

granting (4142)

connecting DB2 Server for VSE & VM

application programs (3028)

connecting to the application server

CICS/VSE transactions (3731)

consistency

of data (3067)

token (3582), (3710), (3725), (3816), (3921) , (3927)

constant

CCSID (3316)

character subtypes (3315)

search conditions (3289)

select-list expressions (3151)

constraint

defer (4245)

enforce (4244)

naming conventions (3128)

referential (4213)

contention

for resources (4047)

continuation of SQL statements

assembler (4273)

C (4318)

COBOL (4397)

FORTRAN (4482)

PL/I (4538)

placement of SQL statements (4483)

conventions

syntax diagram notation (2984)

conversion of data (3976), (3977) See also data conversion

See data conversion (3978)

converting SQL statements (3930)

COPYBOOKs, COBOL (4422)

correlation (3438)

function (3449)

name (3444)

subqueries using joins (3451)

subquery (3441)

table (3446)

COUNT(*) in a grouping query (3399)

CREATE INDEX (4107)

CREATE SYNONYM (4120)

CREATE TABLE (4081)

CREATE VIEW

WITH CHECK OPTION (3339)

creating

indexes (4108)

synonym (4121)

table (4083)

field procedure (4089)

NULL value (4087)

referential integrity (4085)

unique constraint (4091)

view (3341)

CTOKEN preprocessor parameter (3580), (3814)

cultural sorting (3163), (4189)

current row of a cursor (3178)

cursor

closed state (3176)

closing (3205)

current row (3177)

declaring (3180)

description (3168)

fetching (3192)

inserting (3201)

locking stability (3674), (3883)

management (3170)

name

syntax rules (3183)

naming convention (3122)

open state (3175)

opening (3187)

ordering results (3209)

result table (3172)

scope (3185)

data

consistency (3068)

inconsistent (3071)

virtual (3345)

data code

SQLDA

datetime (3980)

data conversion

C (4343)

COBOL (4431)

dynamically defined statements (3975)

FORTRAN (4502)

join conditions (3368)

PL/I (4561)

summary (3262)

unions (3477)

data definition (4076)

data integrity

atomic integrity (4198)

entity integrity (4201)

referential integrity (4207)

unique on columns (4204)

Data Integrity

Data Propagator Capture

on tables (4190)

data type

assembler (4287)

C (4364)

CHARACTER (3242)

COBOL (4444)

DATE (3248)

DECIMAL (3240)

description (3012), (3237)

FLOAT (3241)

FORTRAN (4510)

GRAPHIC (3244)

INTEGER (3238)

LONG VARCHAR (3243)

LONG VARGRAPHIC (3247)

PL/I (4577)

SMALLINT (3239)

TIME (3249)

TIMESTAMP (3250)

VARCHAR (3246)

VARGRAPHIC (3245)

database administrator (DBA)

description (4137)

date arithmetic

C (4347)

DATE data type

assembler (4301)

C (4378)

COBOL (4459)

FORTRAN (4524)

PL/I (4592)

datetime

constants (3322)

DB2 Server for VSE & VM

catalog tables (4181)

data types, introduction (3013)

DB2 Server for VSE production libraries (3728)

DBA (database administrator)

granting authority (4141)

dbextent

description (4020)

DBFile preprocessor parameter

VM (3655)

DBList preprocessor parameter

VM (3657)

DBname parameter

preprocessor (3647)

DBP (Dynamic Backout Program) (3078)

dbspace (3120)

creating (4016)

defining (4015)

dropping (4073)

lock size (4042)

naming conventions (3110)

owner (4021)

dcssID parameter

preprocessor (3649)

deadlock

description (4058)

DECIMAL data type

assembler (4291)

C (4368)

COBOL (4448)

FORTRAN (4514)

PL/I (4582)

DECLARE CURSOR

coded queries (3181)

declaring

host variables

assembler (4263)

C (4331)

COBOL (4402)

FORTRAN (4487)

PL/I (4549)

return code structure

assembler (4279)

C (4355)

COBOL (4437)

FORTRAN (4503)

PL/I (4564)

static external variables

PL/I (4548)

default

in syntax diagrams (2994)

defining

indexes (4110)

synonym (4122)

tables (4084)

field procedure (4090)

NULL value (4088)

referential integrity (4086)

unique constraint (4092)

view on view (3348)

DELETE

delete rules (4242)

rules (4241)

delete connected

table (4221)

deleting

tables (4103)

delimiting SQL statements

assembler (4271)

C (4321)

COBOL (4399)

dynamic execution (3962)

PL/I (4542)

dependent

table (4219)

descendent

table (4223)

DESCRIBE

usage techniques (3968)

DFHCSDUP (3083)

DFHSIT (3075)

DISPLAY SIGN HEADING SEPARATE (4432)

DISTINCT

HAVING clause (3407)

select-clause (3142)

distributed applications

application server (3001), (3003)

distributing packages (3724), (3926)

division in SQL expressions (3273)

double-byte character set (DBCS)

characters for C (4375)

constants (3319)

data (4354)

assembler (4277)

C (4352)

COBOL (4436)

FORTRAN (4499)

PL/I (4563)

data type (4456), (4589)

assembler (4298)

FORTRAN (4521)

double precision float (3251)

double quotation marks

considerations in COBOL (3561), (3791)

DROP DBSPACE (4074)

DROP TABLE (4101)

DROP VIEW (3358)

dropping

column (4094)

table (4102)

view (3360)

DSECTs used by the database manager (4259)

DTB (Dynamic Transaction Backout) (3080)

duration

date (3323), (4183)

labeled (4182)

lock (4056)

time (3324), (4184)

timestamp (3325), (4185)

DYNALC preprocessor parameter (3592), (3826)

DYNAM compiler option

COBOL (4464)

Dynamic Backout Program (DBP) (3079)

dynamic data conversion (3974)

assembler (4284)

C (4359)

COBOL (4441)

FORTRAN (4507)

PL/I (4569)

dynamic SQL

description (3104)

dynamic statements

comparison with extended dynamic statements (4002)

data conversion (3979)

description (3997)

extended (3996), (4007)

comparison with dynamic statements (4001)

introduction (3994)

relationship between (3999)

remote unit of work considerations (4011)

logical unit of work considerations (4008)

SQLDA use (3983)

Dynamic Transaction Backout (DTB) (3081)

END DECLARE SECTION (3011)

ending logical units of work

batch applications (3052)

CICS/VSE transactions (3063)

ICCF applications (3053)

entity integrity (4203)

erasing

tables (4104)

error handling

application programs (3944)

description (3931)

preprocessors (3759)

ERROR preprocessor parameter (3579), (3803), (3808)

evaluating

predicates (3234)

examining the SQLCA (3956)

exclusive lock

description (4051), (4070)

EXEC

sample programs (3101)

SQLINIT (3517)

SQLPREP (3529)

SQLSTART (3718)

EXECUTE

usage techniques (3967)

EXECUTE IMMEDIATE

usage techniques (3961)

EXECUTE privilege

automatic revocation (4172)

executing applications

multiple user mode (3713)

single user mode (3715)

EXIST preprocessor parameter (3585), (3819)

EXISTS predicate (3457)

expanding tables (4097)

EXPLAIN preprocessor parameter (3589), (3823)

expression

adding (3275)

constants used (3288)

description (3269), (3292)

dividing (3278)

host variables (3284)

multiplying (3277)

subtracting (3276)

extended dynamic statement

assembler example (4005)

comparison with dynamic statements (4000)

description (3995)

introduction (3993)

logical unit of work considerations (4006)

relationship between (3998)

remote unit of work considerations (4010)

external source member

including (3690)

FETCH

description (3194)

error handling for a select-list (3959)

format (3193)

fetch and insert blocking (3686), (3893)

field procedure

collating sequence (3165)

using (4188)

FIPS (3663), (3872)

Flagger

description (3660), (3869)

SQLFLAG (3862)

FLOAT data type

assembler (4292), (4293)

C (4369), (4370)

COBOL (4449), (4450)

FORTRAN (4515), (4516)

PL/I (4583), (4584)

FOR update-clause (3164)

foreign key (4229)

FORTRAN (4500)

continuation of SQL statements (4484)

data types (4511)

declaring host variables (4486)

embedding SQL statements (4494)

example (3017)

long character strings (4496)

preprocessor

restrictions (4509)

preprocessor parameter (3539)

sample program (4473), (4479)

fragment of syntax

in syntax diagrams (2997)

FROM

correlation name (3445)

description (3152)

joins (3365)

PREPARE statement (3990)

fullselect

description (3135)

functions

used in grouping (3398)

general rules for naming data objects (3105)

GRANT option

description (4158)

granting

authorities (4140)

already owned (4145)

graphic constants

PL/I formats (3321)

SQL format (3320)

GRAPHIC data type

assembler (4297)

C (4374)

COBOL (4455)

FORTRAN (4520)

PL/I (4588)

GRaphic preprocessor parameter (3594), (3828)

group-by-clause

description (3157)

GROUP BY clause

correlated subquery considerations (3447)

description (3396)

subqueries (3436)

group query (3158) See also group-by-clause

See group-by-clause (3159)

grouping

feature (3397)

grouping queries

VARCHAR (3400)

VARGRAPHIC (3401)

HAVING clause

correlated subqueries (3448)

description (3161), (3406)

subqueries (3417), (3437)

header pages (4029)

hexadecimal constants

within expressions (3317)

host language

description (3004)

host structure (4269), (4337), (4408), (4492), (4555)

COBOL (4410)

description (3306)

host variable

assembler (4276)

declared in assembler (4264)

declared in C (4333), (4339), (4558)

declared in COBOL (4404)

declared in FORTRAN (4488)

declared in PL/I (4551)

description (3301)

dynamically defined statements (3992)

FORTRAN (4497)

function parameters

used in C (4341)

in syntax diagrams (2986)

INTO clauses (3215)

naming convention (3124)

nulls (3327)

PL/I (4559)

restriction on use in CREATE VIEW (3351)

restriction on use in REVOKE (4165)

search conditions (3285)

truncation (3328)

used in a program (3302)

ICCF applications, modules required (3911)

ICCF program termination (3045)

identifier

description (3111)

long (3383)

implicit

connect (3520)

connection (3732)

revocation of privileges (4171)

IN predicate (3434)

inactive

constraint (4246)

removing referential constraints (4248)

table (4247)

INCLUDE (3692), (3896)

assembler (4275)

C (4329)

COBOL (4429)

FORTRAN (4501)

PL/I (4546)

INCLUDE SQLCA

assembler language (4282)

C (4358)

COBOL (4440)

FORTRAN (4505)

PL/I (4567)

pseudocode (3019), (3936)

INCLUDE SQLDA

assembler language (4286)

C (4362)

PL/I (4572)

pseudocode (3971)

including

CICS/VSE procedures (3907)

external source members (3691), (3895)

extra linkage modules (3909)

input from Source Statement Library (3899)

relocatable modules (3906)

secondary input from VM

CMS file (3694)

inconsistency

because of cursor stability (3675), (3884)

cursor stability inconsistencies (3676), (3885)

inconsistent

data (3069)

state (3070), (3932)

index

creating (4109)

naming convention (3118)

restriction for view (3337)

indicator array

description (3308)

in assembler (4268)

in C (4338)

in COBOL (4409)

in FORTRAN (4493)

in PL/I (4556)

INDICATOR keyword

indicator variables (3330)

indicator variable

description (3304), (3329)

detecting nulls (3334)

detecting truncation (3335)

FETCH statement (3200)

in assembler (4267)

in C (4336)

in COBOL (4407)

in FORTRAN (4491)

in PL/I (4554)

meaning of values returned (3333)

initializing

SQLDA (3984)

your user machine (3516)

input host variables (3191)

INSERT

INSERT rules (4238)

rules for referential integrity (4237)

insert and fetch blocking (3685), (3892)

installing

applications (3508)

INTEGER data type

assembler (4289)

C (4366)

COBOL (4446)

data types (4580)

FORTRAN (4512)

PL/I (4579)

integrity

atomic (4199)

data (4205)

entity (4202)

referential (4208)

internal statistics, updating (4116)

INTO clause

description (3212)

dynamically defined statements (3973)

FETCH statement (3195)

restriction for subqueries (3418)

unions (3474)

invoking

PL/I preprocessor

multiple user mode (3766)

invoking the preprocessor (3527), (3748)

ISO (3665), (3874)

isolation level

cursor stability (3668), (3672), (3877), (3881)

mixing (3680), (3887)

remote unit of work (3679)

repeatable read (3669), (3671), (3878), (3880)

USER option (3600), (3681), (3834), (3888)

ISOLation preprocessor parameter (3599), (3833)

ISOLATION preprocessor parameter (3684), (3891)

job control examples

multiple user mode preprocessing (3760), (3767)

suppressing printout (3768)

join

common column names (3371)

correlated subqueries (3452)

data conversion (3369)

description (3363)

join variable (3381)

limits (3391)

nulls (3379)

number permitted (3388)

referring to another user's table (3375), (3384)

SELECT * (3393)

single table (to itself) (3380)

trailing blanks (3376)

without join conditions (3370)

KEEP parameter (3603), (3835)

keeping authorization names and password secret (3771)

key

foreign (4228)

primary (4226)

keyword

in syntax diagrams (2985)

LABEL

SQL (4129)

LABEL preprocessor parameter (3608), (3840)

limits

joins (3389)

link-editing

extra modules required (3908)

module not found (3701), (3905)

COBOL considerations (3512)

program (3698), (3902)

LOCK (4067)

ACQUIRE DBSPACE (4035)

ALTER DBSPACE (4038)

lock size

definition (4027)

locking

dbspaces

explicitly (4069)

modifying (4026)

reading (4025)

description (4045)

duration (4057)

exclusive (4054)

isolation level

considerations (3670), (3879)

share (4053)

tables explicitly (4068)

update (4055)

LOG job control statement (3773)

logical operator (3223)

logical unit of work (LUW)

automatic locking (4044)

automatic rollback (4061), (4079)

batch considerations (3050)

CICS/VSE considerations (3062), (3073), (3736)

CMS considerations (3036), (3096)

committing work done (3086)

description (3066), (3933)

error handling (3934)

ICCF considerations (3051)

revoking privileges (4167)

rolling back work done (3095)

using extended dynamic statements (4009)

LOGmode parameter

preprocessor (3651)

long character strings in FORTRAN (4495)

long strings

description (3254)

use (3255)

LONG VARCHAR

restrictions (3256)

unions (3480)

LONG VARCHAR data type

assembler (4296)

C (4373)

COBOL (4454)

FORTRAN (4519)

PL/I (4587)

LONG VARGRAPHIC

restrictions (3257)

unions (3481)

LONG VARGRAPHIC data type

assembler (4300)

C (4377)

COBOL (4458)

FORTRAN (4523)

PL/I (4591)

main variable (3305), (4266), (4335), (4406), (4490) , (4553)

manipulating a cursor (3184)

maximum

joins (3390)

merging results of queries (3470)

mixing isolation levels (3682), (3889)

modifying

locked dbspace (4024)

tables through a view (3355)

module not found (3700), (3904)

multiple

row

query results (3169)

multiple-partition mode

locking considerations (4049)

multiple row results (3167)

multiple user mode (3511)

executing applications (3714)

invoking the preprocessors (3526), (3747), (3762), (3763)

multiplication in SQL expressions (3272)

naming

column (3108)

data object (3113)

dbspace (3109)

index (3107)

table (3106)

negative SQLCODE

description (3024), (3941)

nesting correlated subqueries (3453)

NHEADER

ACQUIRE DBSPACE (4028)

NOBIND preprocessor parameter (3793)

NOBLocK preprocessor parameter (3564)

NOCHECK preprocessor parameter (3804)

NOEXIST preprocessor parameter (3587), (3821)

NOFOR preprocessor parameter (3591), (3825)

NOGRaphic preprocessor parameter (3596), (3830)

NOLOG job control statement (3772)

nonexecutable SQL statements (3027)

NOPACKAGE preprocessor parameter (3844)

NOPRint preprocessor parameter (3618), (3846)

NOPUnch preprocessor parameter (3622), (3852)

NOSEQuence preprocessor parameter (3631), (3857)

NOSQLCA

preprocessor parameter (3637)

support (3639), (3866), (3942)

NOT EXISTS predicate (3458)

not found SQLCODE (100)

FETCH (3198)

NOT IN predicate (3435)

NOT keyword

concatenation (3227)

NUL-terminated strings and truncation

C (4345)

null value (3454)

grouping queries (3403)

indicator variables (3326), (3332)

joins (3378)

search conditions (3217)

NUMERIC

See DECIMAL (3253)

OPEN

description (3189)

format (3188)

open state of a cursor (3173)

operator

arithmetic (3271)

comparison (3232)

logical (3224)

operator ID (3737)

OPTION LOG job control statement (3774)

OPTION NOLOG job control statement (3775)

optional

default parameter

in syntax diagrams (2996)

item

in syntax diagrams (2991)

keyword

in syntax diagrams (2995)

OPTIONS(MAIN) clause (4541)

OR operator (3226)

order

clauses (3411)

ORDER BY clause

description (3208)

restriction for CREATE VIEW (3349)

unions (3472), (3478)

ordering

query results (3211)

output host variables (3197)

owner

dbspace (4022)

OWner preprocessor parameter (3611)

package

automatic regeneration (3711), (3922), (4174)

description (3531), (3749)

distributing (3726), (3928)

invalidating

DROP DBSPACE (4075)

DROP VIEW (3361)

REVOKE (4173)

PACKAGE preprocessor parameter (3842)

page

header (4030)

PAGE lock size (4041)

PAGES parameter of ACQUIRE DBSPACE (4031)

parameter

marker (3964), (3991)

specifying

user (3722)

parameterized statement

description (3965)

parent table

table (4217)

parentheses

in syntax diagrams (2988)

PARMID preprocessor parameter (3653)

password

naming convention (3126)

PCTFREE

parameter of ACQUIRE dbspace (4034)

parameter of ALTER DBSPACE (4039)

PCTINDEX

parameter of ACQUIRE DBSPACE (4033)

performance

considerations (3666), (3875), (4197)

PERiod preprocessor parameter (3613)

PL/I (4578)

attributes of variables (4557)

continuation of SQL statements (4540)

data conversion considerations (4560)

declaring host variables (4550)

declaring SQLCA (4566)

declaring SQLDA (4571)

declaring static external variables (4547)

delimiting SQL statements (4543)

dynamic allocation of SQLDA (4573)

embedding SQL statements

example (3018)

placement of SQL statements (4539)

preprocessing programs coded (3765)

preprocessor parameter (3536)

sample program (4527)

stored procedures (4596)

using the INCLUDE statement (4545)

placement of SQL statements

assembler (4272)

C (4317)

COBOL (4395)

FORTRAN (4481)

PL/I (4537)

pointer type attribute

C (4340)

positions of a cursor (3179)

positive SQLCODE

description (3023), (3940)

potential deadlocks (4059)

precedence rules (3229), (3281)

predicates

constants (3286)

description (3219)

host variables (3283)

rules for evaluating (3235)

PREPARE

format (3989)

usage techniques (3966)

PrepFile preprocessor parameter (3550), (3780)

PREPNAME preprocessor parameter (3546), (3776)

PREPPARM preprocessor parameter (3552), (3782)

preprocessing

description (3530)

multiple user mode (3523), (3745)

PL/I (3764)

option file (3659), (3868)

parameters (3534)

programs (3755)

single user mode (3522), (3744)

Preprocessing

preprocessor (3532)

preprocessor parameters (3667), (3876)

APOST (3555), (3785)

ASM (3543)

BIND (3794)

BLocK (3562)

C (3545)

CCSIDGraphic (3570)

CCSIDMixed (3572), (3796)

CCSIDSbcs (3574), (3798)

CHARSUB (3576), (3800)

CHECK (3807)

COB2 (3811), (4416), (4420)

COBOL (3542), (4426)

COBRC (3813)

COMma (3614)

CTOKEN (3581), (3815)

DATE (3583), (3817)

DBFile (3656)

DBList (3658)

DBname (3648)

dcssID (3650)

ERROR (3578), (3802), (3809)

EXIST (3584), (3818)

EXPLAIN (3588), (3822)

FORTRAN (3544)

GRaphic (3595), (3829)

ISOLation (3598), (3832)

ISOLATION (3683), (3890)

KEEP (3604), (3836)

LABEL (3607), (3839)

LineCount (3609), (3841)

LOGmode (3652)

NOBIND (3792)

NOBLocK (3563)

NOCHECK (3805)

NOEXIST (3586), (3820)

NOFOR (3590), (3824)

NOGRaphic (3597), (3831)

NOPACKAGE (3845)

NOPRint (3619), (3847)

NOPUnch (3623), (3853)

NOSEQuence (3630), (3856)

NOSQLCA (3636)

OWner (3610)

PACKAGE (3843)

PARMID (3654)

PERiod (3612)

PL/I (3541)

PrepFile (3551), (3781)

PREPNAME (3547), (3777)

PREPPARM (3553), (3783)

PRint (3617), (3849)

PUnch (3621), (3851)

QUALifier (3624)

QUOTE (3554), (3784), (4412)

RELease (3626)

REVOKE (3606), (3838)

SBLocK (3566)

SEQuence (3628), (3854)

SQLApost (3632)

SQLFLAG (3860)

SQLQuote (3634)

STDSQL (3638), (3865)

suppressing display (3770)

sysIN (3641)

SYSIN (3859)

sysPRint (3644)

sysPUnch (3646)

TIME (3640), (3867)

USERid (3549), (3779)

preprocessorparameters

DYNALC (3593), (3827)

primary key (4227)

PRint preprocessor parameter (3616), (3848)

privilege

automatic revocation (4169)

description (4147)

package (4175)

programs (4177)

references (4233)

revoking (4178)

from others (4161)

table or view

alter (4153)

delete (4151)

description (4148)

index (4154)

insert (4150)

references (4155)

select (4149)

update (4152)

program

interrupts

FORTRAN (4506)

PL/I (4568)

naming convention (3121)

privileges

revoking (4179)

sample (3099)

termination

batch applications (3040)

program termination

CICS/VSE programs (3059)

CMS programs (3033)

ICCF applications (3041)

programming interface

description (4597)

programs using DBCS data

assembler (4278)

C (4350)

COBOL (4434)

FORTRAN (4498)

PL/I (4562)

PSERVERs

characteristics (4135)

example of a definition (4136)

execution (4134)

pseudocode

description (3006)

PUnch preprocessor parameter (3620), (3850)

punctuation mark

in syntax diagrams (2987)

PUT

description (3203)

format (3202)

QUALifier preprocessor parameter (3625)

qualifiers

column names (3374)

table names (3129)

qualify

fully (3130)

Query

Connected Database (3296)

querying

tables through a view (3352)

quotation mark

considerations in COBOL (3560), (3790)

constants (3309)

QUOTE preprocessor parameter (3556), (3786), (4411)

reading from a locked dbspace (4023)

REBIND PACKAGE (3712), (3923)

reentrant programs

assembler (4304), (4381)

C (4382)

COBOL (4462), (4463)

REFER feature of PL/I (4575)

references privilege (4234)

existing applications (4235)

modifying the contents of tables with referential constraints (4236)

referential

constraint (4212)

cycle

definition (4214)

description (4210)

integrity (4209)

existing tables (4231)

rules (4243)

structure (4215)

support (3925)

relationship (4211)

RELEASE option

COMMIT (3056)

ROLLBACK (3057)

RELease preprocessor parameter (3627)

releasing your connection

batch applications (3048)

CICS/VSE applications (3064)

CMS applications (3087)

ICCF applications (3049)

to DB2 Server for VSE & VM (3089)

remote unit of work

application program (3002)

blocking (3568), (3688)

considerations in using extended dynamic statements (4012)

CURRENT SERVER (3297)

extended dynamic processing (4003), (4004)

isolation level (3678)

special register (3294)

USER isolation (3601)

repeat symbol

in syntax diagrams (2993)

repeatable read locking (3673), (3882)

required item

in syntax diagrams (2990)

reserved words

SQL (2998)

RESOURCE authority

granting (4143)

Resource Definition Online Facility (RDO) (3082)

restoring data (3093)

restriction

unions (3475)

result table

cursor (3171)

retrieving

columns of a row (3147)

REVOKE (4160)

REVOKE preprocessor parameter (3605), (3837)

revoking

privileges (4166)

automatic (4168)

overview (4164)

programs (4176)

rollback

description (3935)

ROLLBACK (3055), (3091)

rollback, automatic

data definition statements (4078)

deadlocks (4064)

ROLLBACK WORK (4060)

rolling back changes (3094)

ROW lock size (4043)

rules

evaluating predicates (3233)

naming data object (3114)

SQL in assembler (4261)

SQL in C (4316)

SQL in FORTRAN (4480)

SQL in PL/I (4536)

sample program

ARIS6ASD (4254)

ARIS6CBC (4392)

ARIS6CBD (4388)

ARIS6CC (4313)

ARIS6CD (4309)

ARIS6FTC (4476)

ARIS6FTD (4470)

ARIS6PLC (4533)

ARIS6PLD (4529)

EXECs (3102)

list (3098)

SBLocK preprocessor parameter (3567)

SCHEDULE authority

granting (4144)

scope

cursor (3186)

WHENEVER statement (3952)

search condition

AND operator (3220)

arithmetic operators (3270)

comparison operators (3230)

constant (3287)

description (3216)

expressions (3291)

host variables (3282)

join conditions (3366)

NOT keyword (3222)

OR operator (3221)

precedence rules (3228), (3280)

predicates (3218)

SELECT

ALL (3143)

ALL keyword (3423)

ANY keyword (3422)

clause (3138)

constants (3149)

correlation (3439)

DISTINCT keyword (3141)

error handling (3958)

EXISTS (3459)

group-by-clause (3160)

grouping (3395)

having-clause (3162)

INTO clause (3213)

introduction (3133)

joins (3364)

NOT EXISTS predicate (3460)

order of clauses (3408)

ordering results (3210)

SELECT * form (3148)

select-clause (3137)

select-list (3140)

subqueries (3414)

unions (3468)

where-clause (3156)

SELECT *

basic queries (3145)

join (3392)

views (3347)

select list

constants (3150)

description (3139)

error handling (3960)

restrictions

GROUP BY (3404)

select-statement

description (3136)

selecting

all columns of a row (3146)

isolation level (3677), (3886)

self-referencing table (4225)

sequence of clauses (3409)

SEQuence preprocessor parameter (3629), (3855)

share lock

description (4052), (4071)

shift-in character (3268)

shift-out character (3267)

single-partition mode

locking considerations (4050)

single precision float (3252)

single quotation mark

COBOL considerations (3559), (3789), (4414)

considerations in COBOL (3558), (3788)

constant (3310)

single-row query results (3214)

single user mode (3509)

executing applications (3716)

invoking a program

example (3720)

invoking the preprocessors (3525), (3746)

specifying user parameters (3721)

single virtual machine mode (3510)

SIZE=AUTO

invoking preprocessors (3761)

SMALLINT data type

assembler (4290)

C (4367)

COBOL (4447)

FORTRAN (4513)

PL/I (4581)

SOME keyword (3429)

source code

ARIS6ASC (4256)

ARIS6ASD (4253)

ARIS6CBC (4393)

ARIS6CBD (4389)

ARIS6CC (4314)

ARIS6CD (4310)

ARIS6FTC (4477)

ARIS6FTD (4471)

ARIS6PLC (4534)

ARIS6PLD (4530)

Source Statement Library

input (3898)

source value (3263)

special register

description (3290)

expressions (3293)

remote unit of work (3295)

special statements

UPDATE STATISTICS (4114)

SQL-89

conformance checking (3661), (3864), (3870), (4013)

SQL comments

assembler (4274)

C (4323)

COBOL (4401)

FORTRAN (4485)

in static SQL statements (3490)

PL/I (4544)

SQL declare section (3007), (3303), (3307), (4265), (4334) , (4405), (4489), (4552)

SQL Descriptor Area (SQLDA)

assembler declaration (4285)

C declaration (4360)

COBOL declaration (4443)

FORTRAN declaration (4508)

PL/I declaration (4570)

Structure (3981)

SQL identifier

description (3112)

SQL statements

embedding in application program

examples (3026)

SQLApost preprocessor parameter (3633)

SQLCA (SQL Communications Area)

assembler declaration (4280)

C declaration (4356)

COBOL (4438)

description (3945)

FORTRAN (4504)

PL/I declaration (4565)

testing (3955)

SQLCODE (3021), (3938)

SQLCODE 100 (not found)

FETCH (3199)

SQLD field in the SQLDA (3987)

SQLDA (SQL Descriptor Area)

summary (3982)

SQLDAX structure (in PL/I) (4574)

SQLDSECT, acquiring (4258)

SQLDSIZ variable (4260)

SQLERRM

description (3946)

SQLFLAG preprocessor parameter (3861)

SQLHX (3038)

SQLINIT EXEC (3518)

optional CMS work unit (4196)

SQLN

field in SQLDA (3986)

setting (3985)

SQLPREP EXEC (3528)

format (3533)

parameters (3535)

SQLQRY

remote unit of work (4249)

SQLQuote preprocessor parameter (3635)

SQLRMEND EXEC (3037)

SQLSTART EXEC (3717)

example (3719)

SQLWARN

description (3949)

SQLWARN6

automatic rollback (4065)

starter database (3727)

statements

ALTER TABLE (4095)

BEGIN DECLARE SECTION (3008)

CLOSE (3207)

COMMENT ON (4125)

COMMIT (3084)

CONNECT (3030)

CREATE INDEX (4106)

CREATE SYNONYM (4118)

CREATE TABLE (4080)

CREATE VIEW (3338)

DECLARE (3182)

DROP DBSPACE (4072)

DROP SYNONYM (4119)

DROP TABLE (4100)

DROP VIEW (3357)

END DECLARE SECTION (3009)

FETCH (3196)

INCLUDE (3693), (3897)

INCLUDE SQLCA (3020), (3937)

INCLUDE SQLDA (3972)

LABEL (4128)

LOCK (4066)

naming convention (3123)

OPEN (3190)

PREPARE (3988)

PUT (3204)

REVOKE (4159)

ROLLBACK (3090)

SELECT

basic use (3132)

correlation (3440)

grouping (3394)

joins (3362)

subqueries (3415)

testing for existence (3455)

unions (3464)

UPDATE STATISTICS (4112)

WHENEVER (3950)

static SQL

description (3103)

statistics

tables (4117)

storage pool

definition (4017)

nonrecoverable (4019)

recoverable (4018)

specifying the placement of dbspaces (4037)

stored procedures

assembler (4306)

authorizing (3498)

benefits (3492)

C (4384)

calling (3497)

characteristics (4132)

client application programs (3507)

COBOL (4466)

coding examples (3505)

datatype compatibility (3501)

example of a definition (4133)

execution of SQL statements (3494)

GENERAL linkage convention (3503)

GENERAL WITH NULLS linkage convention (3504)

Language Environment considerations (3495)

parameters (3500)

passing parameters (3502)

PL/I (4595)

preparing (3496)

result sets (3506)

specifying AUTHIDs (3499)

using (3491), (4131)

writing (3493)

STORPOOL parameter of ACQUIRE DBSPACE (4036)

structures

based (3970)

subquery

ALL keyword (3427)

ANY keyword (3421)

correlation (3442)

IN predicate (3430)

introduction (3413)

involving unions (restriction) (3484)

many values returned (3420)

NOT IN predicate (3431)

single value returned (3419)

subselect

description (3134)

subtraction in SQL expressions (3279)

subtype

character (3259)

Using (3313)

summary

program framework (3097)

suppressing SYSPCH and SYSLST output (3756)

suppressing the preprocessor parameter display (3769)

syncpoints (3065)

synonym

creating (4124)

naming convention (3119)

syntax diagram

notation conventions (2983)

sysIN preprocessor parameter (3642)

SYSIN preprocessor parameter (3858)

SYSLST, suppressing preprocessor output (3757)

SYSPCH, suppressing preprocessor output (3758)

sysPRint preprocessor parameter (3643)

sysPUnch preprocessor parameter (3645)

system initialization table (3077)

Systems Application Architecture (SAA)

conformance checking (3662), (3863), (3871), (4014)

table

accessing (3154)

altering (4099)

creating (4082)

indexes (4111)

synonyms (4123)

defining labels (4130)

delete-connected (4220)

dependent (4218)

descendent (4222)

designator

rules (3385), (3463)

dropping (4105)

entering comments in catalog tables (4127)

exposed table name (3386)

labels (3382)

naming convention (3115)

nonexposed table name (3387)

or view

privileges (4157)

parent table (4216)

self-referencing (4224)

tables, CICS/VS (3076)

target value (3264)

terminal operator id (3738)

terminating

CMS applications (3035)

termination

batch programs (3042)

CICS/VSE programs (3060)

ICCF applications (3043)

testing

existence (3456)

SQLCA (3954)

TIME data type

assembler (4302)

C (4379)

COBOL (4460)

FORTRAN (4525)

PL/I (4593)

TIMESTAMP

data type

assembler (4303)

C (4380)

COBOL (4461)

FORTRAN (4526)

PL/I (4594)

duration (4186)

trailing blanks (3377), (3402)

trigraphs

C (4349)

UNION ALL (3471)

UNION operator

CCSID (3489)

character subtypes (3488)

description (3465)

ordering results (3473), (3479)

restriction for CREATE VIEW (3350)

usage restrictions involving

data types (3476)

LONG VARCHAR data (3482)

subqueries (3483)

VARCHAR and VARGRAPHIC (3487)

views (3485)

unions (3466) See also UNION operator

See UNION operator (3467)

unique on columns (4206)

uniquely identifying an object (3131)

unresolved external reference (3708), (3920)

UPDATE

rules (4239)

update rule (4240)

UPDATE STATISTICS (4113)

updating

internal statistics (4115)

user ID

CICS/VSE default rules (3734)

CICSUSER default (3741)

naming convention (3125)

USER isolation

remote unit of work (3602)

user parameters

in single user mode (3723)

USER special register (3298)

USERid

preprocessor parameter (3778)

USERid preprocessor parameter (3548)

valid lock size (4040)

VARCHAR data type

assembler (4295)

C (4372)

COBOL (4453)

FORTRAN (4518)

PL/I (4586)

VARGRAPHIC

constants within expressions (3318)

data type

assembler (4299)

C (4376)

COBOL (4457)

FORTRAN (4522)

PL/I (4590)

view

CREATE VIEW (3340)

description (3336)

DROP VIEW (3359)

materialization (3354)

modifying tables through (3356)

naming convention (3116)

privileges (4156)

querying tables through (3353)

unions

restriction (3486)

virtual

columns (3342)

data (3344)

VM (3697)

executing applications (3709)

implicit connect (3519)

loading a program (3699), (3903)

preprocessing programs (3524)

VM/CMS file

including secondary input (3695)

VSE

CICS/VSE CONNECT considerations (3730)

compiling a program (3901)

preprocessing programs (3754)

warning

conditions (3947)

flags (3948)

WHENEVER (3025), (3943), (3951)

WHERE clause

ALL keyword (3425)

ANY keyword (3424)

correlated subquery (3443)

description (3155)

EXISTS predicate (3461)

grouping considerations (3405)

IN predicate (3432)

join conditions (3367)

NOT EXISTS predicate (3462)

NOT IN predicate (3433)

subqueries (3416)

WITH CHECK OPTION (3346)

WITH clause (3166)

work units

CMS (4191)

using (4192)

writing clauses in order (3410)

zero SQLCODE

description (3022), (3939)

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