DB2 Server for VSE & VM: SQL Reference

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 Y

Special Characters

!! (concatenate) operator (6213)

|| (concatenate) operator (6212)

^= (not equal to) operator (6391)

+ (add) operator (6217), (6219)

* (asterisk)

in subselect (6566)

: (colon) (6195) See also host variable

/ (divide) operator (6215)

= (equal to) operator

in predicate (6371), (6389)

in UPDATE statement (7853)

* (multiply) operator (6216)

? (question mark) (7275) See also parameter marker

- (subtract) operator (6218)

>= (greater than or equal to) operator (6376), (6395)

> (greater than) operator (6375), (6394)

> shift-in character (5611)

integrity

referential (5675)

<= (less than or equal to) operator (6377), (6396)

< (less than) operator (6374), (6393)

<> (not equal to) operator (6373), (6392)

< shift-out character (5608)

¬= (not equal to) operator (6372), (6390)

access privilege (5828)

ACQUIRE DBSPACE statement

description (6663)

EXECUTE IMMEDIATE statement (7312)

PREPARE statement (7656)

ACTIVATE ALL clause

of ALTER TABLE statement (6757)

ACTIVATE FOREIGN KEY clause

of ALTER TABLE statement (6759)

ACTIVATE PRIMARY KEY clause

of ALTER TABLE statement (6758)

ACTIVATE UNIQUE clause

of ALTER TABLE statement (6760)

activating and deactivating keys (5715)

active set

DECLARE CURSOR statement (7061)

description (5645)

ACTIVITY sample table (8568)

ADD clause

of ALTER TABLE statement (6709)

administration

authority (5823)

ALL

clause of EXPLAIN statement (7350)

clause of subselect (6562)

clause of UPDATE STATISTICS statement (7896), (7903)

in a quantified predicate (6387)

keyword

AVG function (6460)

column function (6456)

MAX function (6471)

MIN function (6475)

SUM function (6479)

ALL clause

of GRANT statement (7440)

of REVOKE statement (7779)

ALL PRIVILEGES clause

of GRANT statement (7441), (7457)

of REVOKE statement (7780), (7794)

ALLOCATE CURSOR statement

description (6682), (6685)

ALLUSERS

in CONNECT clause of GRANT statement (7423), (7429)

in CONNECT clause of REVOKE statement (7764), (7768)

alphabetic extender

basic symbol (5836)

ALTER clause

of GRANT statement (7442), (7458)

of REVOKE statement (7781), (7795)

ALTER DBSPACE statement

description (6687)

EXECUTE IMMEDIATE statement (7313)

PREPARE statement (7657)

ALTER privilege

in ALTER TABLE statement (6707)

ALTER PROCEDURE statement

description (6697)

EXECUTE IMMEDIATE statement (7314)

ALTER PSERVER statement

description (6701), (6948), (7240), (7243)

EXECUTE IMMEDIATE statement (7315)

ALTER TABLE statement

description (6704)

EXECUTE IMMEDIATE statement (7316)

GRANT statement (7459), (7467)

PREPARE statement (7658)

ALTERAUTH column (8218)

of SYSTABAUTH (8526)

ALTNAME column (8207)

of SYSSYNONYMS (8506)

ambiguous reference

column name (6180)

AND

in a search condition (6435)

truth table (6445)

ANY

in a quantified predicate (6386)

in USING clause

of DESCRIBE statement (7142)

of Extended DESCRIBE statement (7178)

application

default CCSID in server and requester (5812)

process (5736)

requester (5775)

server (5776)

application program

embedding statements (6630)

applying the select list (6570)

arithmetic

date (6337)

datetime (6336)

decimal (6294)

floating-point (6305)

integer (6278)

operators (6268)

time (6340)

timestamp (6343)

arithmetic expression

ISO-ANS SQL(89) equivalent term (8605)

arithmetic operator

in syntax diagrams (5594)

AS clause

of CREATE VIEW statement (7040)

ASC clause

of ALTER TABLE statement (6737), (6751)

of CREATE INDEX statement (6888)

of CREATE TABLE statement (7008), (7022)

select-statement (6612)

ASCII

mixed data (5952)

assembler

application program

BEGIN DECLARE SECTION statement (6781)

host variable (6193), (7305), (7306)

INCLUDE SQLCA (8009), (8073)

INCLUDE SQLDA (8025)

INCLUDE statement (7490)

PREPARE statement (7650)

SQLCA (7978)

varying-length string variables (5929)

assignment

datetime

DATE (6091)

TIME (6093)

TIMESTAMP (6099)

numbers (6050), (6068)

operation rules (6030)

strings

bit (6082)

mixed (6085)

SBCS (6083)

SQLCA (6081)

SQLWARN1 (6080), (6086)

truncation (6084)

ASSOCIATE LOCATORS statement

description (6772), (6775)

asterisk

in COUNT function (6467)

in subselect (6565)

atomic integrity (5661)

attribute

CCSID (5809)

length

column (5915)

host variable (6366)

AUTHOR column (8228)

of SYSUSERAUTH and SYSUSERLIST (8550)

authority

administration (5824)

connect (5820)

DBA (5825)

GRANT statement (7418)

resource (5822)

authorization

description (5818)

authorization id

description (5898)

authorization_name

description (5872)

in CONNECT statement (6855), (6867)

in GRANT statement (7406), (7410), (7419), (7428), (7454) , (7476)

in REVOKE statement (7750), (7755), (7762), (7772), (7792)

length limitation (7937)

AVG function (6457)

precision (6461)

scale (6462)

AVGCOLLEN column (8143)

of SYSCOLUMNS (8348)

AVGROWLEN column (8103)

of SYSCATALOG (8276)

base table (5643)

basic predicate (6367)

description (6378)

ISO-ANS SQL(89) equivalent term (8606)

BCREATOR column (8222)

of SYSUSAGE (8535)

BEGIN DECLARE SECTION statement (6777), (6787)

BETWEEN predicate

description (6398)

NOT keyword (6399)

BINDERROR column (8099)

binding statements (5620)

bit data

CREATE TABLE statement (7002)

description (5937)

SQLDA (8049)

blank

DBCS (6075)

SBCS (6074)

BLOCK option

of CREATE PACKAGE statement (6923)

blocking

CLOSE statement (6795)

cursor (7710)

DELETE statement (7131)

description (7132)

long string restriction (5923)

OPEN statement (7602)

BNAME column (8221)

of SYSUSAGE (8534)

BOTH

in USING clause

of DESCRIBE statement (7143)

of Extended DESCRIBE statement (7177)

BTYPE column (8223)

of SYSUSAGE (8536)

built-in function (6451)

application program

BEGIN DECLARE SECTION statement (6782)

host structure (6205)

host variable (6189), (7307)

INCLUDE SQLCA (8012)

INCLUDE SQLDA (8075)

INCLUDE statement (7491)

PREPARE statement (7651)

SQLCA (7981)

SQLDA (8027)

varying-length string variables (5930)

CALL statement

description (6788)

cascade

delete rule (5700)

DELETE statement (7125)

ON DELETE clause

of ALTER TABLE statement (6746)

of CREATE TABLE statement (7017)

catalog

description (5733)

catalog tables (8078)

DB2 Server for VSE & VM database manager (8079)

description (5734)

owner of (SYSTEM) (8242)

roadmap (8248)

SYSACCESS (8250), (8263)

SYSCATALOG (8265), (8289)

SYSCCSIDS (8291), (8298)

SYSCHARSETS (8300), (8305)

SYSCOLAUTH (8307), (8315)

SYSCOLSTATS (8317), (8329)

SYSCOLUMNS (8331), (8356)

SYSDBSPACES (8358), (8372)

SYSDROP (8374), (8379)

SYSFIELDS (8381), (8393)

SYSFPARMS (8395), (8403)

SYSINDEXES (8405), (8427)

SYSKEYCOLS (8429), (8443)

SYSKEYS (8445), (8458)

SYSLANGUAGE (8460), (8466)

SYSOPTIONS (8468), (8474)

SYSPARMS (8476)

SYSPROGAUTH (8478), (8486)

SYSPSERVERS (8488)

SYSROUTINES (8490)

SYSSTRINGS (8492), (8502)

SYSSYNONYMS (8504), (8510)

SYSTABAUTH (8512), (8531)

SYSUSAGE (8533), (8542)

SYSUSERAUTH and SYSUSERLIST (8544), (8556)

SYSUSERLIST view (8546)

SYSVIEWS (8558), (8566)

CCSID (5808), (6002) See also coded character set identifier (CCSID), coded character set identifier (CCSID)

CCSID column (8115)

of SYSCCSIDS (8292)

of SYSCOLUMNS (8353)

of SYSKEYCOLS (8441)

CCSID keyword

of CREATE TABLE statement (7004)

CCSIDGRAPHIC option

of CREATE PACKAGE statement (6902)

CCSIDMIXED option

of CREATE PACKAGE statement (6901)

CCSIDSBCS option

of CREATE PACKAGE statement (6900)

CDRA (5806) See also character data representation architecture (CDRA)

char (5614)

data type (5905), (6985)

function

EUR (6487)

ISO (6485)

JIS (6488)

LOCAL (6489)

USA (6486)

CHAR

character (5831)

data type (6718)

subtype

default (5943)

CHARACTER

character_constant

in LIKE predicate (6421)

character conversion

character set (5794)

code page (5796)

code point (5798)

coded character set (5800)

description (6605)

DRDA (5791)

encoding scheme (5801)

rules for comparison (6118)

rules for operations combining strings (6604)

substitution character (5803)

character data representation architecture (CDRA) (5805)

character set (5795)

character string

assignment (6069)

bit data (5936)

comparison (6115)

constant (6132)

description (5906)

empty (5909)

fixed-length (5912)

host variable (5925)

MBCS (5941)

mixed data (5940)

planes (5957)

SBCS data (5938)

varying-length (5919)

character subtype

description (5935)

SQLDA (8052)

CHARCLASS column (8122)

of SYSCHARSETS (8302)

CHARNAME column (8119)

of SYSCCSIDS (8296)

CHARSUB option

of CREATE PACKAGE statement (6903)

CHARTRANS column (8123)

of SYSCHARSETS (8303)

CHECK option

of CREATE PACKAGE statement (6926)

choose

in syntax diagrams (5597)

CICS

GRANT statement (7434)

CL_SCHED sample table (8570)

CLABEL column (8145)

LABEL ON statement (7550)

of SYSCOLUMNS (8350)

CLOSE statement

description (6791)

CLOSE statement, Extended (6801), (6808)

closed state of cursor (7615)

CLUSTER column (8169)

of SYSINDEXES (8412)

CLUSTERRATIO column (8179)

of SYSINDEXES (8413), (8423)

CLUSTERROW column (8102)

of SYSCATALOG (8275)

CLUSTERTYPE column (8101)

of SYSCATALOG (8274)

CNAME column (8134)

of SYSCOLSTATS (8318)

of SYSCOLUMNS (8332)

of SYSFIELDS (8385)

of SYSFPARMS (8399)

of SYSKEYCOLS (8434)

COBOL

application program

BEGIN DECLARE SECTION statement (6783)

host structure (6206)

host variable (6188), (7308)

INCLUDE SQLCA (8015)

INCLUDE statement (7492)

integers (6066)

PREPARE statement (7652)

SQLCA (7979)

varying-length string variables (5931)

code page (5797)

code point (5799)

coded character set identifier (CCSID)

constants (6143)

conversion selection table (5810)

default (5811)

default override (8056)

description (5807)

graphic constants (6147)

maximum number of overrides (7975)

string representation of datetime values (6001)

SYSOPTIONS catalog table (8469)

COLCOUNT column (8140)

of SYSCOLUMNS (8345)

COLINFO column (8146)

of SYSCOLUMNS (8351)

collection_id

description (5873)

COLNAME column (8126)

of SYSCOLAUTH (8313)

COLNAMES column (8167)

of SYSINDEXES (8410)

COLNO column (8135)

of SYSCOLUMNS (8335)

of SYSFIELDS (8384)

COLNUMBERS column (8171)

of SYSINDEXES (8415)

colon (6194) See also host variable

COLTYPE column (8136)

of SYSCOLUMNS (8336)

column

grouping (6589)

in tables (5641)

length attribute (5913)

long string (5921)

maximum number in a table (7949)

maximum number in a view (7950)

maximum number in an index key (7956)

name

of a result column (6576)

qualifier (6164)

rules for UNION (6603)

short string (5917)

unnamed (6608)

COLUMN clause

of COMMENT ON statement (6818)

of LABEL ON statement (7542), (7549)

column function (6452), (6453) See also function

ISO-ANS SQL(89) equivalent term (8607)

column in a GROUP BY clause

ISO-ANS SQL(89) equivalent term (8608)

column name

ambiguous reference (6179)

undefined reference (6181)

column_name

description (5874), (6823)

in ALTER TABLE statement (6730), (6750)

in COMMENT ON PROCEDURE statement (6831)

in COMMENT ON statement (6815)

in CREATE INDEX statement (6880), (6887)

in CREATE TABLE statement (7021)

in CREATE VIEW statement (7038), (7039)

in FOR UPDATE clause (6614)

in GRANT statement (7449), (7471)

in GROUP BY clause (6587)

in INSERT statement (7505), (7517)

in LABEL ON statement (7544)

in LIKE predicate (6418)

in NULL predicate (6433)

in ORDER BY clause (6610)

in UPDATE statement (7858), (7869)

length limitation (7944)

column name qualification

correlation name (6165)

synonym (6166)

table name (6167)

view name (6168)

COMMENT ON PROCEDURE statement

description (6825)

COMMENT ON statement

column name qualification (6169)

description (6809)

EXECUTE IMMEDIATE statement (7317)

PREPARE statement (7659)

comments

host language (5847)

in catalog (6811), (6827)

in static SQL statements (5846), (6662)

commit (5740)

COMMIT statement

description (6837)

communication protocol

DRDA (5784)

SQLDS (5782)

comparison

compatibility rules (6047)

datetime values (6119)

numbers (6103)

operation (6037)

predicate

DB2 Server for VSE & VM equivalent term (8587)

predicate subquery

DB2 Server for VSE & VM equivalent term (8588)

strings (6116)

comparison operator

in a basic predicate (6370)

in a quantified predicate (6388)

compatibility

data type (6044)

rules (6046)

composite key (5649)

CONCAT operator (6214)

concatenation

field procedure (6265)

operator (6259)

shift-in character (6263)

shift-out character (6264)

concurrency

LOCK DBSPACE statement (7564)

LOCK TABLE statement (7577)

connect

authority (5819)

CONNECT (for VM) statement (6851), (6862)

CONNECT (for VSE) statement (6864), (6874)

CONNECT clause

of GRANT statement (7425)

of REVOKE statement (7763), (7769)

connection states (6861), (6873)

consistency

points of (5744)

constant

character string (6133)

character subtypes

DBCS option (6140)

mixed (6141)

SBCS (6142)

decimal (6130)

description (6124)

floating-point (6128)

graphic string (6144)

hexadecimal (6136), (6138)

in IN predicate (6407)

in INSERT statement (7507)

integer (6126)

CONSTKN column (8089)

of SYSACCESS (8260)

constraint_name

description (5875)

in ALTER TABLE statement (6731), (6741), (6749)

in CREATE TABLE statement (6968), (7012), (7020)

length limitation (7938)

CONTINUE clause

of WHENEVER statement (7917), (7930)

conventions

mixed data representation (5605)

syntax diagram notation (5589)

conversion

character (5792)

numbers

for assignments (6059)

for comparisons (6107)

scale and precision (6060), (6108)

correlated reference

description (6186)

FROM clause (6185), (6585)

ISO-ANS SQL(89) equivalent term (8609)

correlation name

defining (6174)

qualifying a column name (6172)

correlation_name

description (5876)

in DELETE statement (7106), (7115)

in FROM clause (6579)

in subselect (6560)

in UPDATE statement (7856), (7867)

length limitation (7939)

COST clause

of EXPLAIN statement (7346)

COST_TABLE

EXPLAIN statement (7355)

COUNT function (6463)

asterisk (*) (6465)

create index

privilege (5830)

CREATE INDEX statement

description (6876)

EXECUTE IMMEDIATE statement (7318)

GRANT statement (7463)

PREPARE statement (7660)

CREATE PACKAGE statement

description (6894)

DROP STATEMENT statement (7252)

CREATE PROCEDURE statement

description (6945)

EXECUTE IMMEDIATE statement (7320)

CREATE PSERVER statement

EXECUTE IMMEDIATE statement (7321)

CREATE SYNONYM statement

description (6951)

EXECUTE IMMEDIATE statement (7319)

PREPARE statement (7661)

CREATE TABLE statement

description (6961)

EXECUTE IMMEDIATE statement (7322)

PREPARE statement (7662)

CREATE VIEW statement

description (7033)

EXECUTE IMMEDIATE statement (7323)

PREPARE statement (7663)

creation, package (5633)

CREATOR column (8081)

of SYSACCESS (8252)

of SYSCATALOG (8267)

of SYSCOLAUTH (8310)

of SYSCOLSTATS (8320)

of SYSCOLUMNS (8334)

of SYSFIELDS (8382)

of SYSFPARMS (8397)

of SYSINDEXES (8409)

of SYSPROGAUTH (8481)

of SYSSYNONYMS (8507)

CS attribute

isolation level (5759)

isolation option

CREATE PACKAGE statement (6914)

CURRENT DATE special register (6152)

CURRENT SERVER special register (6154)

CURRENT TIME special register (6156)

CURRENT TIMESTAMP special register (6158)

CURRENT TIMEZONE special register (6160)

cursor See also DECLARE CURSOR statement

blocking (7709)

closed state (7614)

closed upon error

DELETE statement (7126)

FETCH statement (7381)

UPDATE statement (7877)

closing (6793), (6802)

COMMIT statement (6847)

current row (7380)

defining (7050)

Extended DECLARE CURSOR statement (7078)

Extended FETCH statement (7391)

Extended OPEN statement (7628)

Extended PUT statement (7734)

insert (7052), (7597)

maximum declared in a program (7972)

maximum number opened at one time (7973)

moving position (7363)

opening (7587), (7629)

positions when open (7379)

query (7051), (7596)

result table (7060)

ROLLBACK statement (7823)

CURSOR FOR clause

of Extended DECLARE CURSOR statement (7081)

cursor_name

description (5877)

in CLOSE statement (6794)

in DECLARE CURSOR statement (7056), (7059)

in DELETE statement (7108), (7122)

in Extended DECLARE CURSOR statement (7088)

in FETCH statement (7364)

in OPEN statement (7589), (7600)

in PUT statement (7711)

in UPDATE statement (7863), (7875)

length limitation (7940)

cursor-name (6684), (7186)

cursor stability

isolation level (5761)

cursor_variable

description (5878)

in Extended CLOSE statement (6803)

in Extended DECLARE CURSOR statement (7080), (7085)

in Extended FETCH statement (7392)

in Extended OPEN statement (7630)

in Extended PUT statement (7735)

DATA CAPTURE clause

of ALTER TABLE statement (6765)

of CREATE TABLE statement (7029)

data conversion

DRDA (5788)

data integrity (5667), (5669), (5738)

data type

character string (5907)

compatibility (6045)

date (5985)

datetime (5983)

DBAHW (8246), (8339)

DBAINT (8247), (8340)

description (5900), (6975)

graphic string (5961)

numeric (5966)

of result columns (6578)

result set locator (5903)

time (5990)

timestamp (5995)

database

COMMIT statement (6845)

CONNECT statement (6854), (6866)

ROLLBACK statement (7821)

database interface routine (5636)

DATACODE column (8185)

of SYSKEYCOLS (8437)

date (5988)

arithmetic operations

duration (6338)

assignment (6092)

data type (6724), (6991)

description (5986)

duration

description (6318)

function (6492)

representation, internal & SQLDA (5989)

string (6004)

DATE

DATE option

of CREATE PACKAGE statement (6904)

datetime

arithmetic operations (6335), (6344)

assignment

EUR (6097)

ISO (6096)

JIS (6098)

microseconds (6101)

USA (6095)

comparison

DATE (6120)

TIME (6121)

TIMESTAMP (6122)

data type

description (5984)

string representation (6000), (6003)

format

EUR (6005)

ISO (6006)

JIS (6007)

LOCAL (6008)

USA (6009)

using CHAR function (6490)

operand (6308)

DAY

function (6494)

labeled duration (6228)

DAYS

function (6496)

labeled duration (6229)

DB2 Server for VSE & VM / ISO-ANS SQL(89) equivalent terms (8585), (8622)

DBA authority

ACQUIRE DBSPACE statement (6665)

activating keys (5719)

CREATE TABLE statement (6964)

deactivating keys (5720)

description (5826)

DROP statement (7214), (7221)

Extended PREPARE statement (7703)

of GRANT statement (7426)

REVOKE statement (7761)

SYSTABAUTH catalog table (8529)

SYSUSERAUTH catalog table (8548)

DBA clause

of REVOKE statement (7770)

DBAAUTH column (8230)

of SYSUSERAUTH and SYSUSERLIST (8552)

DBAHW

catalog (8244)

SYSCOLUMNS catalog table (8337)

DBAINT

catalog (8245)

SYSCOLUMNS catalog table (8338)

DBCS (5960) See also double-byte character set (DBCS)

character (5613)

option (5870), (5949)

DBCSID column (8118)

of SYSCCSIDS (8295)

DBNAME directory

CONNECT statement (6872)

DBSPACE clause

description (7910)

of DROP statement (7210), (7212)

of UPDATE STATISTICS statement (7902), (7909)

dbspace_name

description (5879)

in CREATE TABLE statement (7025)

in DROP statement (7204), (7213)

in LOCK DBSPACE statement (7562)

in UPDATE STATISTICS statement (7901), (7908)

dbspace-name

in ACQUIRE DBSPACE statement (6667)

in ALTER DBSPACE statement (6688)

in ALTER PROCEDURE statement (6698)

in CREATE TABLE statement (6967)

DBSPACE value for LOCK clause

of ACQUIRE DBSPACE statement (6676)

of ALTER DBSPACE statement (6692)

DBSPACENAME column (8100)

of SYSCATALOG (8272)

of SYSDBSPACES (8359)

DBSPACENO column (8082)

of SYSACCESS (8253)

of SYSCATALOG (8271)

of SYSDBSPACES (8360)

of SYSDROP (8375)

DBSPACETYPE column (8150)

of SYSDBSPACES (8362)

DCREATOR column (8225)

of SYSUSAGE (8538)

DEACTIVATE ALL clause

of ALTER TABLE statement (6761)

DEACTIVATE FOREIGN KEY clause

of ALTER TABLE statement (6763)

DEACTIVATE PRIMARY KEY clause

of ALTER TABLE statement (6762)

deactivate referential constraint (5687)

DEACTIVATE UNIQUE clause

of ALTER TABLE statement (6764)

DEC (6982) See also DECIMAL

decimal

arithmetic

addition (6295)

division (6298)

multiplication (6297)

precision (6299)

scale (6300)

SQLCODE of the SQLCA (6301)

subtraction (6296)

constant (6131)

data type (5978)

data type (6716), (6983)

function (6498)

precision (6499)

scale (6500)

numbers (5977)

operands (6285)

precision (5970), (6286)

scale (6287)

DECIMAL

declarations

inserting into a program (7483)

DECLARE CURSOR statement (7049)

description (7047)

dynamic select (6656)

OPEN statement (7606)

PREPARE statement (7679)

select-statement invocation (6627)

static select (6650)

DECLARE CURSOR statement, Extended (7077), (7095)

default

in syntax diagrams (5599)

degree

of cursor

DB2 Server for VSE & VM equivalent term (8590)

of table

DB2 Server for VSE & VM equivalent term (8589)

delete

on view (5729)

DELETE clause

of GRANT statement (7443), (7460)

of REVOKE statement (7782), (7796)

delete-connected

definition (5704)

through multiple paths (5705)

delete rule

cascade (5699)

description (5693)

of referential constraint (5694)

restrict (5696)

restrictions (5709)

set null (5702)

DELETE statement

description (7096), (7623)

EXECUTE IMMEDIATE statement (7324)

EXPLAIN statement (7343)

Extended DECLARE CURSOR statement (7091)

FETCH statement (7385)

GRANT statement (7461)

OPEN statement (7622)

Positioned form (7101)

PREPARE statement (7664)

Searched form (7102)

DELETEAUTH column (8217)

of SYSTABAUTH (8525)

DELETERULE column (8189)

of SYSKEYS (8454)

deleting

SQL objects (7198)

delimited identifier (5860)

delimiter token

description (5844)

DEPARTMENT sample table (8572)

dependent privilege (7807)

dependent table

definition (5677)

DEPENDENTS column (8113)

of SYSCATALOG (8286)

DESC clause

of ALTER TABLE statement (6738), (6752)

of CREATE INDEX statement (6889)

of CREATE TABLE statement (7009), (7023)

select-statement (6613)

descendent table

definition (5678)

DESCRIBE CURSOR statement

description (7184), (7188)

DESCRIBE option

of CREATE PACKAGE statement (6928)

DESCRIBE PROCEDURE statement

description (7190), (7194)

DESCRIBE statement

description (7134)

LABEL ON statement (7554)

PREPARE statement (7678)

SQLDA (8028)

SQLLEN value (8058)

SQLTYPE value (8057)

variables in SQLDA after DESCRIBE (7148), (7159)

DESCRIBE statement, Extended (7169), (7183)

descriptor name

description (5880)

descriptor_name

in DESCRIBE statement (7145), (7146)

in EXECUTE statement (7270), (7278)

in Extended DESCRIBE statement (7173)

in Extended EXECUTE statement (7290)

in Extended FETCH statement (7394)

in Extended OPEN statement (7632)

in Extended PREPARE statement (7696)

in Extended PUT statement (7739)

in FETCH statement (7368)

in OPEN statement (7593), (7608)

in PUT statement (7716), (7724)

digit (5837)

DIGITS function (6502)

DISTINCT

clause of subselect (6563)

comparison rules (6041)

in DESCRIBE statement (7161)

keyword

AVG function (6459)

column function (6455)

COUNT function (6466)

MAX function (6470)

MIN function (6474)

SUM function (6478)

distributed relational database

application requester, server (5777)

restrictions (8623), (8626)

Distributed Relational Database Architecture (DRDA) (5779)

DNAME column (8224)

of SYSUSAGE (8537)

double-byte character set (DBCS)

COMMENT ON PROCEDURE statement (6835)

COMMENT ON statement (6821)

in LIKE predicate (6425)

LABEL ON statement (7552)

truncated during assignment (6087)

DOUBLE PRECISION

data type (6715), (6981)

double precision floating-point (5976)

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

data conversion (5789)

DRDA protocol

description (5783)

restrictions (8624), (8627)

DROP FOREIGN KEY clause

of ALTER TABLE statement (6755)

DROP PRIMARY KEY clause

of ALTER TABLE statement (6754)

DROP PROCEDURE statement

EXECUTE IMMEDIATE statement (7326)

DROP PSERVER statement

EXECUTE IMMEDIATE statement (7327)

drop referential constraint (5685)

DROP statement

description (7196)

EXECUTE IMMEDIATE statement (7325)

PREPARE statement (7665)

DROP STATEMENT statement (7247), (7257)

DROP UNIQUE clause

of ALTER TABLE statement (6756)

DTYPE column (8226)

of SYSUSAGE (8539)

DUOW (distributed unit of work) (5787)

duplicate rows

in fullselect (6601)

preventing (5672)

duration

date (6319)

labeled (6309)

time (6331)

timestamp (6333)

dynamic select

DECLARE CURSOR statement (6653)

FETCH statement (6655)

OPEN statement (6654)

dynamic SQL (5622)

description (5624), (6629)

EXECUTE IMMEDIATE statement (7301)

EXECUTE statement (7267)

execution (6638)

host variables (6643)

obtaining information with DESCRIBE (7137)

parameter markers (6644)

preparation (6637)

PREPARE statement (7640)

SQLDA (8022)

statement (5625)

EBCDIC

mixed data (5954)

embedding statements (6631)

EMP_ACT sample table (8576)

EMPLOYEE sample table (8574)

empty character string (6135)

empty string (5908)

encoding scheme (5802)

END DECLARE SECTION statement (7258), (7260), (7263)

entity integrity (5663), (5670)

error

closes cursor (7613)

DELETE statement (7121)

description (7729)

during PUT (7728)

FETCH statement (7382)

INSERT statement (7525)

UPDATE statement (7878)

ERROR option

of CREATE PACKAGE statement (6927)

ERRORBYTE column (8201)

of SYSSTRINGS (8496)

escalate

isolation level (5767)

lock (5755)

ESCAPE clause

in LIKE predicate (6428)

ESCAPE keyword

in LIKE predicate (6417)

EUC (Extended UNIX Code) (5956)

EUR (IBM European standard) (6010)

format (6018)

EUR attribute

DATE option

CREATE PACKAGE statement (6907)

evaluation order of operations (6355)

exclusive

isolation level (5753)

EXCLUSIVE option

IN EXCLUSIVE MODE clause

of LOCK DBSPACE statement (7567)

of LOCK TABLE statement (7579)

executable statement (6619), (6632)

EXECUTE IMMEDIATE statement

building statements (6641)

description (7299)

executing statements (6640)

PREPARE statement (7681)

EXECUTE ON clause

of GRANT statement (7403)

of REVOKE statement (7747), (7752)

EXECUTE statement

description (7264)

executing statements (6639)

PREPARE statement (7680)

SQLDA (8036)

SQLLEN value (8066)

SQLTYPE value (8065)

EXECUTE statement, Extended (7286), (7298)

EXIST option

of CREATE PACKAGE statement (6931)

EXISTS predicate

description (6404)

NOT keyword (6405)

exp (5615)

EXPLAIN column (8094)

EXPLAIN option

of CREATE PACKAGE statement (6910)

EXPLAIN statement

description (7341)

EXECUTE IMMEDIATE statement (7328)

PREPARE statement (7666)

explainable statement (7354)

exposed name

table (6178)

expression

arithmetic operators (6220), (6266)

column_name (6224)

concatenation operator (6257)

constant (6223)

datetime operands (6306)

decimal operands (6282), (6289)

expression (6222)

floating-point operands (6302)

function (6221)

host_variable (6225)

in a basic predicate (6368)

in a quantified predicate (6383)

in a subselect (6557)

in BETWEEN predicate (6400)

in DESCRIBE statement (7162)

in IN predicate (6410)

integer operands (6275), (6281)

labeled_duration (6227)

numeric (6269)

operators (6256)

precedence of operation (6354)

special_register (6226)

string (6258)

subselect (6568)

value (6211)

Extended CLOSE statement (6800), (6807)

Extended DECLARE CURSOR statement (7076), (7094)

Extended DESCRIBE statement

description (7168)

SQLDA (8029)

extended dynamic SQL

description (5626), (5632)

Extended EXECUTE statement

description (7285)

SQLDA (8037)

Extended FETCH statement

description (7389)

SQLDA (8031)

Extended OPEN statement

description (7626)

SQLDA (8033)

Extended PREPARE statement (7687), (7705)

Extended PUT statement

description (7732)

SQLDA (8035)

extender, alphabetic (5835)

FETCH

assignment rules (6032)

FETCH statement

description (7361)

dynamic select (6658)

OPEN statement (7618)

SQLDA (8030)

SQLLEN value (8060)

SQLTYPE value (8059)

static select (6652)

FETCH statement, Extended (7390), (7399)

field procedure

in LIKE predicate (6427)

FIELDPROC clause

of ALTER TABLE statement (6734)

of CREATE TABLE statement (6973), (7005)

FIRSTKEYCOUNT column (8173)

of SYSINDEXES (8417)

FIRSTROW column (8085)

of SYSACCESS (8256)

fixed-length

character string (5911)

graphic string (5962)

FLDLENGTH column (8159)

of SYSFIELDS (8387)

FLDPROC column (8148)

of SYSCOLUMNS (8354)

of SYSKEYCOLS (8440)

FLDTYPE column (8158)

of SYSFIELDS (8386)

FLOAT

data type (6713), (6979)

function (6504)

floating-point

arithmetic (6304)

constant (6129)

number (5974)

precision (5971)

folding (5839), (5852)

FOR BIT DATA clause

of ALTER TABLE statement (6729)

of CREATE TABLE statement (7001)

FOR clause

of CREATE SYNONYM statement (6956)

of EXPLAIN statement (7352)

of Extended PREPARE statement (7699)

of UPDATE STATISTICS statement (7897), (7906)

FOR DBSPACE clause

of UPDATE STATISTICS statement (7900), (7907)

FOR MIXED DATA clause

of ALTER TABLE statement (6727)

of CREATE TABLE statement (6999)

FOR SBCS DATA clause

of ALTER TABLE statement (6728)

of CREATE TABLE statement (6997)

FOR TABLE clause

of UPDATE STATISTICS statement (7898), (7904)

FOR UPDATE OF clause

of DELETE statement (7130)

of select-statement (6616)

foreign key

activating and deactivating (5716), (5723)

description (5680)

multiple (5683)

FOREIGN KEY clause

of ALTER TABLE statement (6740)

of CREATE TABLE statement (7011)

FORTRAN

application program

BEGIN DECLARE SECTION statement (6784)

host variable (6192), (7309)

INCLUDE SQLCA (8017)

INCLUDE statement (7493)

PREPARE statement (7653)

SQLCA (7982)

varying-length string variables (5932)

FPEXITPARM column (8164)

of SYSFPARMS (8401)

FPEXITPARML column (8162)

of SYSFIELDS (8390)

FPNAME column (8160)

of SYSFIELDS (8388)

of SYSFPARMS (8396)

FPPARMLIST column (8163)

of SYSFIELDS (8391)

FPWORKAREA column (8161)

of SYSFIELDS (8389)

fragment of syntax

in syntax diagrams (5602)

FREEPCT column (8154)

of SYSDBSPACES (8367)

FREQ1PCT column (8131)

of SYSCOLSTATS (8325)

FREQ1VAL column (8130)

of SYSCOLSTATS (8324)

FREQ2PCT column (8133)

of SYSCOLSTATS (8327)

FREQ2VAL column (8132)

of SYSCOLSTATS (8326)

FROM clause

of DELETE statement (7109), (7112)

of Extended PUT statement (7736)

of PREPARE statement (7644), (7647)

of PUT statement (7712), (7717)

of REVOKE statement (7749), (7754), (7791), (7805)

of SELECT INTO statement (7832), (7837)

of subselect (6545), (6582)

FROM NULL clause

of Extended PREPARE statement (7698)

FULLKEYCOUNT column (8174)

of SYSINDEXES (8418)

fullselect

description (6596)

in parentheses

ISO-ANS SQL(89) equivalent term (8620)

ISO-ANS SQL(89) equivalent term (8610)

select-statement (6606)

function (6482)

column

AVG (6458)

COUNT (6464)

description (6454)

MAX (6469)

MIN (6473)

SUM (6477)

DESCRIBE statement (7160)

description (6450)

nesting (6483)

scalar

CHAR (6484)

DATE (6491)

DAY (6493)

DAYS (6495)

DECIMAL (6497)

description (6481)

DIGITS (6501)

FLOAT (6503)

HEX (6505)

HOUR (6508)

INTEGER (6510)

LENGTH (6512)

MICROSECOND (6514)

MINUTE (6516)

MONTH (6518)

SECOND (6520)

STRIP (6522)

SUBSTR (6524)

TIME (6528)

TIMESTAMP (6530)

TRANSLATE (6532)

VALUE (6534)

VARGRAPHIC (6537)

YEAR (6540)

GO TO clause (7918) See also GOTO clause

of WHENEVER statement (7931)

GOTO clause

of WHENEVER statement (7919), (7932)

GRANT statement

EXECUTE IMMEDIATE statement (7329)

PREPARE statement (7667)

used to grant

Package Privileges (7400), (7413)

System Authorities (7415), (7436)

Table Privileges (7438), (7479)

GRANTEE column (8125)

of SYSCOLAUTH (8309)

of SYSPROGAUTH (8480)

of SYSTABAUTH (8514)

GRANTEETYPE column (8208)

of SYSTABAUTH (8515)

GRANTOR column (8124)

of SYSCOLAUTH (8308)

of SYSPROGAUTH (8479)

of SYSTABAUTH (8513)

GRAPHIC

data type (6721), (6988)

graphic string

constant

support (6148)

description (5959)

fixed-length (5963)

host variable (5965)

GROUP BY clause

comparison rules (6042)

maximum number of columns (7966)

maximum total length of columns (7967)

of subselect (6547), (6586)

results with subselect (6571)

grouped

table

DB2 Server for VSE & VM equivalent term (8591)

view

DB2 Server for VSE & VM equivalent term (8592)

grouping column

DB2 Server for VSE & VM equivalent term (8593)

identified in GROUP BY (6588)

HAVING clause

maximum number of predicts (7965)

of subselect (6548), (6591)

results with subselect (6572)

HEX

function (6506)

hexadecimal (6507)

hexadecimal constant (6137)

HIGH2KEY column (8141)

of SYSCOLUMNS (8346)

host identifier (5856), (5868)

host_identifier

length limitation (7941)

host_label

in WHENEVER statement (7921)

host language

comments (5848)

host structure

description (6204)

in FETCH statement (7366)

in INSERT statement (7510)

in OPEN statement (7592)

in PUT statement (7720)

in SELECT INTO statement (7836)

indicator array (6209)

host variable

CCSID

application requester/server (5817)

character string (5926)

description (6187)

embedded statements (6633)

host_identifier (6197)

in BEGIN DECLARE SECTION statement (6779)

in DECLARE CURSOR statement (7067)

in END DECLARE SECTION statement (7261)

in syntax diagrams (5591)

INDICATOR keyword (6198)

indicator variable (6202)

length attribute (6364)

main variable (6199)

maximum number in an SQL statement (7961)

maximum number of declarations in a precompiled program (7960)

null value (6203)

numeric (5982)

parameter markers (6196)

statement preparation (6645)

substitution for parameter markers (7276)

host_variable

description (5881)

in CREATE PACKAGE statement (6897), (6940)

in EXECUTE IMMEDIATE statement (7304)

in EXECUTE statement (7269)

in Extended PUT statement (7737)

in FETCH statement (7365), (7373)

in INSERT statement (7508)

in LIKE predicate (6419)

in OPEN statement (7590)

in PREPARE statement (7645), (7648)

in PUT statement (7713), (7718)

in SELECT INTO statement (7834)

in SELECT statement (7843)

host-variable (7187), (7193)

host variable followed by an indicator variable

ISO-ANS SQL(89) equivalent term (8611)

host_variable_list

description (5882), (7281)

in EXECUTE statement (7277)

in FETCH statement (7367), (7374)

in INSERT statement (7509)

in OPEN statement (7591), (7607)

in PUT statement (7714), (7719), (7721)

in SELECT INTO statement (7835), (7840)

host_variable-list

in IN predicate (6408)

host_variable_structure

in FETCH statement (7375)

HOUR

function (6509)

labeled duration (6230)

HOURS

labeled duration (6231)

IBM European standard (6011) See also EUR (IBM European standard)

IBM USA standard (USA) (6014) See also USA (IBM USA standard)

ICREATOR column (8166)

of SYSINDEXES (8407)

IDENTIFIED BY clause

of CONNECT statement (6859), (6871)

of GRANT statement (7420), (7430)

identifier

delimited (5861)

description (5854)

host (5867)

long (5864)

ordinary (5858)

short (5866)

IID column (8170)

of SYSINDEXES (8414)

IMMEDIATE keyword

of EXECUTE IMMEDIATE statement (7302)

IN clause

of CREATE TABLE statement (7026)

of DROP STATEMENT statement (7251)

of Extended DECLARE CURSOR statement (7082)

of Extended EXECUTE statement (7291)

of Extended PREPARE statement (7693)

IN EXCLUSIVE MODE clause

description (7569)

LOCK DBSPACE statement (7568)

LOCK TABLE statement (7578)

IN predicate

description (6409)

NOT keyword (6411)

IN SHARE MODE clause

LOCK DBSPACE statement (7563)

LOCK TABLE statement (7576)

IN_TRAY sample table (8578)

INACTIVE column (8114)

of SYSCATALOG (8287)

INAME column (8165)

of SYSINDEXES (8406)

of SYSKEYS (8451)

INCCSID column (8198)

of SYSSTRINGS (8493)

INCLUDE SQLCA

language specifics (8011)

INCLUDE SQLDA

language specifics (8072)

INCLUDE statement

description (7481)

SQLCA (7977)

SQLDA (8024)

incompatibilities, release to release

2.1 and 1.3.5 (8631), (8633)

2.2 and 2.1 (8635), (8637)

3.1 and 2.2 (8639), (8641)

3.3 and 3.2 (VM only) (8643), (8645)

3.4 and 3.2 (VSE only) (8651), (8653)

3.4 and 3.3 (VM only) (8647), (8649)

3.5 and 3.4 (8655)

5.1 and 3.5 (8657)

6.1 and 5.1 (8659)

description (8629)

independent table

definition (5679)

index

activating and deactivating (5717), (5722)

description (5725)

key (5651)

longest key (7955)

maximum byte count (7953)

maximum number on a table (7957)

INDEX clause

of DROP statement (7208), (7215)

of GRANT statement (7444), (7462)

of REVOKE statement (7783), (7797)

index_id

description (5883)

index key

CREATE INDEX statement (6882)

index_name

description (5884)

in CREATE INDEX statement (6878), (6884)

in DROP statement (7202)

length limitation (7948)

INDEXAUTH column (8219)

of SYSTABAUTH (8527)

INDEXTYPE column (8168)

of SYSINDEXES (8411)

indicator array (6208)

indicator variable

description (6201)

EXECUTE IMMEDIATE statement (7303)

PREPARE statement (7649)

SQLDA (8054)

infix operator (6274)

insert

assignment rules (6033)

on view (5727)

INSERT

insert-block

in PUT statement (7726)

INSERT by subselect (7501)

INSERT clause

of GRANT statement (7445), (7464)

of REVOKE statement (7784), (7798)

insert cursor

in DECLARE CURSOR statement (7054)

in OPEN statement (7599), (7601)

insert rule

description (5712)

insert-statement

in DECLARE CURSOR statement (7057), (7066)

INSERT statement

description (7499)

EXECUTE IMMEDIATE statement (7330)

EXPLAIN statement (7344)

GRANT statement (7465)

OPEN statement (7620)

PREPARE statement (7668)

INSERT using VALUES (7500)

INSERTAUTH column (8215)

of SYSTABAUTH (8523)

INT (6976) See also INTEGER

integer

arithmetic (6279)

constant (6127)

data type (6711), (6977)

division (6280)

function (6511)

operand (6292)

operands (6277)

precision (5969)

INTEGER

integrity

atomic (5662)

data (5668), (5739)

entity (5664)

referential (5666)

interactive entry of SQL statements (6659)

interactive SQL

description (5628)

QMF (5629)

International Standards Organization (ISO)

format (6016)

INTO clause

of DESCRIBE statement (7138), (7147)

of FETCH statement (7372)

of INSERT statement (7502), (7514)

of SELECT INTO statement (7839)

invalidation of packages (6769), (7217), (7235)

invocation of statements (6624)

IPCTFREE column (8178)

of SYSINDEXES (8422)

IS clause

of COMMENT ON PROCEDURE statement (6834)

of COMMENT ON statement (6820)

of LABEL ON statement (7543), (7551)

ISO (6012) See also International Standards Organization (ISO)

ISO-ANS SQL(89) / DB2 Server for VSE & VM equivalent terms (8586), (8621)

ISO attribute

DATE option

CREATE PACKAGE statement (6905)

isolation level

cursor stability (5760)

description (5745)

escalation (5768)

exclusive (5752)

program control (5772)

repeatable read (5757)

share (5748)

uncommitted read (5764)

update (5750)

USER (5773)

ISOLATION option

of CREATE PACKAGE statement (6911)

Japanese Industrial Standard (6013) See also JIS (Japanese Industrial Standard)

JIS (Japanese Industrial Standard)

format (6019)

JIS attribute

DATE option

CREATE PACKAGE statement (6908)

join

definition (6555)

example (6594)

KEEP option

of CREATE PACKAGE statement (6919)

key

activating and deactivating (5714), (5724)

composite (5647)

definition (5646)

primary (5654)

primary index (5657)

unique (5648)

unique index (5658)

KEYCOLS column (8186)

of SYSKEYS (8450)

KEYLEN column (8172)

of SYSINDEXES (8416)

KEYNAME column (8182)

of SYSKEYCOLS (8433)

of SYSKEYS (8449)

KEYORD column (8183)

of SYSKEYCOLS (8435)

KEYTYPE column (8181)

of SYSINDEXES (8425)

of SYSKEYCOLS (8432)

of SYSKEYS (8448)

keyword

in syntax diagrams (5590)

label (7538) See also LABEL ON statement

columns (7535)

producing with LABEL ON statement (7534)

tables (7536)

views (7537)

LABEL ON statement

column name qualification (6170)

description (7532)

EXECUTE IMMEDIATE statement (7331)

PREPARE statement (7669)

LABEL option

of CREATE PACKAGE statement (6921)

labeled duration

DAY (6242), (6312)

DAYS (6243), (6313)

HOUR (6244), (6323)

HOURS (6245), (6324)

MICROSECOND (6246), (6325)

MICROSECONDS (6247), (6326)

MINUTE (6248), (6327)

MINUTES (6249), (6328)

MONTH (6250), (6314)

MONTHS (6251), (6315)

SECOND (6252), (6329)

SECONDS (6253), (6330)

YEAR (6254), (6316)

YEARS (6255), (6317)

LABELS

in USING clause

of DESCRIBE statement (7141)

of Extended DESCRIBE statement (7176)

LANGID column (8193)

of SYSLANGUAGE (8464)

LANGKEY column (8192)

of SYSLANGUAGE (8462)

LANGUAGE column (8191)

of SYSLANGUAGE (8461)

large integer

definition (5973)

length

attribute

column (5914)

host variable (6365)

function (6513)

LENGTH

LENGTH column (8137)

of SYSCOLUMNS (8341)

letter (5833), (5851)

LFDDBSPACE column (8110)

of SYSCATALOG (8283)

LFDLINK column (8109)

of SYSCATALOG (8282)

LFDTABID column (8108)

of SYSCATALOG (8281)

LIKE predicate

description (6414)

limits in the database manager (7936)

LINKID column (8084)

of SYSACCESS (8255)

literal

description (6125)

LOCAL attribute

DATE option

CREATE PACKAGE statement (6909)

LOCAL time standard

format (6020)

lock

COMMIT statement (6846)

dbspace (7561)

DELETE statement (7128)

description (5737)

escalation (5754)

INSERT statement (7529)

LOCK DBSPACE statement (7560)

LOCK TABLE statement (7574)

ROLLBACK statement (7822)

table (7573)

types (5746)

UPDATE statement (7880), (7888)

LOCK clause

of ACQUIRE DBSPACE statement (6675)

of ALTER DBSPACE statement (6691)

LOCK DBSPACE statement

description (7558)

EXECUTE IMMEDIATE statement (7332)

PREPARE statement (7670)

LOCK TABLE statement

description (7571)

EXECUTE IMMEDIATE statement (7333)

PREPARE statement (7671)

LOCKMODE column (8155), (8175)

of SYSDBSPACES (8368)

of SYSINDEXES (8419)

logical operators (6443)

logical unit of work (LUW)

COMMIT statement (6840)

CREATE PACKAGE statement (6942)

description (5742)

DROP statement (7237)

Extended CLOSE statement (6805)

Extended DESCRIBE statement (7179)

Extended FETCH statement (7396)

Extended OPEN statement (7634)

Extended PREPARE statement (7702)

Extended PUT statement (7741)

initiating closes cursors (7612)

ISO-ANS SQL(89) equivalent term (8612)

prepared statement referenced only in (7642)

ROLLBACK statement (7815)

terminating (7814)

terminating destroys prepared statements (7682)

long identifier (5863)

long string

blocking restriction (5924)

column (5920)

CREATE TABLE statement (7030)

description (5922), (7031)

limitations in select-list (6569)

restriction in INSERT statement (7522)

LONG VARCHAR

data type (6720), (6987)

LONG VARGRAPHIC

data type (6723), (6990)

LOW2KEY column (8142)

of SYSCOLUMNS (8347)

lowercase (5834), (5850)

LUW (6841) See also logical unit of work (LUW)

main variable

description (6200)

maintenance, package (5634)

MAX

comparison rules (6039)

function (6468)

MBCS (multi-byte characters) (5958)

MICROSECOND

function (6515)

labeled duration (6232), (6320)

MICROSECONDS

labeled duration (6233)

MIN

comparison rules (6040)

function (6472)

MINUTE

function (6517)

labeled duration (6234), (6321)

MINUTES

labeled duration (6235)

mixed data

ASCII (5951)

COMMENT ON statement (6822), (6836)

conditions (5948)

CREATE TABLE statement (7000)

description (5942)

EBCDIC (5953)

EUC (5955)

in LIKE predicate (6424)

LABEL ON statement (7553)

MBCS (5950)

representation conventions (5604)

rules (5944), (5947)

SQLDA (8050)

string assignments (6076), (6089)

MODE keyword

description (7581)

IN SHARE MODE clause

of LOCK DBSPACE statement (7565)

of LOCK TABLE statement (7580)

MODIFY option

of CREATE PACKAGE statement (6932)

of DROP STATEMENT statement (7253)

MONTH

function (6519)

labeled duration (6236), (6310)

MONTHS

labeled duration (6237)

multiple foreign keys (5682)

multiple path

delete-connected (5706)

NAME column (8120)

of SYSCHARSETS (8301)

of SYSUSERAUTH and SYSUSERLIST (8549)

NAMED clause

of ACQUIRE DBSPACE statement (6670)

NAMES

in USING clause

of DESCRIBE statement (7140)

of Extended DESCRIBE statement (7175)

naming conventions

SQL (5871)

NCOLS column (8092)

of SYSCATALOG (8269)

NEW option

of CREATE PACKAGE statement (6938)

NHEADER clause

of ACQUIRE DBSPACE statement (6671)

NLEAF column (8176)

of SYSINDEXES (8420)

NLEVELS column (8177)

of SYSINDEXES (8421)

NOBLOCK option

of CREATE PACKAGE statement (6922)

NOCHECK option

of CREATE PACKAGE statement (6925)

NODESCRIBE option

of CREATE PACKAGE statement (6929)

NOEXIST option

of CREATE PACKAGE statement (6930)

NOFOR option

UPDATE statement (7889)

NOMODIFY option

of CREATE PACKAGE statement (6933)

nonexecutable statement (6621), (6635)

nonrecoverable dbspace

CREATE TABLE statement (7028)

nonrecoverable storage pool

UPDATE statement (7886)

NOT

in a search condition (6434)

NOT FOUND clause

of WHENEVER statement (7920), (7927)

NOT keyword

in EXISTS predicate (6401)

in LIKE predicate (6415)

NOT NULL clause

of CREATE TABLE statement (6994)

NOVERFLOW column (8107)

of SYSCATALOG (8280)

NPAGES column (8105)

of SYSCATALOG (8278)

of SYSDBSPACES (8364)

NRHEADER column (8152)

of SYSDBSPACES (8365)

NTABS column (8151)

of SYSDBSPACES (8363)

NULL

keyword

in INSERT statement (7511)

in UPDATE statement (7859), (7870)

predicate

description (6430)

NOT keyword (6431)

null value (6432)

null attribute of result column (6574)

null foreign key (5681)

null value

assign to database (6022)

assigned to host variable (7842)

assignment (6048)

attribute of a result column (6575)

checking (6027)

CREATE INDEX statement (6883)

definition (5904)

duplicate rows (6564)

elimination with VALUE function (6536)

equality and ordering (6026)

grouping columns (6590)

in expression or predicate (6024), (6025)

return from database (6023)

NULLS column (8139)

of SYSCOLUMNS (8343)

number of items in a select list

ISO-ANS SQL(89) equivalent term (8614)

numbers (5967)

numeric

assignments

COBOL integer (6067)

decimal (6052), (6055), (6057), (6061), (6065)

floating-point (6051), (6054), (6063), (6064)

integer (6053), (6056), (6062)

comparisons

decimal (6106), (6109), (6113)

floating-point (6111), (6114)

integer (6105), (6112)

expression (6270)

numeric conversion

DRDA (5790)

NUMERIC data type

synonym for DECIMAL data (6717), (6984)

numeric host variable (5981)

object table (6175)

ON clause

of CREATE INDEX statement (6885)

of GRANT statement (7450), (7472)

of REVOKE statement (7788), (7802)

ON DELETE clause

of ALTER TABLE statement (6744)

of CREATE TABLE statement (6971), (7015)

open state of cursor

FETCH statement (7383)

OPEN statement (7588)

OPEN statement

description (7585)

dynamic select (6657)

select-statement invocation (6626)

SQLDA (8032)

SQLLEN value (8062)

SQLTYPE value (8061)

static select (6651)

OPEN statement, Extended (7627), (7637)

operand

datetime (6307)

decimal (6284), (6290)

floating-point (6303)

integer (6276), (6283)

string (6261)

operation

assignment (6031), (6102)

comparison (6104), (6123)

description (6028)

precedence (6345)

operations in SQL (6029)

operator

arithmetic (6267)

optional

default parameter

in syntax diagrams (5601)

item

in syntax diagrams (5596)

keyword

in syntax diagrams (5600)

in a search condition (6436)

truth table (6446)

ORDER BY clause

comparison rules (6043)

ISO-ANS SQL(89) equivalent term (8615)

maximum number of columns (7968)

maximum total length of columns (7969)

of select-statement (6611)

order of evaluation (6356)

ORDERFIELD column (8144)

of SYSCOLUMNS (8349)

ordinary identifier

description (5857)

ordinary token

description (5842)

ORIGINAL column (8098)

OUTCCSID column (8199)

of SYSSTRINGS (8494)

outer reference

DB2 Server for VSE & VM equivalent term (8594)

overflow (8583)

OWNER column (8149)

of SYSDBSPACES (8361)

owner_name

description (5885)

owner of catalog tables (SYSTEM) (8241)

OWNER option

of CREATE PACKAGE statement (6934)

package

CREATE PACKAGE statement (6895), (6941)

description (5730)

DROP statement (7216), (7229), (7234)

DROP STATEMENT statement (7248)

Extended PREPARE statement (7690)

GRANT statement (7402)

invalidation (6767), (7218), (7236)

preprocessing (6768), (7255)

section (5731)

PACKAGE clause

of DROP statement (7211), (7219)

package_id

description (5886)

package_name

description (5887)

in DROP statement (7205), (7220)

in GRANT statement (7404), (7409)

in REVOKE statement (7748), (7753)

length limitation (7945)

package_spec

description (5888)

in CREATE PACKAGE statement (6896), (6899)

in DROP STATEMENT statement (7250)

in Extended DECLARE CURSOR statement (7084), (7087)

in Extended DESCRIBE statement (7172)

in Extended EXECUTE statement (7289)

in Extended PREPARE statement (7694)

padding

bit data (6077)

string (6073)

PAGE value for LOCK clause

description (6695)

of ACQUIRE DBSPACE statement (6677)

of ALTER DBSPACE statement (6694)

PAGES clause

of ACQUIRE DBSPACE statement (6672)

parameter marker

EXECUTE statement (7273)

Extended EXECUTE statement (7295)

Extended PREPARE statement (7701)

OPEN statement (7605), (7610)

PREPARE statement (7676)

PUT statement (7722)

rules (7677)

SQLDA (8047)

statement preparation (6646)

parent table

definition (5676)

parentheses

in syntax diagrams (5593)

with UNION (6602)

PARENTS column (8112)

of SYSCATALOG (8285)

password

catalog (8243)

CONNECT statement (6856), (6868)

description (5889)

GRANT statement (7417), (7424), (7431)

PASSWORD column (8231)

of SYSUSERAUTH and SYSUSERLIST (8553)

PCTFREE clause

description (6891)

of ACQUIRE DBSPACE statement (6674)

of ALTER DBSPACE statement (6690)

of ALTER TABLE statement (6739), (6753)

of CREATE INDEX statement (6890)

of CREATE TABLE statement (7010), (7024)

PCTINDEX clause

of ACQUIRE DBSPACE statement (6673)

PCTINDX column (8153)

of SYSDBSPACES (8366)

PCTPAGES column (8106)

of SYSCATALOG (8279)

percent sign (%)

in LIKE predicate (6423)

phantom row (5762)

PL/I

application program

BEGIN DECLARE SECTION statement (6785)

graphic string constants (6146)

host structure (6207)

host variable (6190), (7310)

INCLUDE statement (7494)

PREPARE statement (7654)

SQLCA (7980), (8019)

SQLDA (8026), (8077)

varying-length string variables (5933)

PLABEL column (8090)

of SYSACCESS (8261)

PLAN clause

of EXPLAIN statement (7347)

PLAN_TABLE

EXPLAIN statement (7356)

points of consistency (5743)

POOL column (8156)

of SYSDBSPACES (8370)

Positioned form

of DELETE statement (7099)

of UPDATE statement (7848)

precedence

level (6353)

operation

addition (6351)

concatenation (6357)

datetime arithmetic (6358)

division (6350)

expression (6346)

multiplication (6349)

parentheses (6347)

prefix operator (6348)

subtraction (6352)

precision

decimal data (5979)

of a number (5968)

results of arithmetic operations (6288), (6293)

predicate

basic (6379)

BETWEEN (6397)

comparison rules (6038)

condition (6360)

description (6359)

EXISTS (6403)

false (6362)

IN (6412)

in a search condition (6437)

LIKE (6413)

NULL (6429)

quantified (6381)

true (6361)

unknown (6363)

prefix operator (6271)

PREPARE statement

building statements (6642)

description (7638)

EXECUTE IMMEDIATE statement (7338)

PREPARE statement, Extended (7688), (7706)

prepared SQL statement

DECLARE CURSOR statement (7069)

dynamically prepared by PREPARE (7641), (7683)

executing (7266), (7283)

Extended DECLARE CURSOR statement (7079)

Extended DESCRIBE statement (7170)

Extended EXECUTE statement (7287)

Extended PREPARE statement (7689)

maximum number (7971)

obtaining information with DESCRIBE (7136)

SQLDA provides information (8023)

preparing statements (5618)

preplanned database access (5637)

preprocess

ALTER TABLE statement (6766)

DROP statement (7225), (7230)

DROP STATEMENT statement (7254)

preprocessor (5635)

description (7073)

NOFOR option (7072)

primary

activating and deactivating keys (5718)

index (5659)

key (5656), (5671)

primary key

activating and deactivating (5721)

PRIMARY KEY clause

of ALTER TABLE statement (6736)

of CREATE TABLE statement (6995), (7007)

PRIVATE clause

in ACQUIRE DBSPACE statement (6668)

private dbspace

privileges for CREATE TABLE (6966), (7027)

privilege

access objects (5827)

create index (5829)

dependencies (7808)

PROCEDURE clause

of COMMENT ON PROCEDURE statement (6832)

procedure-name (7192)

PROGNAME column (8196)

of SYSPROGAUTH (8482)

program

as an application process (5735)

declaring a host_identifier (5869)

Extended CLOSE statement (6804)

Extended DESCRIBE statement (7180)

Extended FETCH statement (7395)

Extended OPEN statement (7633)

Extended PUT statement (7740)

inserting declarations (7484)

inserting statements (7485)

program control

isolation level (5771)

program_name

in ALTER TABLE statement (6733), (6735)

in CREATE TABLE statement (6972), (7006)

PROJ_ACT sample table (8582)

PROJECT sample table (8580)

PUBLIC clause

in ACQUIRE DBSPACE statement (6669)

in GRANT statement (7407), (7411), (7455), (7477)

in REVOKE statement (7751), (7756), (7793), (7806)

punctuation mark

in syntax diagrams (5592)

PUT

assignment rules (6034)

PUT statement

description (7707)

OPEN statement (7619)

SQLDA (8034)

SQLLEN value (8064)

SQLTYPE value (8063)

PUT statement, Extended (7733), (7744)

QMF (5631)

QUALF column (8157)

of SYSDROP (8377)

qualification of column names (6171)

QUALIFIER option

of CREATE PACKAGE statement (6935)

quantified predicate

description (6380)

query

description (6542)

expression

DB2 Server for VSE & VM equivalent term (8595)

specification

DB2 Server for VSE & VM equivalent term (8596)

term

DB2 Server for VSE & VM equivalent term (8597)

query cursor

in DECLARE CURSOR statement (7053)

in OPEN statement (7598), (7603)

query management facility (QMF) (5630)

question mark (7274) See also parameter marker

reactivate referential constraint (5691)

read-only

cursor (7064)

table (7063)

view (7043)

read stability

isolation level (5769), (6917)

REAL data type (6714), (6980)

recoverable storage pool

UPDATE statement (7884)

recreate referential constraint (5689)

REFAUTH column (8220)

of SYSTABAUTH (8528)

REFERENCE clause

of EXPLAIN statement (7348)

REFERENCE_TABLE

EXPLAIN statement (7357)

REFERENCES clause

of ALTER TABLE statement (6742)

of CREATE TABLE statement (6970), (7013)

of GRANT statement (7446), (7466)

of REVOKE statement (7785), (7799)

REFERENCES privilege

in ALTER TABLE statement (6708)

referential constraint

deactivate (5688)

delete rule

cascade (5698)

restrict (5695)

set null (5701)

description (5684)

drop (5686)

GRANT statement (7468)

INSERT statement (7524)

key (5653)

reactivate (5692)

recreate (5690)

UPDATE statement (7882)

referential cycle

definition (5707)

referential integrity (5665), (5674)

REFTCREATOR column (8188)

of SYSKEYS (8453)

REFTNAME column (8187)

of SYSKEYS (8452)

relational database

description (5639)

distributed (5778)

RELEASE column (8180)

of SYSINDEXES (8424)

RELEASE keyword

of COMMIT statement (6843)

ROLLBACK statement (7818), (7819)

RELEASE option

of CREATE PACKAGE statement (6936)

release to release incompatibilities

2.1 and 1.3.5 (8632), (8634)

2.2 and 2.1 (8636), (8638)

3.1 and 2.2 (8640), (8642)

3.3 and 3.2 (VM only) (8644), (8646)

3.4 and 3.2 (VSE only) (8652), (8654)

3.4 and 3.3 (VM only) (8648), (8650)

3.5 and 3.4 (8656)

5.1 and 3.5 (8658)

6.1 and 5.1 (8660)

description (8630)

remarks

in catalog (6812), (6828)

REMARKS column (8093)

of SYSCATALOG (6817), (6833), (8270)

of SYSCOLUMNS (6819), (8344)

of SYSLANGUAGE (8463)

of SYSOPTIONS (8472)

remote unit of work (RUOW) (5785)

repeat symbol

in syntax diagrams (5598)

repeatable read

isolation level (5758)

REPLACE option

of CREATE PACKAGE statement (6937)

required item

in syntax diagrams (5595)

reserved word (5859), (5862)

reserved words

SQL (5603)

resource

authority (5821)

RESOURCE authority

ACQUIRE DBSPACE statement (6666)

CREATE TABLE statement (6965)

RESOURCE clause

of GRANT statement (7427)

of REVOKE statement (7765), (7771)

RESOURCEAUTH column (8229)

of SYSUSERAUTH and SYSUSERLIST (8551)

restrict

delete rule (5697)

DELETE statement (7123)

ON DELETE clause

of ALTER TABLE statement (6745)

of CREATE TABLE statement (7016)

restrictions

delete rule (5710)

delete with subquery (5711)

DRDA protocol (8625), (8628)

isolation level (5766)

result

ISO-ANS SQL(89) equivalent term (8616)

result columns of subselect (6577)

result set locator data type (5902)

result specification

DB2 Server for VSE & VM equivalent term (8598)

result table

DECLARE CURSOR statement (7062)

definition (5644)

REVOKE option

of CREATE PACKAGE statement (6920)

REVOKE statement

EXECUTE IMMEDIATE statement (7334)

GRANT option (7809)

PREPARE statement (7672)

used to revoke

Package Privileges (7745), (7757)

System Authorities (7759), (7775)

Table Privileges (7777), (7810)

REXX

application program

BEGIN DECLARE SECTION statement (6780)

host variable (6191), (7311)

PREPARE statement (7655)

varying-length string variables (5934)

dynamic SQL (5627)

extended dynamic SQL (5638)

rollback

description (5741)

ROLLBACK statement (7813), (7825)

row

deleting (7098)

inserting (7498)

maximum byte count (7951)

maximum number in a table (7954)

ROW value for LOCK clause

of ACQUIRE DBSPACE statement (6678)

of ALTER DBSPACE statement (6693)

ROWCOUNT column (8104)

of SYSCATALOG (8277)

RR attribute

isolation level (5756)

CREATE PACKAGE statement (6912)

RS attribute

isolation level (5770), (6918)

isolation option

CREATE PACKAGE statement (6913)

rs-locator-variable (6774)

run-time authorization ID (5899)

RUNAUTH column (8197)

of SYSPROGAUTH (8484)

RUOW (remote unit of work) (5786) See also remote unit of work (RUOW)

sample table

ACTIVITY (8567)

CL_SCHED (8569)

DEPARTMENT (8571)

EMP_ACT (8575)

EMPLOYEE (8573)

IN_TRAY (8577)

PROJ_ACT (8581)

PROJECT (8579)

SBCS

character (5612)

SBCS data

CREATE TABLE statement (6998)

description (5939)

SQLDA (8051)

SBCSID column (8117)

of SYSCCSIDS (8294)

SBLOCK option

of CREATE PACKAGE statement (6924)

scalar function See also function

CCSID (5815)

description (6480)

scale

decimal data (5980)

scale of data

comparisons in SQL (6110)

conversion of numbers in SQL (6058)

determined by SQLLEN variable (8045)

results of arithmetic operations (6291)

SCHEDULE clause

of GRANT statement (7421), (7432)

of REVOKE statement (7766), (7773)

SCHEDULEAUTH column (8232)

of SYSUSERAUTH and SYSUSERLIST (8554)

SCREATOR column (8209)

of SYSTABAUTH (8516)

search condition

DELETE statement (7118)

description (6438)

false (6441)

order of evaluation (6449)

parentheses (6448)

predicate (6439)

true (6440)

unknown (6442)

search_condition

in DELETE statement (7107), (7117)

in HAVING clause (6592)

in UPDATE statement (7861), (7872)

in WHERE clause (6584)

Searched form

of DELETE statement (7100)

of UPDATE statement (7849)

SECOND

function (6521)

labeled duration (6238), (6322)

SECONDS

labeled duration (6239)

section

in package (5732)

section_variable

description (5890)

in DROP STATEMENT statement (7249)

in Extended DECLARE CURSOR statement (7083), (7086)

in Extended DESCRIBE statement (7171)

in Extended PREPARE statement (7692)

SECTNO column (8096)

SECTTYPE column (8095)

SELECT clause

of GRANT statement (7447), (7469)

of REVOKE statement (7786), (7800)

of SELECT INTO statement (7831)

of subselect (6544), (6556)

SELECT INTO

assignment rules (6036)

description (7826), (7845)

select list (6561)

application (6573)

maximum number of elements (7963)

notation (6567)

select-statement

fullselect (6607)

in DECLARE CURSOR statement (7055), (7065)

in EXECUTE IMMEDIATE statement (7335)

in PREPARE statement (7673)

invocation (6625)

SELECTAUTH column (8214)

of SYSTABAUTH (8522)

self-referencing table

definition (5708)

SEQNO column (8097), (8236)

of SYSFPARMS (8400)

of SYSVIEWS (8561)

server_name

description (5891)

in CONNECT statement (6858), (6870)

length limitation (7942)

SET clause

of UPDATE statement (7857), (7868)

set function

DB2 Server for VSE & VM equivalent term (8599)

set null

delete rule (5703)

DELETE statement (7124)

ON DELETE clause

of ALTER TABLE statement (6747)

of CREATE TABLE statement (7018)

SET QUERYNO clause

of EXPLAIN statement (7351)

SETTING clause

of Extended PREPARE statement (7691)

isolation level (5749)

SHARE option

IN SHARE MODE clause

LOCK DBSPACE statement (7566)

LOCK TABLE statement (7575)

shift-in character

convention (>) (5609)

not truncated by assignments (6088)

representation of DBCS delimiter character X'0F' (5610)

shift-in character 0F

mixed data values (5946)

shift-out character

convention (<) (5606)

representation of DBCS delimiter character X'0E' (5607)

shift-out character 0E

mixed data values (5945)

short identifier (5865)

short string

column (5916)

single-byte character in LIKE predicates (6426)

single precision floating-point (5975)

SINGLE ROW clause

of Extended PREPARE statement (7697)

single row select (7828)

small integer

definition (5972)

SMALLINT

data type (6712), (6978)

SOME

in a quantified predicate (6385)

sort specification

DB2 Server for VSE & VM equivalent term (8600)

space (5845)

special character (5838)

special register

CCSID (5814)

CURRENT DATE (6153)

CURRENT SERVER (6155)

CURRENT TIME (6157)

CURRENT TIMESTAMP (6159)

CURRENT TIMEZONE (6161)

description (6149)

USER (6151)

special_register

in IN predicate (6406)

in INSERT statement (7512)

SQL communication area (SQLCA)

contents (7976)

entry changed by UPDATE (7879)

INCLUDE statement (7486)

INSERT statement (7528)

PUT statement (7727)

SQL descriptor area (SQLDA)

contents (8020)

DESCRIBE statement (7164)

EXECUTE statement (7280)

Extended EXECUTE statement (7294)

Extended PREPARE statement (7700)

FETCH statement (7377)

INCLUDE statement (7487)

LABEL ON statement (7555)

maximum size (7970)

OPEN statement (7611)

PUT statement (7725)

SQL identifier (5855)

SQLABC field of SQLCA (7986)

SQLAID field of SQLCA (7984)

SQLCABC field of SQLCA (7985)

SQLCAID field of SQLCA (7983)

SQLCOD field of SQLCA (7988)

SQLCODE

+100 (7370), (7520), (7829), (7928)

description (6660)

field of SQLCA (7987)

negative (7923)

positive (7926)

statement execution (6634)

SQLD field of SQLDA (7152), (8041)

SQLDA (8021) See also SQL descriptor area (SQLDA)

CCSID values in SQLDATA field (8070)

CCSID values in SQLNAME field (8069)

date field length (5987)

SQLLEN field values for host variables (8068)

SQLTYPE field values for host variables (8067)

time field length (5992)

timestamp field length (5999)

SQLDABC field of SQLDA (7151), (8039)

SQLDAID field of SQLDA (7150), (8038)

SQLDATA field of SQLDA (7156), (8046)

SQLDS communication protocol (5781)

SQLER fields of SQLCA (7999), (8002)

SQLERL field of SQLCA (7990)

SQLERM field of SQLCA (7993)

SQLERP field of SQLCA (7996)

SQLERR(n) fields of SQLCA (7998), (8001)

SQLERRD(3)

CLOSE statement (6796)

DELETE statement (7129)

INSERT statement (7527)

UPDATE statement (7883)

SQLERRD(n) fields of SQLCA (7997), (8000)

SQLERRMC field of SQLCA (7992)

SQLERRML field of SQLCA (7989)

SQLERROR clause

of WHENEVER statement (7914), (7922)

SQLERRP field of SQLCA (7995)

SQLIND field of SQLDA (7157), (8048)

SQLINIT EXEC

CONNECT statement (6860)

SQLLEN field of SQLDA (7155), (8044)

SQLN field of SQLDA (7149), (8040)

SQLNAME field of SQLDA (7158), (8055)

SQLOPTION column (8194)

of SYSOPTIONS (8470)

SQLSTATE

'02000' (7371), (7521), (7830), (7929)

description (6661)

SQLSTATE field of SQLCA (8007)

SQLSTT field of SQLCA (8008)

SQLTXL field of SQLCA (7991)

SQLTXT field of SQLCA (7994)

SQLTYPE field of SQLDA (7154), (8043)

SQLVAR array of SQLDA (8042)

SQLVAR field of SQLDA (7153)

SQLWARN fields of SQLCA (8003), (8005)

SQLWARN0

WHENEVER statement (7925)

SQLWARN3

FETCH statement (7378)

SELECT INTO statement (7841)

SQLWARN6

DELETE statement (7127)

INSERT statement (7526)

UPDATE statement (7890)

SQLWARNING clause

of WHENEVER statement (7915), (7924)

SQLWRN fields of SQLCA (8004), (8006)

statement

binding (5619)

executable (6620)

explainable (7353)

invocation (6622)

maximum length (7962)

nonexecutable (6623), (6636)

preparation (5617)

statement_name

description (5892)

in DECLARE CURSOR statement (7058), (7068)

in DESCRIBE statement (7144)

in EXECUTE statement (7268), (7271)

in PREPARE statement (7643), (7646)

length limitation (7943)

statement_variable

in Extended EXECUTE statement (7288)

statements

ACQUIRE DBSPACE (6664), (6681)

ALLOCATE CURSOR (6683), (6686)

ALTER DBSPACE (6689), (6696), (6699)

ALTER PROCEDURE (6700)

ALTER PSERVER (6702), (6703)

ALTER TABLE (6705), (6770)

ASSOCIATE LOCATORS (6773), (6776)

BEGIN DECLARE SECTION (6778), (6786)

CALL (6789), (6790)

CLOSE (6792), (6797)

CLOSE, Extended (6799), (6806)

COMMENT ON (6810), (6824)

COMMENT ON PROCEDURE (6826)

COMMIT (6838), (6850)

CONNECT (for VM) (6852), (6863)

CONNECT (for VSE) (6875)

CREATE INDEX (6877), (6892)

CREATE PACKAGE (6893), (6943)

CREATE PROCEDURE (6946), (6947)

CREATE PSERVER (6949), (6950)

CREATE SYNONYM (6952), (6960)

CREATE TABLE (6962), (7032)

CREATE VIEW (7034), (7046)

DECLARE CURSOR (7048), (7074)

DECLARE CURSOR, Extended (7075), (7093)

DELETE (7097), (7133)

DESCRIBE (7135), (7165)

DESCRIBE, extended (7181)

DESCRIBE, Extended (7167)

DESCRIBE CURSOR (7185), (7189)

DESCRIBE PROCEDURE (7191), (7195)

description (6771), (6798), (6944), (7166), (7182) , (7239), (7297), (7340), (7360), (7387) , (7398), (7496), (7531), (7557), (7636) , (7685), (7743), (7892)

DROP (7197), (7238)

DROP PROCEDURE (7241), (7242)

DROP PSERVER (7244), (7245)

DROP STATEMENT (7246), (7256)

END DECLARE SECTION (7259), (7262)

EXECUTE (7265), (7282)

EXECUTE, Extended (7284), (7296)

EXECUTE IMMEDIATE (7300), (7339)

EXPLAIN (7342), (7359)

FETCH (7362), (7386)

FETCH, Extended (7388), (7397)

GRANT (Package Privileges) (7401), (7414)

GRANT (System Authorities) (7416), (7437)

GRANT (Table Privileges) (7439), (7480)

INCLUDE (7482), (7495)

INCLUDE SQLCA (8010), (8013), (8014), (8016), (8018)

INCLUDE SQLDA (8071), (8074), (8076)

INSERT (7497), (7530)

inserting into a program (7489)

LABEL ON (7533), (7556)

LOCK DBSPACE (7559), (7570)

LOCK TABLE (7572), (7582), (7583), (7584)

OPEN (7586), (7624)

OPEN, Extended (7625), (7635)

PREPARE (7639), (7684)

PREPARE, Extended (7686), (7704)

PUT (7708), (7730)

PUT, Extended (7731), (7742)

REVOKE (Package Privileges) (7746), (7758)

REVOKE (System Authorities) (7760), (7776)

REVOKE (Table Privileges) (7778), (7811)

ROLLBACK (7812), (7824)

SELECT INTO (7827), (7844)

UPDATE (7847), (7891)

UPDATE STATISTICS (7894), (7911)

WHENEVER (7913), (7934)

static select

DECLARE CURSOR statement (6647)

FETCH statement (6649)

OPEN statement (6648)

static SQL (5621)

invocation (6628)

statement (5623)

STATISTICS keyword

in UPDATE STATISTICS statement (7895)

STATUS column (8190)

of SYSKEYS (8455)

STMT column (8121)

STNAME column (8210)

of SYSTABAUTH (8517)

STOP clause

of WHENEVER statement (7916), (7933)

storage pool

nonrecoverable (7887)

recoverable (7885)

stored procedures

using the DECLARE CURSOR statement (7071)

STORPOOL clause

description (6680)

of ACQUIRE DBSPACE statement (6679)

str (5616)

string

variable

fixed-length (5927)

assignment

conversion rules (6090)

trailing blanks (6070)

column

CCSID (5816)

comparison (6117)

constant

CCSID (5813)

character (6134)

graphic (6145)

hexadecimal (6139)

definition (5793)

empty (5910)

expression (6260)

operand (6262)

padding (6072)

truncation (6078)

variable

varying-length (5928)

string_constant

in LIKE predicate (6420)

STRIP

function (6523)

STRUCTURE clause

of EXPLAIN statement (7349)

STRUCTURE_TABLE

EXPLAIN statement (7358)

SUBBYTE column (8202)

of SYSSTRINGS (8497)

subfield

of a structure (6210)

subquery

description (6184)

HAVING clause (6593)

in a basic predicate

ISO-ANS SQL(89) equivalent term (8617)

in DELETE statement (7103)

in UPDATE statement (7852)

subselect (6554)

WHERE clause (6617)

subselect (7866)

description (6183), (6543), (6595)

FROM clause (6550)

GROUP BY clause (6552)

HAVING clause (6553)

in a basic predicate (6369)

in a quantified predicate (6384)

in CREATE VIEW statement (7041)

in EXISTS predicate (6402)

in fullselect (6597)

in INSERT statement (7513), (7519)

in parentheses

ISO-ANS SQL(89) equivalent term (8619)

ISO-ANS SQL(89) equivalent term (8618)

quantified predicate (6382)

SELECT clause (6549)

WHERE clause (6551)

substitution character (5804)

SUBSTR

function (6525), (6526)

substring (6527)

subsystemid

in GRANT statement (7422), (7433)

in REVOKE statement (7767), (7774)

subtype

SQLDA (8053)

SUBTYPE column (8116), (8147)

in CREATE TABLE (7003)

of SYSCCSIDS (8293)

of SYSCOLUMNS (8352)

SUM function (6476)

synonym

defining (6953)

description (5893)

dropping (7222)

in DROP statement (7203), (7224)

qualifying a column name (6173)

SYNONYM clause

of DROP statement (7209), (7223)

syntax diagram

notation conventions (5588)

SYSACCESS catalog table (8249), (8262)

SYSCATALOG catalog table (8264), (8288)

SYSCCSIDS catalog table (8290), (8297)

SYSCHARSETS catalog table (8299), (8304)

SYSCOLAUTH catalog table (8306), (8314)

SYSCOLSTATS catalog table (8316), (8328)

SYSCOLUMNS catalog table (8330), (8355)

SYSDBSPACES catalog table (8357), (8371)

of SYSDBSPACES (8369)

SYSDROP catalog table (8373), (8378)

SYSFIELDS catalog table (8380), (8392)

SYSFPARMS catalog table (8394), (8402)

SYSINDEXES catalog table (8404), (8426)

SYSKEYCOLS catalog table (8428), (8442)

SYSKEYS catalog table (8444), (8457)

SYSLANGUAGE catalog table (8459), (8465)

SYSLENGTH column (8138)

of SYSCOLUMNS (8342)

of SYSKEYCOLS (8438)

SYSOPTIONS catalog table (8467), (8473)

SYSPARMS catalog table (8475)

SYSPROGAUTH catalog table (8477), (8485)

SYSPSERVERS catalog table (8487)

SYSROUTINES catalog table (8489)

SYSSTRINGS catalog table (8491), (8501)

SYSSYNONYMS catalog table (8503), (8509)

SYSTABAUTH catalog table (8511), (8530)

SYSTEM

owner of catalog tables (8240)

SYSUSAGE catalog table (8532), (8541)

SYSUSERAUTH and SYSUSERLIST catalog table (8543), (8555)

SYSUSERLIST view on SYSUSERAUTH (8545)

SYSUSERLIST (8547)

SYSVIEWS catalog table (8557), (8565)

TABID column (8083)

of SYSACCESS (8254)

of SYSCATALOG (8273)

of SYSDROP (8376)

table

changing

ALTER TABLE (6706)

creating (6963)

definition (5640)

designator (6176)

dropping (7199), (7226)

maximum byte count (7952)

maximum number in a relational database (7974)

maximum number referenced in a statement (7958)

maximum number referenced in a view (7959)

primary key (5655)

temporary (7617)

TABLE clause

of COMMENT ON statement (6816)

of DROP statement (7206), (7227)

of LABEL ON statement (7539), (7545)

table description, key (5652)

table designator

FROM clause (6177)

table expression

DB2 Server for VSE & VM equivalent term (8601)

table_id

description (5894)

table_name

description (5895)

in ALTER TABLE statement (6710), (6732), (6743)

in COMMENT ON PROCEDURE statement (6829)

in COMMENT ON statement (6813)

in CREATE INDEX statement (6879), (6886)

in CREATE SYNONYM statement (6954), (6957)

in CREATE TABLE statement (6969), (6974), (7014)

in DELETE statement (7104)

in DROP statement (7200), (7228)

in FROM clause (6581)

in GRANT statement (7451), (7473)

in INSERT statement (7503), (7515)

in LABEL ON statement (7540), (7546)

in REVOKE statement (7789), (7803)

in subselect (6558)

in UPDATE statement (7854), (7864)

in UPDATE STATISTICS statement (7899), (7905)

length limitation (7946)

table-name

in DELETE statement (7113)

TABLEORD column (8184)

of SYSKEYCOLS (8436)

TABLETYPE column (8091)

of SYSCATALOG (8268)

TABTYPE column (8088)

of SYSACCESS (8259)

target specification

DB2 Server for VSE & VM equivalent term (8602)

TCREATOR column (8211)

of SYSKEYCOLS (8431)

of SYSKEYS (8447)

of SYSTABAUTH (8518)

temporary tables in OPEN (7616)

terminating

logical unit of work (LUW) (6842), (7816)

termination

COMMIT statement (6848)

description (6849)

text_file_name with INCLUDE statement (7488)

time (5993)

arithmetic (6339)

arithmetic operations

duration (6341)

assignment (6094)

data type

description (5991)

in ALTER TABLE (6725)

in CREATE TABLE (6992)

data type

duration (6332)

function (6529)

representation, internal & SQLDA (5994)

string (6015)

TIME

TIME option

of CREATE PACKAGE statement (6939)

timestamp (5997)

arithmetic operations (6342)

assignment (6100)

data type

description (5996)

in ALTER TABLE (6726)

in CREATE TABLE (6993)

data type

duration (6334)

function (6531)

representation, internal & SQLDA (5998)

string (6021)

TIMESTAMP

TIMESTAMP column (8086)

of SYSACCESS (8257)

of SYSCOLAUTH (8312)

of SYSKEYCOLS (8439)

of SYSKEYS (8456)

of SYSPROGAUTH (8483)

of SYSTABAUTH (8520)

of SYSUSAGE (8540)

TLABEL column (8111)

LABEL ON statement (7548)

of SYSCATALOG (8284)

TNAME column (8080)

of SYSACCESS (8251)

of SYSCATALOG (8266)

of SYSCOLAUTH (8311)

of SYSCOLSTATS (8319)

of SYSCOLUMNS (8333)

of SYSFIELDS (8383)

of SYSFPARMS (8398)

of SYSINDEXES (8408)

of SYSKEYCOLS (8430)

of SYSKEYS (8446)

of SYSSYNONYMS (8508)

TO clause

of CONNECT statement (6857), (6869)

of GRANT statement (7405), (7453), (7475)

token

delimiter (5843)

description (5840), (5853)

ordinary (5841)

trailing blanks

string assignment (6071)

transaction

DB2 Server for VSE & VM equivalent term (8603)

TRANSLATE

function (6533)

TRANSPROC column (8203)

of SYSSTRINGS (8498)

TRANSTAB1 column (8204)

of SYSSTRINGS (8499)

TRANSTAB2 column (8205)

of SYSSTRINGS (8500)

TRANSTYPE column (8200)

of SYSSTRINGS (8495)

truncation

numbers (6049)

on output (8584)

string (6079)

truth table (6447)

truth valued logic (6444)

TTNAME column (8212)

of SYSTABAUTH (8519)

types of locks (5747)

unary

minus (6273)

plus (6272)

uncommitted read

isolation level (5765)

undefined reference

column name (6182)

underscore (_)

in LIKE predicate (6422)

UNION ALL clause

of fullselect (6599)

UNION clause

duplicate rows (6600)

of fullselect (6598)

UNIQUE clause

of ALTER TABLE statement (6748)

of CREATE INDEX statement (6881)

of CREATE TABLE statement (6996), (7019)

unique constraint

description (5673)

key (5650)

unique index (5660)

unit of work

ISO-ANS SQL(89) equivalent term (8613)

Universal Coordinated Time (UTC) (6162)

unnamed column

ORDER BY clause (6609)

update

assignment rules (6035)

isolation level (5751)

on view (5728)

UPDATE

UPDATE clause

of GRANT statement (7448), (7470)

of REVOKE statement (7787), (7801)

of select-statement (6615)

update rule

description (5713)

UPDATE statement

description (7846)

EXECUTE IMMEDIATE statement (7336)

EXPLAIN statement (7345)

Extended DECLARE CURSOR statement (7092)

FETCH statement (7384)

OPEN statement (7621)

Positioned UPDATE form (7850)

PREPARE statement (7674)

Searched UPDATE form (7851)

UPDATE STATISTICS statement

description (7893)

EXECUTE IMMEDIATE statement (7337)

PREPARE statement (7675)

UPDATEAUTH column (8216)

of SYSTABAUTH (8524)

UPDATECOLS column (8213)

of SYSTABAUTH (8521)

uppercase (5832), (5849)

UR attribute

isolation level (5763)

isolation option

CREATE PACKAGE statement (6915)

USA (IBM USA standard)

format (6017)

USA attribute

DATE option

CREATE PACKAGE statement (6906)

user

CONNECT statement (6853), (6865)

isolation level (5774)

USER

USER attribute

isolation option

CREATE PACKAGE statement (6916)

user ID (8227)

COMMIT statement (6844)

ROLLBACK statement (7820)

USER keyword

in LIKE predicate (6416)

USER special register (6150)

USERID column (8206)

of SYSSYNONYMS (8505)

using AMODE(24)

incompatibilities (8661)

USING clause

of DESCRIBE statement (7139), (7163)

of EXECUTE statement (7272)

of Extended DESCRIBE statement (7174)

of OPEN statement (7594), (7604)

USING DESCRIPTOR clause

of EXECUTE statement (7279)

of Extended EXECUTE statement (7292)

of Extended FETCH statement (7393)

of Extended OPEN statement (7631)

of Extended PREPARE statement (7695)

of Extended PUT statement (7738)

of FETCH statement (7369), (7376)

of OPEN statement (7595), (7609)

of PUT statement (7715), (7723)

USING OPTIONS clause

of CREATE PACKAGE statement (6898)

USING OUTPUT DESCRIPTOR clause

of Extended EXECUTE statement (7293)

UTC (Universal Coordinated Time) (6163) See also Universal Coordinated Time (UTC)

VAL10 column (8127)

of SYSCOLSTATS (8321)

VAL50 column (8128)

of SYSCOLSTATS (8322)

VAL90 column (8129)

of SYSCOLSTATS (8323)

VALID column (8087)

of SYSACCESS (8258)

value

function (6535)

in tables (5642)

interpreting by data type (5901)

VALUE

VALUE column (8195), (8233)

of SYSOPTIONS (8471)

value expression

DB2 Server for VSE & VM equivalent term (8604)

VALUES clause

of INSERT statement (7506), (7518)

VARCHAR

data type (6719), (6986)

VARGRAPHIC

data type (6722), (6989)

function

shift-in (6538)

shift-out (6539)

varying-length

character string (5918)

graphic string (5964)

VCREATOR column (8235)

of SYSVIEWS (8560)

view

CREATE VIEW statement (7036)

creating (7035)

description (5726), (7045)

dropping (7231)

read-only (7044)

VIEW clause

of DROP statement (7207), (7232)

view_id

description (5896)

view_name

description (5897), (6959)

in COMMENT ON PROCEDURE statement (6830)

in COMMENT ON statement (6814)

in CREATE SYNONYM statement (6955), (6958)

in CREATE VIEW statement (7037)

in DELETE statement (7105), (7114)

in DROP statement (7201), (7233)

in FROM clause (6580)

in GRANT statement (7452), (7474)

in INSERT statement (7504), (7516)

in LABEL ON statement (7541), (7547)

in REVOKE statement (7790), (7804)

in subselect (6559)

in UPDATE statement (7855), (7865)

length limitation (7947)

VIEWCHECK column (8239)

of SYSVIEWS (8564)

VIEWMAT column (8238)

of SYSVIEWS (8563)

VIEWNAME column (8234)

of SYSVIEWS (8559)

VIEWTEXT column (8237)

of SYSVIEWS (8562)

VSE guest

GRANT statement (7435)

WHENEVER statement (7912), (7935)

WHERE clause

maximum number of predicts (7964)

of DELETE statement (7110), (7116)

of SELECT INTO statement (7833), (7838)

of subselect (6546), (6583)

of UPDATE statement (7860), (7871)

WHERE CURRENT OF clause

of DELETE statement (7111), (7120)

Extended DECLARE CURSOR statement (7089)

of UPDATE statement (7862), (7873), (7876)

Extended DECLARE CURSOR statement (7090)

WITH CHECK OPTION clause

INSERT statement (7523)

of CREATE VIEW statement (7042)

UPDATE statement (7881)

WITH clause

of DELETE statement (7119)

of subselect (6618)

of UPDATE statement (7874)

WITH GRANT OPTION clause

of GRANT statement (7408), (7412), (7456), (7478)

WITH RETURN

in DECLARE CURSOR statement (7070)

WORK keyword

COMMIT statement (6839)

ROLLBACK statement (7817)

YEAR

function (6541)

labeled duration (6240), (6311)

YEARS

labeled duration (6241)

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