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

* (asterisk)

in subselect column names (6781)

naming columns, use in select (6780)

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

ABS or ABSVAL function (6066)

detailed format description (6373)

values and arguments, rules for (6374)

ACOS function (6068)

detailed format description (6376)

values and arguments, rules for (6377)

ADD clause in ALTER TABLE (6980)

ADD column clause, order of processing (7005)

alias

comment descriptions, adding to catalog (7061)

CREATE ALIAS statement (7138)

deleting, using DROP statement (7412)

description (5188), (5504)

TABLE_NAME function (6683)

TABLE_SCHEMA function (6686)

ALIAS clause

COMMENT ON statement (7072)

DROP statement (7420)

alias-name (5454)

ALL clause

SELECT statement, use in (6776), (6839)

ALL in quantified predicate (6015)

ALL option

comparison, set operator, effect on (6876)

ALL PRIVILEGES clause

GRANT statement (table or view) (7545)

REVOKE statement, table and view privileges (7710)

ALTER BUFFERPOOL statement (6951), (6958)

ALTER clause

GRANT statement (table or view) (7546)

REVOKE statement, removing privilege for (7711)

ALTER NODEGROUP statement (6960), (6967)

ALTER TABLE statement (7011)

authorization required, summary (6969)

examples of usage (7009)

syntax diagram (6978)

ALTER TABLESPACE statement (7012), (7016)

ALTER TYPE (Structured) statement (7018), (7024)

ALTER VIEW statement (7032)

authorization required, summary (7026)

syntax diagram (7027)

ambiguous cursor (7374)

ambiguous reference, error conditions for (5854)

AND truth table (6055)

ANY in quantified predicate (6014)

application process, definition of (5286)

application program

concurrency (5288)

uses SQLDA (7894)

application requester, overview (5319)

application server

overview (5320)

role of in connections (5327)

arguments of COALESCE

result data type (5751)

arithmetic

AVG function, operation of (6309)

columns, adding values (SUM) (6356)

constants

definition of (5769)

NOT NULL, required attribute for (5770)

date operations, rules for (5970)

datetime, SQL rules for (5962)

decimal operations, scale and precision formulas (5940)

decimal value, precision and scale (5616)

decimal values from numeric expressions (6452)

distinct type operands (5946)

expressions, adding values (SUM) (6355)

floating point operands

rules and precision values (5943)

with integers, result of (5944)

floating point values from numeric expressions (6504), (6633)

floating point, range and precision (5615)

integer

large integer, range and precision (5614)

small integer, range and precision (5613)

integer values, returning from expressions (6394), (6542)

maximum value, finding (6333)

minimum value, finding (6343)

operators, summary of results (5921)

parameter marker, syntax and operations (7658)

remote use of, conversions, overview (5352)

small integer values, returning from expressions (6663)

STDDEV function, operation of (6350)

time operations, rules for (5971), (5974)

timestamp operations, rules for (5976)

unary minus sign, effect on operand (5927)

unary plus sign, effect on operand (5926)

VARIANCE function, operation of (6365)

AS clause

CREATE VIEW statement (7330)

in SELECT clause (6774), (6795)

ORDER BY clause (6891)

ASC clause

CREATE INDEX statement (7196)

of select-statement (6896)

ASCII function (6070)

detailed format description (6379)

values and arguments, rules for (6380)

ASIN function (6072)

detailed format description (6382)

values and arguments, rules for (6383)

Assembler application host variable (7470)

assigning a string to a column, rules for (5705)

assignments

character strings to datetime columns, rules for (5689)

DATALINK type (5721)

datetime to character string value (5719)

datetime values, rules for (5717)

fragmenting a MBCS character, rules for (5714)

mixed character string blank padding (5712)

mixed character string to host variables (5711)

mixed character string truncation (5713)

numbers (5701)

reference type (5723)

retrieval (5707)

storage (5706), (5994)

strings, basic rules for (5703)

user-defined type (5722)

asterisk (*)

in COUNT (6319)

in COUNT_BIG (6330)

in subselect column names (6779)

ATAN function (6074)

detailed format description (6385)

values and arguments, rules for (6386)

ATAN2 function (6076)

detailed format description (6388)

values and arguments, rules for (6389)

attribute-name (5455)

in dereference operation (6003)

authority level

authorization name, syntax rules for (5457)

authorization

definition (5367)

granting control on database operations (7503)

granting control on index (7520)

granting create on schema (7533)

public control on index (7521)

public create on schema (7534)

authorization ID, overview of (5505)

authorization-name

restrictions governing (5456)

use of in Grant and Revoke (5512)

AVG function (6078)

AVG function, detailed description (6311)

base table (5182)

basic operations in SQL (5681)

basic predicate, detailed format (6006)

BEGIN DECLARE SECTION statement (7033), (7041)

authorization required (7037)

invocation rules for (7036)

BETWEEN predicate, detailed format diagram (6017)

big integers (5600)

BIGINT data type (7227)

description (5597)

precision (5598)

range (5599)

BIGINT function (6080)

BIGINT function, integer values from expressions (6393)

binary integer, as data type (5529)

Binary Large OBject (5545) See also BLOB

BINDADD parameter, GRANT...ON DATABASE statement (7504)

binding (7526)

bound statement, overview of (5331)

data retrieval, role in optimizing (5141)

revoking all privileges (7690)

bit data

BLOB string (5548)

definition (5567)

blank (5411)

blanks

definition of (5407)

BLOB

data type (7240)

scalar function description (6396)

string (5544)

BLOB function (6082)

bound statement, use of (5329)

buffer insert (7602)

buffer pool

deleting, using DROP statement (7414)

description (5387)

extended storage use (6955), (6956), (7152)

page size (7151)

setting size (6954), (7149)

bufferpool

naming conventions (5458)

BUFFERPOOL clause

ALTER TABLESPACE statement (7015)

CREATE TABLESPACE statement (7306)

DROP statement (7424)

built-in function (6063) See also function

description (5893)

byte length values, list for data types (6556)

caching

EXECUTE statement (7458)

call level interface (5158)

CALL statement (7042), (7045)

cancelling a unit of work (7734)

CASCADE delete rule (7266)

description (5255)

case

expression (5984)

case sensitive identifiers, SQL (5427)

CAST

expression as operand (5989)

NULL as operand (5991)

parameter marker as operand (5993)

CAST specification (5987)

casting

between data types (5672)

reference types (5676)

user-defined types (5674)

catalog

adding comments on tables, views, columns (7057)

COMMENT ON, detailed syntax (7056)

catalog views

BUFFERPOOLNODES (7918)

BUFFERPOOLS (7917)

CHECKS (7919)

COLAUTH (7920)

COLCHECKS (7921)

COLDIST (7922)

COLUMNS (7923)

CONSTDEP (7924)

DATATYPES (7925)

DBAUTH (7926)

definition (5284)

EVENTMONITORS (7927)

EVENTS (7928)

FUNCPARMS (7929)

FUNCTIONS (7930)

INDEXAUTH (7931)

INDEXES (7932)

KEYCOLUSE (7933)

NODEGROUPDEF (7934)

NODEGROUPS (7935)

overview (7913)

PACKAGEAUTH (7936)

PACKAGEDEP (7937)

PACKAGES (7938)

PARTITIONMAPS (7939)

PROCEDURE PARAMETERS (7941)

PROCEDURES (7940)

read-only (7916), (7967)

REFERENCES (7942)

SCHEMAAUTH (7943)

SCHEMATA (7944)

STATEMENTS (7945)

SYSSTAT.COLUMNS (7958)

SYSSTAT.FUNCTIONS (7959)

SYSSTAT.INDEXES (7960)

SYSSTAT.TABLES (7961)

TABAUTH (7946)

TABCONST (7947)

TABLES (7948)

TABLESPACES (7949)

TRIGDEP (7950)

TRIGGERS (7951)

updatable (7915)

VIEWDEP (7952)

VIEWS (7953)

catalog views (structured types)

ATTRIBUTES (7968)

CHECKS (7969)

COLCHECKS (7970)

COLUMNS (7971)

CONSTDEP (7972)

DATATYPES (7973)

FUNCPARMS (7974)

FUNCTIONS (7975)

HIERARCHIES (7976)

INDEXES (7977)

KEYCOLUSE (7978)

OBJSTAT.TABLES (7986)

overview (7964)

PACKAGEDEP (7979)

REFERENCES (7980)

TABCONST (7981)

TABLES (7982)

TRIGDEP (7983)

TRIGGERS (7984)

updatable (7966)

VIEWDEP (7985)

CEIL or CEILING function (6084)

CEIL or CEILINGfunction

detailed format description (6398)

values and arguments, rules for (6399)

CHAR

function description (6403)

CHAR function (6086), (6088)

CHAR VARYING data type (7237)

character conversion

character set (5357)

code page (5359)

code point (5361)

encoding scheme (5363)

rules for assignments (5710)

rules for comparison (5734)

rules for operations combining strings (5757)

rules when comparing strings (5759)

CHARACTER data type (7234)

Character Large OBject (5539) See also CLOB string

character set (5358)

character string

arithmetic operators, prohibited use of (5922)

as data type (5524)

assignment, overview (5702)

bit data

definition (5566)

BLOB string representation (6397)

CLOB (5540)

comparisons, rules for (5728)

constants, range and precision (5783)

detailed description (5553)

double byte character string, returning (6740)

empty, compared to null value (5556)

equality, collating sequence examples (5733)

equality, definition of (5732)

fixed length (5525)

fixed length, description (5560)

hexadecimal constant (5786)

mixed data (5570)

POSSTR scalar function (6612)

returning from host variable name (6712)

SBCS data, definition (5568)

SQL statement string, rules for creating (7472)

SQL statement, execution as (7465)

translating string syntax (6711)

VARCHAR scalar function, using (6735)

VARGRAPHIC scalar function, using (6739)

varying length (5526)

varying length, description (5561)

CHARACTER VARYING data type (7236)

characters, SQL, range of (5406)

CHECK clause in CREATE VIEW statement (7341)

check constraint

ALTER TABLE statement (6989), (6995)

CREATE TABLE statement (7274)

INSERT statement (7599)

check pending state (5263), (7763)

CHR function (6090)

detailed format description (6408)

values and arguments, rules for (6409)

CL_SCHED sample table (7994)

client/server

server name, description of (5483)

CLOB data type (7241)

CLOB function (6092)

detailed format description (6411)

values and arguments, rules for (6412)

CLOB string (5538)

CLOSE statement (7047), (7052)

closed state of cursor (7638)

CLUSTER clause

CREATE INDEX statement (7199)

COALESCE

function description (6415)

COALESCE function (6094)

code page (5360)

code point (5362)

collating sequence, string comparison, rules for (5730)

column

adding to a table, ALTER TABLE (6981)

adding values (SUM) (6357)

adding with ALTER TABLE statement (6970)

adding, privileges for, granting (7547)

ambiguous name reference, error conditions (5852)

averaging a column set of values (AVG) (6310)

BASIC predicate, use in matching strings (6011)

BETWEEN predicate, use in matching strings (6020)

column name, qualified, conditions for (5868)

column name, unqualified, conditions for (5869)

comment descriptions, adding to catalog (7060)

constraint name, FOREIGN KEY, rules (7263)

definition of (5175), (5177)

DISTINCT keyword, queries, role of (6303)

EXISTS predicate, use in matching strings (6022)

fixed length character strings, attributes (5558)

GROUP BY, use in limiting in SELECT clause (6787)

grouping column name, use in GROUP BY (6833)

HAVING clause, search names, rules for (6853)

HAVING, use in limiting in SELECT clause (6788)

IN predicate, fullselect, values returned (6029)

index key, column-name, use in (7194)

inserting values, INSERT statement (7589)

LIKE predicate, use in matching strings (6030)

maximum value, finding (6335)

minimum value, finding (6342)

naming conventions (5460)

naming conventions, applications of

in CREATE INDEX statement (5831)

in CREATE TABLE statement (5830)

in expressions (5833)

in GROUP BY or ORDER BY statements (5832)

nested table expression, use of (5865)

null values in result columns, rules for (6794)

null values, ALTER TABLE, prevention of (6984)

qualified column names, rules for (5834)

result data, expression type, table of (6798)

scalar fullselect, use of (5862)

searching using WHERE clause (6823)

SELECT clause, select list notation (6767)

standard deviation of a column set of values (STDDEV) (6351)

string assignment, basic rules for (5704)

subquery, use of (5859)

undefined name reference, error conditions (5853)

updating row values, UPDATE statement (7828)

variance of a column set of values (VARIANCE) (6366)

varying length character strings, attributes (5559)

COLUMN clause

COMMENT ON statement (7073)

column function, arguments for (6064)

column name

in ORDER BY clause (6893)

rules for (5459)

column name qualification in the COMMENT ON statement (5837)

column name, uses for (5829)

column options

CREATE TABLE statement (7248)

column-name

in INSERT statement (7590)

combining grouping sets (6851)

comment

SQL static statements, use in (6949)

comment in catalog table (7055)

COMMENT ON statement (7053), (7089)

comments

host language, format for (5425)

SQL, format for (5424)

commit processing

locks, relation to uncommitted changes (5291)

COMMIT statement (7091), (7102)

common table expression (6883)

description (5279)

recursive (6886)

common-table-expression

select-statement (6882)

comparing a value with a collection (6018)

comparing LONG VARGRAPHIC strings, restricted use of (5739)

comparing two predicates, truth conditions (6010), (6044)

comparison

compatibility rules (5687), (5692)

compatibility rules, data types, summary (5688)

datetime values, rules for (5741)

graphic strings, rules for (5740)

LONG VARGRAPHIC, restricted use of (5738)

numbers, rules for (5725)

reference type (5746)

SBCS/MBCS, rules for (5737)

strings, rules for (5729)

user-defined type (5743)

compatibility

data types (5690)

data types, summary (5685)

rules (5691)

rules for operation types (5686)

composite column value (6849)

composite key (5196)

Compound SQL statement (7106)

combining statements into a block (7104)

CONCAT function

detailed format description (6416)

values and arguments, rules for (6417)

CONCAT or || function (6096)

concatenation

distinct type (5918)

operator (5911)

result data type (5915)

result length (5916)

concurrency

application (5287)

prevention of

LOCK TABLE statement (7616)

tables with NOT LOGGED INITIALLY parameter, restriction (7283)

CONNECT parameter, GRANT...ON DATABASE statement (7506)

CONNECT statement

disconnecting from current server (7122)

implicit connect (7112)

IMPLICIT connect, diagram of state transitions (5336)

information on application server, getting (7124)

information on setting a new password (7126)

non-IMPLICIT connect, diagram of state transitions (5338)

overview (5332)

with no operand, returning information (7125)

CONNECT statement (Type 1) (7108), (7128)

CONNECT statement (Type 2) (7130), (7134)

CONNECT TO statement

successful connection, detailed description (7114), (7132)

unsuccessful connection, detailed description (7116), (7133)

connected state (5343)

connection states

application process (5342)

distributed unit of work (5341)

remote unit of work (5335)

constants

character string, range and precision (5784)

decimal (5781)

floating-point, rules for (5774)

hexadecimal (5787)

integer, definition of (5771)

with user-defined types (5789)

constants, overview of (5768)

constraint

comment descriptions, adding to catalog (7062)

Explain tables (8034)

referential (5212), (5222)

table check (5213), (5262)

unique (5211), (5217)

CONSTRAINT clause

COMMENT ON statement (7074)

constraints

adding or dropping, ALTER TABLE (6974)

container

CREATE TABLESPACE statement (7299)

description (5385)

container-clause

CREATE TABLESPACE statement (7303)

CONTINUE clause in WHENEVER statement (7860)

CONTROL clause

GRANT statement (table or view) (7550)

CONTROL clause in GRANT statement, revoking (7712)

CONTROL parameter

revoking privileges for packages (7692)

conversion

character string to executable SQL (7466)

datetime to character string variable (5718)

integer to decimal, mixed expression, rules (5935)

conversion rules

for assignments (5709)

for comparison (5735)

for operations combining strings (5758)

for string comparisons (5760)

conversions

CHAR, returning converted datetime values (6407)

character string to timestamp (6699)

DBCS from mixed SBCS and DBCS (6741)

decimal values from numeric expressions (6453)

double byte character string, returning (6742)

floating point values from numeric expressions (6505), (6634)

numeric, scale and precision, summary (5697)

correlated reference (6829)

correlated reference, use in nested table expression (5864)

correlated reference, use in scalar fullselect (5861)

correlated reference, use in subquery (5858), (5867)

correlation name

FROM clause, subselect, rules for use (6801)

correlation-name

detailed description (5462)

in SELECT clause, syntax diagram (6770)

qualified reference of column name (5840)

correlation-name, rules for (5842)

COS function (6098)

detailed format description (6419)

values and arguments, rules for (6420)

COT function (6100)

detailed format description (6422)

values and arguments, rules for (6423)

COUNT function (6102)

detailed format description (6314)

values and arguments, rules for (6315)

COUNT_BIG function (6104), (6323)

detailed format description (6324)

values and arguments, rules for (6325)

CREATE ALIAS statement (7136), (7142)

CREATE BUFFERPOOL statement (7144), (7154)

CREATE DISTINCT TYPE statement (7156), (7160)

CREATE EVENT MONITOR statement (7162), (7165)

CREATE FUNCTION (External Scalar) statement (7170)

CREATE FUNCTION (External Table) statement (7175)

CREATE FUNCTION (Sourced Scalar) statement (7183)

CREATE FUNCTION (Sourced) statement (7180)

CREATE FUNCTION statement (7167), (7173), (7178)

CREATE INDEX statement (7185), (7201)

column-name, rules for key creation (7195)

CREATE NODEGROUP statement (7203), (7209)

CREATE SCHEMA statement (7211), (7216)

CREATE TABLE statement (7218), (7289)

syntax diagram (7222)

CREATE TABLESPACE statement (7291), (7307)

CREATE TRIGGER statement (7309), (7316)

CREATE TYPE (Structured) statement (7318), (7324)

CREATE VIEW statement (7326), (7353)

CREATE VIEW statement, definition of (5184)

CREATETAB parameter, GRANT...ON DATABASE statement (7508)

creating a database, granting authority for (7515)

cross tabulation rows (6848)

CS (cursor stability) isolation level (5312), (8013)

CUBE (6845)

cube

examples of (6863)

current connection state (5346)

CURRENT DATE special register (5793)

CURRENT DEGREE special register (5795)

SET CURRENT DEGREE statement (7771)

CURRENT EXPLAIN MODE special register (5797)

SET CURRENT EXPLAIN MODE statement (7776)

CURRENT EXPLAIN SNAPSHOT special register (5799)

SET CURRENT EXPLAIN SNAPSHOT statement (7781)

CURRENT FUNCTION PATH special register (5804)

SET CURRENT FUNCTION PATH statement (7803)

SET CURRENT PATH statement (7804)

SET PATH statement (7805)

CURRENT NODE special register (5801)

CURRENT PATH special register (5805)

SET CURRENT FUNCTION PATH statement (7800)

SET CURRENT PATH statement (7801)

SET PATH statement (7802)

CURRENT QUERY OPTIMIZATION special register (5809)

SET CURRENT QUERY OPTIMIZATION statement (7786)

CURRENT REFRESH AGE special register (5811)

CURRENT SCHEMA special register (5813)

CURRENT SERVER special register (5818)

CURRENT SQLID special register (5814)

CURRENT TIME special register (5821)

CURRENT TIMESTAMP special register (5823)

CURRENT TIMEZONE special register (5825)

cursor See also DECLARE CURSOR statement

active set, associated with (7627)

ambiguous (7376)

closed state, pre-conditions for (7637)

closing, CLOSE statement (7049)

current row (7492)

declaring, SQL statement syntax for (7355)

defining (7361)

deleting, search condition details (7387)

location in table, results of FETCH (7485)

moving position, using FETCH (7483)

opening a cursor, OPEN statement (7625)

positions for open (7491)

preparing for application use (7626)

program usage, rules for (7371)

read-only status, conditions for (7373)

result table, relation to (7357)

terminating for unit of work, ROLLBACK (7742)

unit of work, conditional states of (7356)

updatability, determining (7372)

WITH HOLD lock clause, COMMIT statement, effect (7101)

cursor stability (5311), (8022)

cursor-name, definition of (5463)

data integrity

concurrent updates, preventing, LOCK TABLE (7620)

point of consistency, example of (5295)

data representation considerations (5351)

data structure

column, definition of (5181)

constants

character string, rules for (5779)

decimal, rules for (5778)

floating point, rules for (5777)

graphic string (DBCS), rules for (5780)

integer, rules for (5776)

date syntax and range (5628)

index, derived values of (5191)

numeric data, overview (5582)

packed decimal (7912)

row, definition of (5180)

time syntax and range (5630)

value, definition of (5179)

values

data types (5523)

sources (5522)

data type (5763)

abstract (7022), (7322)

ALTER TYPE (Structured) statement (7020)

character string (5554)

CREATE TYPE (Structured) statement (7320)

datalink (5658)

datetime (5626)

distinct (5662), (7159)

overview (5516)

partition compatibility (5764)

reference (5668)

result column data, SELECT, table of (6799)

result columns (6797)

row (7021), (7321)

structured (5666), (7023), (7323)

TYPE_ID function (6720)

TYPE_NAME function (6723)

TYPE_SCHEMA function (6726)

user-defined (5660)

data types

casting between (5673)

promotion (5671)

database access

authority to access database, granting (7507)

database administration privilege (5372)

database identifier in SQL (5448)

database managed space (5381) See also DMS table space

database management

control, granting authority, SQL statement for (7502)

DBADM creation authority, granting (7514)

saving changes, COMMIT statement (7097)

switching tasks, COMMIT statement (7098)

database manager

catalog views

overview of (5285)

distributed relational database, use in (5324)

limits (7866)

SQL, interpretation of (5140)

database manager limits (7876)

database manager page size specific limits (7878)

database-containers

CREATE TABLESPACE statement (7302)

datalink

building (6499)

extracting comment (6471)

extracting complete URL (6479)

extracting file server (6495)

extracting linktype (6475)

extracting path and file name (6483), (6487)

extracting scheme (6491)

INSERT statement (7601)

datalink type

description (5657)

DATE

date

arithmetic operations (5964)

CHAR, use of in format conversion (6404)

day durations, finding from range (DAYS) (6445)

day, returning from value (DAY function) (6432)

duration, format of (5955)

month, returning from datetime value (6595)

strings (5636)

value to date, format conversion (DATE) (6428)

WEEK scalar function, using (6747)

year, using in expressions (6752)

DATE data type (7244)

DATE function (6106)

DATE function, returning dates from values (6427)

datetime

arithmetic operations (5961)

data types

description (5627)

string representation (5634), (5635)

format

EUR, ISO, JIS, LOCAL, USA (5637)

limits (7874)

VARCHAR scalar function, using (6736)

datetime format (5643)

DAY function (6108)

DAY function, returning day part of values (6431)

DAYNAME function (6110)

detailed format description (6433)

values and arguments, rules for (6434)

DAYOFMONTH function (6112)

DAYOFWEEK function (6114)

detailed format description (6436)

values and arguments, rules for (6437)

DAYOFYEAR function (6116)

detailed format description (6439)

values and arguments, rules for (6440)

DAYS function (6118)

DAYS function, returning integer durations (6444)

DB2 library

books (8058)

Information Center (8067)

language identifier for books (8059)

late breaking information (8060)

online help (8057)

ordering printed books (8066)

printing PostScript books (8065)

searching online books (8064)

setting up document server (8062)

SmartGuides (8056)

structure of (8055)

viewing online books (8061)

db2nodes.cfg

ALTER NODEGROUP (6966)

CONNECT (Type 1) (7127)

CREATE NODEGROUP (7206)

CURRENT NODE (5803)

NODENUMBER function (6603)

DBADM parameter, GRANT...ON DATABASE statement (7513)

DBCLOB data type (7242)

DBCLOB function (6120)

detailed format description (6446)

values and arguments, rules for (6447)

DBCLOB string (5542)

decimal

arithmetic formulas, scale and precision (5939)

constants, range and precision (5782)

data type, overview (5618)

implicit decimal point (5620)

numbers (5617)

packed decimal (5619)

decimal conversion from integer, summary (5699)

DECIMAL function, returning decimal values (6451)

DECIMAL or DEC function (6122), (6124)

decimal, as data type (5531)

declaration

inserting into a program (7576)

DECLARE

BEGIN DECLARE SECTION statement (7035)

END DECLARE SECTION statement (7441)

DECLARE CURSOR statement (7358), (7360), (7377)

authorization, conditions for (7362)

program usage, notes for (7370)

decrementing a date, rules for (5966)

decrementing a time, rules for (5973)

default value

column

ALTER TABLE statement (6985)

CREATE TABLE statement (7250)

DEGREES function (6126)

detailed format description (6456)

values and arguments, rules for (6457)

deletable

view (7343)

DELETE clause

GRANT statement (table or view) (7554)

REVOKE statement, revoking privilege for (7713)

delete rule for referential constraint (5259)

DELETE statement (7379), (7390)

authorization, searched or positioned format (7382)

delete-connected table (5260)

deleting SQL objects (7407)

delimited identifier in SQL (5442)

delimited identifier, SQL statement (5433)

delimiter tokens, definition of (5419)

DEPARTMENT sample table (7995)

dependency

of objects on each other (7435)

dependent row (5232), (5241)

dependent table (5228), (5238)

DEREF function (6128)

reference type (6460)

dereference operation (5999)

attribute-name operand (6004)

scoped-ref-expression (6002)

DESC clause

CREATE INDEX statement (7197)

of select-statement (6897)

descendent row (5233)

descendent table (5229), (5239)

DESCRIBE statement (7392), (7400)

prepared statements, destruction conditions (7398)

DESCRIPTOR

host variables, parameter substitution list (7457)

descriptor-name (5465)

in FETCH statement (7490)

diagnostic string

in RAISE_ERROR function (6625)

in SIGNAL SQLSTATE statement (7822)

DIFFERENCE function (6130)

detailed format description (6462)

values and arguments, rules for (6463)

DIGITS function (6132), (6466)

digits, range of (5412)

dirty read (8026)

DISCONNECT statement (7401), (7404)

DISTINCT clause

of subselect (6777)

DISTINCT keyword

AVG function, relation to (6307)

column function (6301)

COUNT function, relationship to (6317)

COUNT_BIG function, relationship to (6328)

MAX function, restriction for (6339)

MIN function (6345)

STDDEV function, relation to (6348)

SUM function (6359)

VARIANCE function, relation to (6363)

DISTINCT keyword, overview (6304)

distinct type

as arithmetic operands (5945)

comparison (5742)

concatenation (5917)

constants (5790)

CREATE DISTINCT TYPE statement (7158)

description (5466), (5661)

DROP statement (7416)

DISTINCT TYPE clause

COMMENT ON statement (7087)

DROP statement (7433)

distributed relation database, definition (5325)

distributed relational database

application requester, overview (5316)

application server, overview (5318)

data representation considerations (5350)

environment, illustration of (5326)

remote unit of work, overview (5334)

requester-server protocols, overview (5317)

distributed relational database architecture (DRDA) (5321)

DLCOMMENT function (6134)

DLCOMMENT function, extracting comment from DATALINK value (6470)

DLLINKTYPE function (6136)

DLLINKTYPE function, extracting linktype from DATALINK value (6474)

DLURLCOMPLETE function (6138)

DLURLCOMPLETE function, extracting complete URL from DATALINK value (6478)

DLURLPATH function (6140)

DLURLPATH function, extracting path and file name from DATALINK value (6482)

DLURLPATHONLY function (6142)

DLURLPATHONLY function, extracting path and file name from DATALINK value (6486)

DLURLSCHEME function (6144)

DLURLSCHEME function, extracting scheme from DATALINK value (6490)

DLURLSERVER function (6146)

DLURLSERVER function, extracting file server from DATALINK value (6494)

DLVALUE function (6148)

DLVALUE function, building a DATALINK value (6498)

DMS table space

CREATE TABLESPACE statement (7301)

description (5380)

dormant connection state (5347)

DOUBLE

CHAR, use of in format conversion (6406)

double byte character string (DBCS), returning (6743)

DOUBLE data type (7232)

precision (5610)

range (5609)

DOUBLE function (6152)

DOUBLE function, double precision conversion (6502)

DOUBLE or DOUBLE_PRECISION function (6150)

DOUBLE PRECISION data type (7233)

double precision float data type (7230)

double-byte character

truncated during assignment (5715)

Double-Byte Character Large OBject (5543) See also DBCLOB string

double-precision floating-point (5612)

DRDA (Distributed Relational Database Architecture) (5322)

DROP CHECK clause of ALTER TABLE statement (7003)

DROP CONSTRAINT clause of ALTER TABLE statement (7002)

DROP FOREIGN KEY clause (7000)

DROP PARTITIONING KEY clause of ALTER TABLE statement (7004)

DROP PRIMARY KEY clause (6999)

DROP statement (7405), (7437)

DROP UNIQUE clause (7001)

duration

adding, results of (5967)

date, format of (5956)

labeled (5952)

subtracting, results of (5968)

time, format of (5957)

timestamp (5959)

durations (5951)

dynamic select

host variables, restrictions on (6931)

parameter markers, usage in (6930)

dynamic SQL (5157), (7881)

DECLARE CURSOR statement, usage in (6933)

definition of (5144)

description, preparation methods (6908)

execution (6919)

FETCH statement, usage in (6935)

OPEN statement, usage in (6934)

preparation (6918)

PREPARE statement, execution of (7647)

PREPARE statement, usage in (6932)

prepared statement information, using DESCRIBE (7395)

preparing and executing, commands for (5143)

SQLDA used with (7893)

embedded SQL statement

executing character strings, EXECUTE IMMEDIATE (7467)

embedded SQL, requirements overview (6909)

EMP_ACT sample table (7997)

EMP_PHOTO sample table (7998)

EMP_RESUME sample table (7999)

EMPLOYEE sample table (7996)

empty character string (5555)

encoding scheme (5364)

END DECLARE SECTION statement (7438), (7440), (7445)

erasing the sample database (7993)

error

closes cursor (7636)

during FETCH (7493)

during UPDATE, (7840)

return code, language overview (6938)

errors

executing triggers (7315)

escape character in SQL (5443)

ESCAPE clause

LIKE predicate (6036)

EUC considerations (8054)

EUR (5644) See also datetime format

European (EUR) date format (5640)

European (EUR) time format (5652)

evaluation order, expressions (5980)

event monitor

CREATE EVENT MONITOR statement (7164)

description (5277)

DROP statement (7419)

EVENT_MON_STATE function (6508)

name description (5467)

SET EVENT MONITOR STATE statement (7791)

EVENT_MON_STATE function (6154), (6509)

EXCEPT clause of fullselect (6872)

except-on-nodes-clause

CREATE BUFFERPOOL statement (7150)

exception tables (7765)

SET CONSTRAINTS statement (7766)

structure (8053)

EXCLUSIVE

IN EXCLUSIVE MODE (7111)

exclusive locks (5300)

EXCLUSIVE option, LOCK TABLE statement (7618)

executable statement, methods overview (6903)

executable statement, processing summary (6910)

EXECUTE IMMEDIATE statement (7475)

detailed instructions for (7462)

embedded usage, detailed description (6922)

use in dynamic SQL (5152)

EXECUTE statement (7459)

detailed instructions for (7446)

embedded usage, detailed description (6921)

use in dynamic SQL (5151)

executing, revoking package privileges (7691)

execution

package, necessary privileges, granting (7527)

EXISTS predicate, detailed format description (6024)

EXP function (6156)

detailed format description (6510)

values and arguments, rules for (6511)

EXPLAIN statement (7476), (7480)

explainable statement

definition (7478)

EXPLAIN_ARGUMENT table (8035)

EXPLAIN_ARGUMENT table definition (8042)

EXPLAIN_INSTANCE table (8036)

EXPLAIN_INSTANCE table definition (8043)

EXPLAIN_OBJECT table (8037)

EXPLAIN_OBJECT table definition (8044)

EXPLAIN_OPERATOR table (8038)

EXPLAIN_OPERATOR table definition (8045)

EXPLAIN_PREDICATE table (8039)

EXPLAIN_PREDICATE table definition (8046)

EXPLAIN_STATEMENT table (8040)

EXPLAIN_STATEMENT table definition (8047)

EXPLAIN_STREAM table (8041)

EXPLAIN_STREAM table definition (8048)

exposed name, correlation-name, FROM clause (5848)

expression

case (5983)

CAST specification (5986)

concatenation operator (5909)

datetime operands, summary of (5947)

decimal operands (5932), (5936)

dereference operation (5998)

floating-point operands, rules for (5941)

format and rules (5906)

grouping-expression, use in GROUP BY (6834)

in CAST specification (5988)

in DIGITS function (6467)

in ORDER BY clause (6895)

in SELECT clause, syntax diagram (6773)

in subselect (6783)

integer operands (5929), (5931)

operators, mathematical, listing (5904)

precedence of operation (5979)

sign of, values (5903)

string (5910)

substitution operators, listing (5905)

with arithmetic operators (5919)

without operators (5908)

extended character set (5409)

extended storage (6957), (7153)

external function

description (5896)

FETCH statement (7481), (7495)

cursor prerequisites for executing (7484)

file reference variables

BLOB (5887)

CLOB (5888)

DBCLOB (5889)

FLOAT data type (5605), (5611), (7228)

FLOAT function (6158)

FLOAT function, double precision conversion (6515)

floating point numbers

as data type (5530)

precision (5601), (5607)

range (5602), (5608)

floating-point constants (5775)

floating-point to decimal conversion (5700)

FLOOR function (6160)

detailed format description (6516)

values and arguments, rules for (6517)

FOR BIT DATA clause

CREATE TABLE statement (7239)

FOR FETCH ONLY clause

select-statement (6899)

FOR READ ONLY clause

select-statement (6898)

foreign key (5207), (5218), (5223)

adding or dropping, ALTER TABLE (6973)

constraint name, conventions for (7262)

view, referential constraints in (5187)

FOREIGN KEY clause

CASCADE clause, propagation summary (7270)

constraint name, conventions for (7261)

CREATE TABLE statement (7260)

delete rule, conventions for (7268)

multiple paths, consequences of using (7272)

RESTRICT clause, prohibition (7269)

SET NULL clause, operation of (7271)

fragments in SUBSTR function, warning (6680)

FREE LOCATOR statement (7496), (7500)

FROM clause

correlation name, use of, example (5844)

exposed and non-exposed names, explanation (5845)

PREPARE statement (7652)

subselect syntax (6800)

FROM clause in DELETE statement (7383)

FROM clause, use in correlation-name, example (5843)

fullselect

examples of (6879)

multiple operations, order of execution (6877)

ORDER BY clause (6892)

subquery role, search condition, overview (5856)

table-reference (6811)

used in CREATE VIEW statement (7339)

fullselect, detailed syntax (6865)

function (5891), (6059), (6321), (6326), (6370)

arguments (6061)

built-in (5892)

column (6198), (6300)

AVG (6079)

AVG, options and results (6305)

COUNT (6103), (6313)

COUNT, values returned (6316)

COUNT_BIG (6105), (6322)

COUNT_BIG, values returned (6327)

MAX (6334)

MAX, values returned (6338)

MIN (6204), (6344)

STDDEV (6257), (6347)

STDDEV, options and results (6346)

SUM (6261), (6358)

VAR, options and results (6361)

VARIANCE or VAR (6295), (6362)

VARIANCE, options and results (6360)

comment descriptions, adding to catalog (7065)

description (5890), (6060)

expression (6062)

external

description (5898)

HOUR (6171)

INTEGER or INT (6175)

LCASE (6179)

LN (6185)

LOG (6189)

MICROSECOND (6200)

MIDNIGHT_SECONDS (6202)

MONTH (6209)

MONTHNAME (6211)

name description (5468)

nesting (6372)

resolution (5901)

scalar (6191), (6207)

ABS or ABSVAL (6067), (6375)

ACOS (6069), (6378)

ASCII (6071), (6381)

ASIN (6073), (6384)

ATAN (6075), (6387)

ATAN2 (6077), (6390)

AVG (6306)

BIGINT (6081), (6392)

BIGINT, returning integer values (6391)

BLOB (6083), (6395)

CEIL or CEILING (6085), (6400)

CHAR (6087), (6089), (6402)

CHAR, use in datetime conversion (6401)

CHR (6091), (6410)

CLOB (6093), (6413)

COALESCE (6095), (6414)

CONCAT (6418)

CONCAT or || (6097)

COS (6099), (6421)

COT (6101), (6424)

DATE (6107), (6426)

DATE, returning dates from values (6425)

DAY (6109), (6430)

DAY, returning day part of value (6429)

DAYNAME (6111), (6435)

DAYOFMONTH (6113)

DAYOFWEEK (6115), (6438)

DAYOFYEAR (6117), (6441)

DAYS (6119), (6443)

DAYS, returning integer durations (6442)

DBCLOB (6121), (6448)

DECIMAL or DEC (6123), (6125), (6450)

DECIMAL, returning decimal equivalents (6449)

definition (6368)

DEGREES (6127), (6458)

DEREF (6129), (6459)

DIFFERENCE (6131), (6464)

DIGITS (6133), (6465)

DLCOMMENT (6135), (6469)

DLCOMMENT, extracting comment from DATALINK value (6468)

DLLINKTYPE (6137), (6473)

DLLINKTYPE, extracting linktype from DATALINK value (6472)

DLURLCOMPLETE (6139), (6477)

DLURLCOMPLETE, extracting complete URL from DATALINK value (6476)

DLURLPATH (6141), (6481)

DLURLPATH, extracting path and file name from DATALINK value (6480)

DLURLPATHONLY (6143), (6485)

DLURLPATHONLY, extracting path and file name from DATALINK value (6484)

DLURLSCHEME (6145), (6489)

DLURLSCHEME, extracting scheme from DATALINK value (6488)

DLURLSERVER (6147), (6493)

DLURLSERVER, extracting file server from DATALINK value (6492)

DLVALUE (6149), (6497)

DLVALUE, building a DATALINK value (6496)

DOUBLE (6153)

DOUBLE or DOUBLE_PRECISION (6151), (6501)

DOUBLE, returning floating point values (6500)

EVENT_MON_STATE (6155), (6507)

EVENT_MON_STATE, returning event monitor states (6506)

EXP (6157), (6512)

FLOAT (6159), (6514)

FLOAT, returning floating point values (6513)

FLOOR (6161), (6518)

GENERATE_UNIQUE (6163), (6519)

GRAPHIC (6165), (6528)

GROUPING (6167), (6331)

HEX (6169), (6529)

HOUR (6533)

HOUR, returning hour part of values (6532)

INSERT (6538)

INTEGER or INT (6540)

INTEGER, returning integer values (6539)

JULIAN_DAY (6545)

LCASE (6548)

LEFT (6551)

LENGTH (6183), (6553)

LENGTH, length values from expressions (6552)

LN (6559)

LOCATE (6187), (6562)

LOG (6565)

LOG10 (6568)

LONG_VARCHAR (6193), (6571)

LONG_VARGRAPHIC (6195), (6574)

LTRIM (6196), (6577)

MICROSECOND (6579)

MICROSECOND, returning microsecond part of values (6578)

MIDNIGHT_SECONDS (6584)

MINUTE (6586)

MINUTE, returning minute part of values (6585)

MOD (6591)

MONTH (6593)

MONTH, returning month part of values (6592)

MONTHNAME (6598)

NODENUMBER (6213), (6599)

NULLIF (6215), (6605)

PARTITION (6217), (6607)

POSSTR (6219), (6610)

POWER (6221), (6615)

QUARTER (6223), (6618)

RADIANS (6225), (6621)

RAISE_ERROR (6227), (6622)

RAND (6229), (6629)

REAL (6231), (6631)

REAL, returning floating point values (6630)

REPEAT (6233), (6637)

REPLACE (6235), (6640)

restrictions, overview of (6369)

RIGHT (6237), (6643)

ROUND (6239), (6646)

RTRIM (6241), (6649)

SECOND (6243), (6651)

SECOND, returning second from values (6650)

SIGN (6245), (6656)

SIN (6247), (6659)

SMALLINT (6249), (6661)

SMALLINT, returning small integer values (6660)

SOUNDEX (6251), (6666)

SPACE (6253), (6669)

SQRT (6255), (6672)

SUBSTR (6259), (6674)

SUBSTR, returning substring from string (6673)

TABLE_NAME (6263), (6681)

TABLE_SCHEMA (6265), (6684)

TAN (6267), (6689)

TIME (6269), (6691)

TIME, using time in an expression (6690)

TIMESTAMP (6271), (6696)

TIMESTAMP, returning timestamp from values (6695)

TIMESTAMPDIFF (6275), (6705)

TIMESTAMP_ISO (6273), (6702)

TRANSLATE (6277), (6706)

TRUNC or TRUNCATE (6279), (6717)

TYPE_ID (6281), (6718)

TYPE_NAME (6283), (6721)

TYPE_SCHEMA (6285), (6724)

UCASE (6287), (6729)

user-defined (6753)

VALUE (6289), (6731)

VALUE, returning non-null result (6730)

VARCHAR (6291), (6733)

VARGRAPHIC (6293), (6737)

WEEK (6297), (6744)

YEAR (6299), (6750)

YEAR, returning values based on year (6749)

signature (5900)

sourced

description (5899)

user-defined (5894)

FUNCTION clause

COMMENT ON statement (7075)

function path (5664) See also SQL path

GENERATE_UNIQUE function (6162), (6520)

detailed format description (6521)

GO TO clause

WHENEVER statement (7861)

grand total row (6850)

GRANT

CONTROL ON INDEX (7518)

CREATE ON SCHEMA (7532)

Database Authorities (7501)

Package Privileges (7524)

Table Privileges (7539), (7570)

View Privileges (7540), (7571)

GRANT (Schema Privileges) statement (7530), (7537)

grant statement

authorization name, use in (5510)

GRAPHIC data type

for CREATE TABLE (7243)

GRAPHIC function (6164)

detailed format description (6526)

values and arguments, rules for (6527)

graphic string

returning from host variable name (6714)

translating string syntax (6713)

graphic string, as data type

fixed length (5527)

varying length (5528)

graphic strings

fixed length, description (5575)

varying length, description (5576)

GROUP BY clause

of subselect, rules and syntax (6832)

results with subselect (6789)

group-by-clause, rules and syntax (6831)

GROUPING function (6166), (6332)

grouping sets

examples of (6862)

grouping-expression (6838)

grouping-sets (6841)

hash partitioning (5393)

hashing on partition keys (7281)

HAVING clause

of subselect, use of search conditions (6852)

results with subselect (6790)

held connection state (5348)

HEX

function (6530)

hexadecimal (6531)

HEX function (6168)

host identifier

definition (5449)

in a host variable (5471)

SQL statement (5440)

host variable

active set, linking with cursor (7628)

assigning values from a row (7750), (7849)

BLOB (5883)

CLOB (5884)

DBCLOB (5885)

declaration rules, related to cursor (7368)

description (5872)

description of (5469)

embedded SQL statements, end declaration (7443)

embedded statements, usage in (6911)

embedded use, BEGIN DECLARE SECTION, rules (7038)

EXECUTE IMMEDIATE statement (7469)

FETCH statement, identifying (7487)

host identifier in (5470)

indicator variable, uses of (5879)

inserting in rows, INSERT statement (7594)

PREPARE statement (7653)

REXX applications, special case (7039)

statement string, restricted listing, PREPARE statement (7654)

substitution for parameter markers (7454)

syntax, diagram of (5876)

host-identifier

in host variable (5878)

host-label (7862)

HOUR function (6170)

HOUR function, returning hour part of values (6534)

identifiers

limits (7868)

identifiers in SQL

description (5434)

host identifiers, syntax for (5437)

long identifiers, definition (5436)

ordinary (5441)

short identifiers, definition (5435)

IMMEDIATE

EXECUTE IMMEDIATE statement (7464), (7473)

implicit connect

CONNECT statement (7113)

implicit decimal number (5622)

implicit schema

GRANT (Database Authorities) statement (7512)

REVOKE (Database Authorities) statement (7682)

IMPLICIT_SCHEMA authority (5170)

IN EXCLUSIVE MODE clause, LOCK TABLE statement (7617)

IN predicate, detailed format description (6026)

IN SHARE MODE clause, LOCK TABLE statement (7615)

IN_TRAY sample table (8000)

INCLUDE clause

CREATE INDEX statement (7198)

INCLUDE statement (7574)

incompatibilities

description (8031)

incrementing a date, rules for (5965)

incrementing a time, rules for (5972)

index

authorization ID, use in name (5508)

comment descriptions, adding to catalog (7067)

control(to drop), granting, SQL statement for (7519)

control, granting (7557)

correspondence to inserted row values, rules for (7596)

definition of (5189)

deleting, using DROP statement (7408)

primary key, use in matching (6994)

unique key, use in matching (6992)

uses of (5190)

view, relationship to (5193)

INDEX clause

COMMENT ON statement (7077)

CREATE INDEX statement (7187), (7192)

DROP statement (7425)

GRANT statement (table or view) (7556)

REVOKE statement, removing privileges for (7714)

index name

primary key constraint (7259)

unique constraint (7257)

index-name, qualified and unqualified naming (5472)

indicator

variable (5881), (7468)

indicator variable

host variable, uses in declaring (5880)

infix operators (5928)

inoperative trigger

CREATE TRIGGER statement (7313)

inoperative view

CREATE VIEW statement (7352)

INSERT clause

GRANT statement (table or view) (7558)

REVOKE statement, removing privileges for (7715)

values, restrictions leading to failure (7597)

INSERT function (6172)

detailed format description (6536)

values and arguments, rules for (6537)

insert rule with referential constraint (5253)

INSERT statement (7586), (7607)

insertable

view (7347)

installing the sample database (7990)

integer

in ORDER BY clause (6894)

integer constants

definition of (5772)

syntax example (5773)

INTEGER data type (7226)

description (5593)

precision (5594)

range (5595)

INTEGER function, integer values from expressions (6541)

INTEGER or INT function (6174)

integer to decimal conversion, summary (5698)

interactive entry of SQL statements (6936)

interactive SQL (5159)

CLOSE, use in, example (5166)

DECLARE CURSOR, use in, example (5161)

DESCRIBE, use in, example (5163)

FETCH, use in, example (5165)

OPEN, use in, example (5164)

PREPARE, use in, example (5162)

SELECT statement, dynamic example (5160)

interactive SQL, definition of (5153)

intermediate result table (6804), (6805), (6828), (6837), (6856)

International Standards Organization (ISO) date format (5638)

International Standards Organization (ISO) time format (5650)

INTERSECT clause

duplicate rows, use of ALL, effect of (6875)

of fullselect, role in comparison (6874)

INTO clause

DESCRIBE statement, SQLDA area name (7396)

FETCH statement, host variable substitution (7486)

FETCH statement, use in host variable (5873)

INSERT statement, naming table or view (7587)

PREPARE statement (7650)

restrictions on using, list of (7588)

SELECT INTO statement (7752)

SELECT INTO statement, use in host variable (5874)

values from applications programs (5875)

VALUES INTO statement (7851)

invoking SQL statements (6902)

IS clause

COMMENT ON statement (7088)

ISO (5645) See also datetime format

ISO/ANSI standards

SQLCODE, use of SQL (6947)

SQLSTATE, use of SQL92 (6948)

isolation level

comparison (8012)

cursor stability (5310), (8017)

description (5296)

none (8021)

read stability (5306), (8018)

repeatable read (5303), (8019)

uncommitted read (5313), (8020)

Japanese Industrial Standard (JIS) date format (5641)

Japanese Industrial Standard (JIS) time format (5653)

JIS (5646) See also datetime format

join

examples of (6861)

examples of a subselect (6860)

full outer (6822)

inner (6819)

left outer (6820)

partitioning key considerations (7287), (7288)

right outer (6821)

table collocation (5399)

joined-table (6818)

table-reference (6812)

JULIAN_DAY function (6176)

detailed format description (6543)

values and arguments, rules for (6544)

key

composite (5194)

foreign (5205), (5221)

parent (5227)

partitioning (5208)

primary (5201)

unique (5195), (5198), (5216)

labeled duration, detailed description (5953)

labelled durations, in expressions, diagram

labelled duration values, listing (5954)

large integers (5596)

large object location, definition (5549)

LCASE function (6178)

detailed format description (6546)

values and arguments, rules for (6547)

LEFT function (6180)

detailed format description (6549)

values and arguments, rules for (6550)

length attributes of columns (5557)

LENGTH function (6182)

LENGTH function, length values from expressions (6554)

lengths of expressions, rules for (6555)

letters, range of (5413)

LIKE predicate, rules for (6031)

limits

database manager (7875), (7877)

datetime (7873)

identifier (7867)

numeric (7869)

SQL (7865)

string (7871)

literals, overview of (5767)

LN function (6184)

detailed format description (6557)

values and arguments, rules for (6558)

LOB

locator, definition (5550)

string, definition (5547)

LOCAL (5647) See also datetime format

LOCAL datetime format (5642)

LOCAL time format (5654)

LOCATE function (6186)

detailed format description (6560)

values and arguments, rules for (6561)

locator

definition (5551)

FREE LOCATOR statement (7498)

locator variable

description (5886)

LOCK TABLE statement (7608), (7622)

locking

COMMIT statement, effect on (7099)

definition of (5290)

LOCK TABLE statement (7611)

table rows and columns, restricting access (7610)

locks

during UPDATE (7842)

exclusive (5299)

INSERT statement, default rules for (7603)

share (5297)

terminating for unit of work, ROLLBACK (7741)

update (5301)

LOG function (6188)

detailed format description (6563)

values and arguments, rules for (6564)

LOG10 function (6190)

detailed format description (6566)

values and arguments, rules for (6567)

logging

creating table without initial logging (7282)

logical operators, rules for search conditions (6047)

long identifier, SQL statement, definition (5439)

LONG VARCHAR data type

for CREATE TABLE (7238)

LONG VARCHAR strings

attributes, summary (5564)

restrictions on usage (5565)

LONG VARGRAPHIC strings

attributes, summary (5579)

restrictions on usage (5580)

LONG_VARCHAR function (6192)

detailed format description (6569)

values and arguments, rules for (6570)

LONG_VARGRAPHIC function (6194)

detailed format description (6572)

values and arguments, rules for (6573)

LTRIM function

detailed format description (6575)

values and arguments, rules for (6576)

MANAGED BY clause

CREATE TABLESPACE statement (7294)

MAX function (6197)

detailed format description (6336)

values and arguments, rules for (6337)

MBCS (double-byte character set) data

within mixed data (5572)

MICROSECOND function (6199)

MICROSECOND function, returning microsecond from value (6580)

MIDNIGHT_SECONDS function (6201)

detailed format description (6582)

values and arguments, rules for (6583)

MIN function (6203)

detailed format description (6340)

values and arguments, rules for (6341)

MINUTE function (6205)

MINUTE function, returning minute from value (6587)

mixed data See also SBCS (single-byte character set) data

description (5571)

LIKE predicate (6035)

MOD function

detailed format description (6589)

values and arguments, rules for (6590)

MODE keyword, LOCK TABLE statement (7619)

MONTH function (6208)

MONTH function, returning month from value (6594)

MONTHNAME function (6210)

detailed format description (6596)

values and arguments, rules for (6597)

multi-byte character set (MBCS), support for (5416)

multiple row VALUES clause

result data type (5755)

name

identifying columns in subselect (6784)

name, use of in deleting a row (7389)

names for columns, rules governing (5461)

names in SQL, rules for, summary (5452)

names, qualified column, rules for (5836)

naming conventions in SQL (5450)

nested table expression (6814)

new unit of work, initiating (7740)

NO ACTION delete rule (7264)

node number of row, obtaining (6602)

nodegroup

adding a node (6963)

adding a partition (6962)

creation (7205)

description (5389)

dropping a node (6965)

dropping a partition (6964)

naming conventions (5474)

partitioning map created with (7208)

NODEGROUP clause

COMMENT ON statement (7078)

CREATE BUFFERPOOL statement (7148)

DROP statement (7426)

nodegroup name, syntax for (5473)

nodegroups

comment descriptions, adding to catalog (7071)

NODENUMBER function (6212), (6600), (6604)

non-exposed name, re. correlation-name, FROM clause (5849)

nonexecutable statement

precompiler requirements summary (6914)

nonexecutable statement, methods overview (6904)

nonrepeatable read (8027)

NOT FOUND clause

WHENEVER statement (7856)

NOT NULL clause

CREATE TABLE statement (7249)

NOT NULL, use in NULL predicate (6039)

NULL

in CAST specification (5990)

keyword SET NULL delete rule

description (5258)

NULL predicate, rules for (6037)

null value in SQL

assignment, rules governing (5693)

column names in a result (6793)

in duplicate rows (6778)

in grouping-expressions, allowable uses (6840)

in result columns (6792)

specified by indicator variable (5882)

unknown condition (6046)

null value in SQL, definition of (5536)

NULLIF

function description (6606)

NULLIF function (6214)

numbers, summary of types (5584)

numeric

assignments in SQL operations (5694)

comparisons, rules for (5724)

limits (7870)

numeric data

data types, overview (5583)

numeric data, remote conversions of (5355)

object identifier (OID) (7276)

CREATE TABLE statement (7275)

CREATE VIEW statement (7333)

object table (5850)

OF clause

CREATE VIEW statement (7331)

OID column (7277) See also object identifier (OID)

ON clause

CREATE INDEX statement (7193)

ON TABLE clause

GRANT statement (7566)

REVOKE statement (7719)

ON UPDATE clause (7273)

on-nodes-clause

CREATE TABLESPACE statement (7300), (7304), (7305)

ONLY clause in DELETE statement (7384)

ONLY clause in UPDATE statement (7831)

OPEN statement (7623), (7644)

operand

string (5913)

operands

datetime

date duration (5949)

labelled duration (5948)

time duration (5950)

decimal (5937)

decimal, rules governing (5934)

floating-point, rules for (5942)

integer (5930)

integer, rules governing (5933)

operands of in list

result data type (5753)

operation

assignment (5683), (5720)

assignments, general description (5679)

comparison (5726), (5744)

comparisons, general description (5680)

datetime, SQL rules for (5963)

dereference (5997)

operators

arithmetic, summary of results (5920)

OPTION clause

CREATE VIEW statement (7342)

OR truth table (6056)

ORDER BY clause

of select-statement (6890)

order of evaluation, expressions (5981)

order-by-clause (6889)

ordinary identifier, SQL statement (5432)

ordinary tokens, definition of (5418)

ORG sample table (8001)

outer join

joined-table (6813), (6817)

package

access plan, relation to term (5281)

authority to create, granting (7505)

authorization ID, use in name (5509)

binding, overview of relationship (5330)

comment descriptions, adding to catalog (7068)

COMMIT statement, effect on cursor (7100)

definition of (5283)

deleting, using DROP statement (7411)

DROP FOREIGN KEY, effect on dependencies (7008)

DROP PRIMARY KEY, effect on dependencies (7006)

DROP UNIQUE key, effect on dependencies (7007)

naming conventions (5476)

necessary privileges, granting (7525)

plan, relation to term (5282)

revoking all privileges (7689)

validity and usage rules when revoking privilege (7724)

PACKAGE clause

COMMENT ON statement (7079)

DROP statement (7427)

package name, syntax for (5475)

packed decimal number, locating decimal point (5621)

parameter marker

host variables in dynamic SQL (5877)

in CAST specification (5992)

in EXECUTE statement (7451)

in OPEN statement (7634)

in PREPARE statement (7656)

rules, syntax and operations (7657)

substitution for, OPEN statement (7632)

typed (7659)

untyped (7660)

usage in expressions, predicates and functions (7661)

parent key (5226)

parent row (5234), (5242)

parent table (5225), (5237)

parentheses

precedence of operation, use (5982)

partial declustering (5394)

partition compatibility

definition (5761)

PARTITION function (6216), (6608)

partition number of row, obtaining (6601)

partitioned relational database, definition (5138)

partitioning data

compatibility table (5765)

description (5390)

hash partitioning (5392)

partial declustering (5395)

partition compatibility (5762)

partitioning map, definition (5396)

partitioning key (5210)

adding or dropping, ALTER TABLE (6975)

ALTER TABLE statement (6996)

considerations (7284)

defining when creating table (7280)

purpose (5391)

partitioning map

created with nodegroup (7207)

partitioning map index of row, obtaining (6609)

partitioning of data (5139)

PCTFREE clause

CREATE INDEX statement (7200)

performance

partitioning key recommendation (7285)

phantom row (5309), (8028)

positional updating of columns by row (7833)

POSSTR function (6218)

POSSTR scalar function

description (6611)

POWER function (6220)

detailed format description (6613)

values and arguments, rules for (6614)

precedence

level operators, rules for (5978)

operation, order of evaluating (5977)

precision of numbers

determined by SQLLEN variable (7911)

precision, as a numeric attribute (5586)

precision-integer, DECIMAL function

default values for data types (6454)

precompiler

INCLUDE statement, trigger for (7577)

non-executable statements, usage overview (6917)

static SQL, use in Run-Time Service calls (5155)

precompiling

including external text file (7580)

initiating and setting up SQLDA and SQLCA (7581)

predicate

basic, detailed format, diagram (6007)

BETWEEN, detailed format diagram (6021)

description (6005)

EXISTS, detailed format description (6025)

IN, detailed format description (6027)

LIKE (6032)

NULL, detailed format, diagram (6038)

quantified, usage and rules (6013)

TYPE, detailed format, diagram (6041)

prefix operator (5923)

PREPARE statement (7645), (7666)

embedded usage, detailed description (6920)

use in dynamic SQL (5150)

prepared SQL statement (7882)

dynamically declaring, PREPARE statement (7648)

dynamically prepared by PREPARE (7663)

executing (7448), (7461)

host variables, substitution of (7449)

information, obtaining with DESCRIBE (7394)

prepared statement

OPEN statement, use in variable substitution (7631)

SQLDA provides information about (7895)

PRIMARY KEY

primary key (5203)

adding or dropping, ALTER TABLE (6971)

adding, privileges for, granting (7548)

CREATE TABLE statement (7253)

dropping, privileges for, granting (7549)

PRIMARY KEY clause

ALTER TABLE statement (6993)

CREATE TABLE statement (7258)

privilege (7709)

privileges

CONTROL privilege, overview of (5366)

database, effects of revoking (7684), (7700)

DBADM, scope of (5371)

definition (5368)

index, effects of revoking (7687)

overview (5365)

package, effects of revoking (7694)

packages, validity rules when revoking (7722)

SYSADM, scope of (5369)

SYSCTRL, scope of (5373)

SYSMAINT, scope of (5375)

table or view, effects of revoking (7725)

views, cascading effects of revoking (7721)

procedure

naming conventions (5479)

PROCEDURE clause

COMMENT ON statement (7080)

procedure name, syntax for (5478)

PROJECT sample table (8002)

promotion

of data types (5670)

PUBLIC clause

GRANT statement (7517), (7523), (7529), (7536), (7568)

REVOKE statement (7683), (7686), (7693), (7699)

REVOKE statement, removing privileges for (7720)

qualified column names, rules for (5835)

qualifier

reserved (8011)

quantified predicate, detailed rules for (6012)

QUARTER function (6222)

detailed format description (6616)

values and arguments, rules for (6617)

query (6755), (6901)

authorization IDs required for issuing (6757)

definition (6756)

recursive (6885)

example (8050)

query (SQL)

subquery, use in WHERE clause (6824)

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

RADIANS function (6224)

detailed format description (6619)

values and arguments, rules for (6620)

RAISE_ERROR function (6226), (6623)

raising errors

RAISE_ERROR function (6626)

SIGNAL SQLSTATE statement (7820)

RAND function (6228)

detailed format description (6627)

values and arguments, rules for (6628)

read stability (5307), (8023)

read-only

view (7349)

read-only cursor

ambiguous (7375)

REAL data type (7231)

precision (5604)

range (5603)

REAL function (6230)

REAL function, single precision conversion (6632)

Record Blocking

locks to row data, INSERT statement (7605)

recovery of applications (5289)

recursion

example (8051)

query (6887)

recursive common table expression (6888)

reference type

comparison (5745)

DEREF function (6461)

description (5667)

reference types

casting (5677)

REFERENCES clause

GRANT statement (7561)

REVOKE statement, removing privileges for (7716)

referential constraint (5219)

referential cycle (5230), (5240)

referential integrity (5220), (5231)

REFRESH TABLE statement (7667)

REFRESH DEFERRED (7671)

REFRESH IMMEDIATE (7670)

relational database, definition (5137)

RELEASE statement (7673)

release to release incompatibilities

description (8032)

release-pending connection state (5349)

remote access

application server, role in (5328)

character strings, conversions (5354)

CONNECT statement

EXCLUSIVE MODE, dedicated connection (7119)

ON SINGLE NODE, dedicated connection (7120)

server information only, no operand (7121)

SHARE MODE, read-only for non-connector (7118)

IMPLICIT connect, diagram of state transitions (5337)

non-IMPLICIT connect, diagram of state transitions (5339)

numeric data, conversions (5353)

successful connection, detailed description (7115)

unsuccessful connection, detailed description (7117)

remote execution of SQL (5340)

remote unit of work, overview (5333)

RENAME TABLE statement (7674), (7677)

REPEAT function (6232)

detailed format description (6635)

values and arguments, rules for (6636)

repeatable read (5304), (8024)

REPLACE function (6234)

detailed format description (6638)

values and arguments, rules for (6639)

reserved

qualifiers (8007)

schema names (8008)

words (8009)

RESTRICT delete rule (7265)

description (5254)

result columns of subselect (6796)

result data type

arguments of COALESCE (5752)

multiple row VALUES clause (5756)

operands of in list (5754)

result expressions of CASE expression (5750)

set operator (5748)

result expressions of CASE expression

result data type (5749)

result table (5183)

result table, result from query (6758)

return code

embedded statements, language instructions for (6939)

executable statements, usage summary (6912)

REVOKE

CONTROL ON INDEX (7685)

CREATEIN ON SCHEMA (7697)

Database Authorities (7679)

DROPIN ON SCHEMA (7698)

Package Privileges (7688)

Table Privileges (7703), (7726)

View Privileges (7704), (7727)

REVOKE (Schema Privileges) statement (7695), (7701)

revoke statement

authorization-name, use in (5511)

REXX

END DECLARE SECTION, prohibition (7442)

RIGHT function (6236)

detailed format description (6641)

values and arguments, rules for (6642)

ROLLBACK

cursor, effect on (7743)

SQL statement, detailed usage instructions for (7744)

rollback description (5293)

ROLLBACK statement (7746)

detailed syntax instructions (7730)

ROLLUP (6843)

rollup

examples of (6864)

ROUND function (6238)

detailed format description (6644)

values and arguments, rules for (6645)

row

as syntax component, diagram (6769)

assigning values to host variable, SELECT INTO (7751)

assigning values to host variable, VALUES INTO (7850)

COUNT function, values returned (6312)

COUNT_BIG function, values returned (6320)

cursor, effect of closing on FETCH (7050)

cursor, FETCH statement, relation to (7642)

cursor, location in result table (7365)

definition of (5176)

deleting, privilege for, granting (7555)

deleting, SQL statement, details (7381)

dependent (5251)

descendent (5250)

exporting row data, privilege for, granting (7564)

FETCH request, cursor row selection (7367)

GROUP BY clause, result table from (6835)

GROUP BY, use in limiting in SELECT clause (6785)

HAVING clause, results from search, rules for (6854)

HAVING, use in limiting in SELECT clause (6786)

importing values, privilege for, granting (7560)

index, role of key (7189)

inserting into table or view (7583)

inserting values, INSERT statement (7593)

inserting, privilege for, granting (7559)

locks to row data, INSERT statement (7604)

locks, effect on cursor of WITH HOLD (7366)

parent (5249)

retrieving row data, privilege for, granting (7563)

search conditions, detailed syntax (6053)

SELECT clause, select list notation (6768)

self-referencing (5252)

UNIQUE clause, table index, effect on key (7191)

updating column values, UPDATE statement (7827)

values, insertion, restrictions leading to failure (7598)

row fullselect

UPDATE statement (7834)

RR (repeatable read) isolation level (5305), (8014)

RS (read stability) isolation level (5308), (8015)

RTRIM function (6240)

detailed format description (6647)

values and arguments, rules for (6648)

run-time authorization ID (5513), (5514)

Run-Time Services, static SQL support for (5156)

SALES sample table (8003)

sample database

erasing (7992)

installing (7991)

sample tables (7989), (8006)

SBCS (single-byte character set) data

within mixed data (5573)

SBCS (single-byte character set) data, description (5569)

scalar

INSERT (6173)

JULIAN_DAY (6177)

LEFT (6181)

MINUTE (6206)

scalar fullselect (5907)

scalar function (6371) See also function

scalar function, arguments for (6065)

scale of data (7891)

comparisons in SQL, overview (5727)

conversion of numbers in SQL (5696)

determined by SQLLEN variable (7903)

in results of arithmetic operations (5938)

scale of numbers

determined by SQLLEN variable (7910)

scale-integer, DECIMAL function (6455)

schema

controlling use of (5169)

CREATE SCHEMA statement (7213)

creating implicit schema, granting authority for (7511)

creating implicit schema, revoking authority for (7681)

definition of (5167)

privileges (5171)

SCHEMA clause

COMMENT ON statement (7082)

DROP statement (7428)

schema-name

description (5477)

reserved names (8010)

schema-name, description of (5480)

schemas

comment descriptions, adding to catalog (7070)

definition of (5168)

scope

adding with ALTER TABLE statement (6997)

adding with ALTER VIEW statement (7029)

defining in CAST specification (5996)

defining with added column (6986)

defining with CREATE TABLE statement (7251)

defining with CREATE VIEW statement (7335)

definition of (5669)

dereference operation (6000)

SCOPE clause

ALTER TABLE statement (6987), (6998)

ALTER VIEW statement (7030)

CREATE TABLE statement (7252)

CREATE VIEW statement (7336), (7337)

in CAST specification (5995)

scoped-ref-expression

in dereference operation (6001)

search condition

AND, logical operator (6049)

description (6054)

HAVING clause, arguments and rules (6855)

NOT, logical operator (6048)

OR, logical operator (6050)

order of evaluation (6058)

using WHERE clause, rules for (6826)

with DELETE, row selection (7386)

with UPDATE, applying changes to a match (7837)

SECOND function (6242)

SECOND function, returning second from value (6652)

security

CONNECT statement (7123)

SELECT clause

DISTINCT keyword, use in (6764)

GRANT statement (table or view) (7562)

list notation, column reference (6765)

REVOKE statement, removing privileges for (7717)

SELECT INTO statement (7747), (7754)

select list

application of, rules and syntax (6791)

description (6775)

notation rules and conventions (6782)

SELECT statement

cursor, rules regarding parameter markers (7369)

dynamic invocation, execution overview (6924)

fullselect, detailed syntax (6866)

interactive invocation, limitations on (6937)

invoking, usage summary (6905)

result table, OPEN statement, relation to cursor (7629)

select-statement (6880)

static invocation, execution overview (6923)

subselect (6763)

VALUES clause (6867)

select-statement

examples of (6900)

self-referencing row (5235), (5243)

self-referencing table (5236), (5244)

sequence values

generating (6524)

servername, description of (5482)

SET clause

UPDATE statement, column names and values (7832)

SET CONNECTION statement (7755), (7760)

successful connection, detailed description (7757)

unsuccessful connection, detailed description (7758)

SET CONSTRAINTS statement (7761), (7767)

SET CURRENT DEGREE statement (7769), (7772)

SET CURRENT EXPLAIN MODE statement (7774), (7777)

SET CURRENT EXPLAIN SNAPSHOT statement (7779), (7782)

SET CURRENT FUNCTION PATH statement (7794)

SET CURRENT PATH statement (7795)

SET CURRENT QUERY OPTIMIZATION statement (7784), (7787)

SET CURRENT SQLID statement (7810)

SET DEFAULT delete rule

description (5257)

SET EVENT MONITOR STATE statement (7789), (7792)

SET NULL delete rule (7267)

description (5256)

set operator

EXCEPT, comparing differences only (6871)

INTERSECT, role of AND in comparisons (6873)

result data type (5747)

UNION, correspondence to OR (6869)

SET PATH statement (7796)

SET SCHEMA statement (7809)

SET transition-variable statement (7812), (7815)

setting up document server (8063)

IN SHARE MODE (7110)

share locks (5298)

SHARE option, LOCK TABLE statement (7614)

shift-in character

not truncated by assignments (5716)

short identifier, SQL statement, definition (5438)

SIGN function (6244)

detailed format description (6654)

values and arguments, rules for (6655)

sign, as a numeric attribute (5585)

SIGNAL SQLSTATE statement (7817), (7823)

SIN function (6246)

detailed format description (6657)

values and arguments, rules for (6658)

single precision float data type (7229)

single row select (7749)

single-byte character set (SBCS) (5574) See also SBCS (single-byte character set) data

single-byte character set (SBCS), support for (5415)

single-precision floating-point (5606)

small integer

description (5590)

precision (5591)

range (5592)

SMALLINT data type (7225)

description (5587)

precision (5588)

range (5589)

SMALLINT function (6248)

SMALLINT function, small integer values from expressions (6662)

SMS table space

CREATE TABLESPACE statement (7297)

description (5382)

SOME in quantified predicate (6016)

sorting

ordering of results (5736)

string comparisons (5731)

SOUNDEX function (6250)

detailed format description (6664)

values and arguments, rules for (6665)

sourced function

description (5897)

space (5410)

SPACE function (6252)

detailed format description (6667)

values and arguments, rules for (6668)

spaces

rules governing (5422)

special characters, range of (5414)

special register (5791)

CURRENT DATE (5794), (5820)

CURRENT DEGREE (5796)

CURRENT EXPLAIN MODE (5798)

CURRENT EXPLAIN SNAPSHOT (5800)

CURRENT FUNCTION PATH (5806)

CURRENT NODE (5802)

CURRENT PATH (5807)

CURRENT QUERY OPTIMIZATION (5810)

CURRENT REFRESH AGE (5812)

CURRENT SCHEMA (5815)

CURRENT SERVER (5817), (5819)

CURRENT SQLID (5816)

CURRENT TIME (5822)

CURRENT TIMESTAMP (5824)

CURRENT TIMEZONE (5826)

interaction of Explain special registers (8049)

USER (5828)

specific function

comment descriptions, adding to catalog (7066)

SPECIFIC FUNCTION clause

COMMENT ON statement (7076)

SPECIFIC PROCEDURE clause

COMMENT ON statement (7081)

specific-name, description of (5484)

specification

CAST (5985)

SQL (Structured Query Language)

numbers (5581)

tokens (5417)

SQL comments, static statements, rules for (6950)

SQL identifiers

database identifier (5447)

long identifier (5445)

short identifier (5446)

SQL path (5663)

CURRENT PATH special register (5808)

resolution (5902)

SQL return code (6940)

SQL statement

ALTER BUFFERPOOL (6952), (6959)

ALTER NODEGROUP (6961)

ALTER TABLE (6976), (7010)

ALTER TABLESPACE (7013), (7017)

ALTER TYPE (Structured) (7019), (7025)

ALTER VIEW (7031)

BEGIN DECLARE SECTION (7034), (7040)

CALL (7043), (7046)

CLOSE (7048), (7051)

COMMENT ON (7054), (7090)

COMMIT (7092), (7103)

Compound SQL (7105), (7107)

CONNECT (Type 1) (7109), (7129)

CONNECT (Type 2) (7131), (7135)

CONTINUE, response to exception (7859)

CREATE ALIAS (7137), (7143)

CREATE BUFFERPOOL (7145), (7155)

CREATE DISTINCT TYPE (7157), (7161)

CREATE EVENT MONITOR (7163), (7166)

CREATE FUNCTION (7168), (7174), (7179)

CREATE FUNCTION (External Scalar) (7171)

CREATE FUNCTION (External Table) (7176)

CREATE FUNCTION (Sourced Scalar) (7184)

CREATE FUNCTION (Sourced) (7181)

CREATE INDEX (7186), (7202)

CREATE NODEGROUP (7204)

CREATE SCHEMA (7212), (7217)

CREATE TABLE (7219), (7290)

CREATE TABLESPACE (7292), (7308)

CREATE TRIGGER (7310), (7317)

CREATE TYPE (Structured) (7319), (7325)

CREATE VIEW (7327), (7354)

DECLARE CURSOR (7359), (7378)

DELETE (7380), (7391)

DESCRIBE (7393), (7399)

DISCONNECT (7402), (7403)

DROP (7406), (7436)

dynamic SQL, definition of (5146)

END DECLARE SECTION (7439), (7444)

EXECUTE (7447), (7460)

EXECUTE IMMEDIATE (7463), (7474)

EXPLAIN (7477), (7479)

FETCH (7482), (7494)

FREE LOCATOR (7497), (7499)

GRANT (Schema Prilvileges) (7538)

GRANT (Schema Privileges) (7531)

GRANT (Table Privileges) (7541), (7572)

GRANT (View Privileges) (7542), (7573)

immediate execution of dynamic SQL (5149)

INCLUDE (7575)

INSERT (7582), (7606)

interactive SQL, definition of (5147)

LOCK TABLE (7609), (7621)

OPEN (7624), (7643)

pg=end.ALTER NODEGROUP (6968)

pg=end.CREATE NODEGROUP (7210)

PREPARE (7646), (7665)

preparing and executing dynamic SQL (5148)

REFRESH TABLE (7668)

RELEASE (7672)

RENAME TABLE (7675), (7678)

REVOKE (Schema Prilvileges) (7702)

REVOKE (Schema Privileges) (7696)

REVOKE (Table Privileges) (7705), (7728)

REVOKE (View Privileges) (7706), (7729)

ROLLBACK (7731), (7745)

SELECT INTO (7748), (7753)

SET CONNECTION (7756), (7759)

SET CONSTRAINTS (7762), (7768)

SET CURRENT DEGREE (7770), (7773)

SET CURRENT EXPLAIN MODE (7775), (7778)

SET CURRENT EXPLAIN SNAPSHOT (7780), (7783)

SET CURRENT FUNCTION PATH (7797)

SET CURRENT PATH (7798)

SET CURRENT QUERY OPTIMIZATION (7785), (7788)

SET EVENT MONITOR STATE (7790), (7793)

SET PATH (7799)

SET SCHEMA (7806), (7811)

SET transition-variable (7813), (7816)

SIGNAL SQLSTATE (7818), (7824)

specific-name, conventions for (5485)

statement name, conventions for (5487)

static SQL, definition of (5145)

syntax conventions for (5135)

UPDATE (7826), (7845)

VALUES INTO (7848), (7852)

WHENEVER (7855), (7863)

WITH HOLD, cursor attribute (7364)

SQL statement syntax

case sensitive identifiers, rule for (5428)

cursor-name, definition of (5464)

escape character (5444)

specific-name, conventions for (5486)

statement name, conventions for (5488)

SQL Syntax

SQL syntax

AVG function, results on column set (6308)

basic predicate, detailed diagram (6008)

BETWEEN predicate, rules for (6019)

comparing two predicates, truth conditions (6009), (6043)

COUNT function, arguments and results (6318)

COUNT_BIG function, arguments and results (6329)

data types, overview (5515)

dates, detailed description (5624)

DISTINCT keyword, queries, role of (6302)

executable statements, embedded usage (6915)

EXISTS predicate, detailed format description (6023)

GENERATE_UNIQUE function, arguments and results (6522)

GROUP BY clause, use in subselect (6836)

IN predicate, detailed format description (6028)

LIKE predicate, rules for (6033)

multiple operations, order of execution (6878)

naming conventions, listing of, definitions (5451)

non-executable statements, embedded usage (6916)

null value, definition of (5535)

scale of data in SQL (5623)

search conditions, detailed formats and rules (6052)

SELECT clause, detailed description (6766)

SELECT statement, invocation methods (6906)

STDDEV function, results on column set (6349)

times, detailed description (5625)

TYPE predicate, detailed diagram (6042)

values, overview (5521)

VARIANCE function, results on column set (6364)

WHERE clause, search conditions for (6827)

SQL92

setting rules for dynamic SQL (7808)

SQLCA (SQL communication area) (7879)

entry changed by UPDATE (7841)

SQLCA (SQL communication area) clause

INCLUDE statement (7578)

SQLCA structure, overview (6942)

SQLCODE

description (6943)

return code values, table (6944)

SQLD field in SQLDA (7885)

description (7899)

SQLDA

host variable descriptions, OPEN statement (7635)

prepared statement information, storing (7651)

SQLDA (SQL descriptor area) (7880)

contents (7892)

FETCH statement (7489)

SQLDA (SQL descriptor area) clause

INCLUDE statement, specifying (7579)

SQLDA area, required variables for DESCRIBE (7397)

SQLDABC field in SQLDA (7883)

description (7897)

SQLDAID field in SQLDA

description (7896)

SQLDATALEN field in SQLDA

description (7908)

SQLDATATYPE_NAME field in SQLDA

description (7909)

SQLERROR clause

WHENEVER statement (7857)

SQLIND field in SQLDA (7888)

description (7904)

SQLLEN field in SQLDA (7887)

description (7902)

SQLLONGLEN field in SQLDA

description (7907)

SQLN field in SQLDA (7884)

description (7898)

SQLNAME field in SQLDA (7889)

description (7905)

SQLSTATE

sqlstate

description (6945)

in RAISE_ERROR function (6624)

in SIGNAL SQLSTATE statement (7821)

ISO/ANSI SQL92 standard, relation to (6946)

SQLTYPE field in SQLDA (7886)

description (7901)

SQLVAR field in SQLDA (7890)

base (7900)

secondary (7906)

SQLWARNING clause

WHENEVER statement (7858)

SQRT function (6254)

detailed format description (6670)

values and arguments, rules for (6671)

STAFF sample table (8004)

STAFFG sample table (8005)

standards

setting rules for dynamic SQL (7807)

starting a new unit of work (7739)

statement string, PREPARE statement, rules for (7655)

statement string, rules for creating (7471)

statement-name, description of (5481)

states

connection (5345)

static select (6928)

static SQL

DECLARE CURSOR statement, usage in (6925)

definition of (5142)

FETCH statement, usage in (6927)

invoking (6907), (6929)

OPEN statement, usage in (6926)

source code, differences from dynamic SQL (5154)

statistics

updating (7955), (7957), (7963)

STDDEV function (6256)

STDDEV function, detailed description (6352)

storage

backing out, unit of work, ROLLBACK (7735)

storage structures

ALTER BUFFERPOOL statement (6953)

ALTER TABLESPACE statement (7014)

buffer pool (5386)

CREATE BUFFERPOOL statement (7147)

CREATE TABLESPACE statement (7295)

description (5377)

nodegroup (5388)

table space (5378)

stored procedures

CALL statement (7044)

string

assignment

conversion rules (5708)

BLOB (5546)

CLOB (5541)

constant

character (5785)

hexadecimal (5788)

definition (5356)

expression (5912)

LOB (5537)

operand (5914)

string limits (7872)

Structured Query Language (SQL)

assignment operation, overview (5682)

basic operands, assignments and comparisons (5678)

character strings, overview of (5552)

characters, range of (5400)

comments, rules for (5405)

comparison operation, overview (5684)

constants, definition of (5766)

double byte character set (DBCS), considerations (5401)

identifiers, definition of

delimited identifier, description (5431)

ordinary identifiers, description (5430)

spaces, definition of (5404)

tokens, definition of

delimiter tokens (5403)

ordinary tokens (5402)

values

data types for (5520)

overview (5518)

sources of (5519)

variable names used (5453)

structured type

description (5665)

DROP statement (7417)

sub-total rows (6844)

subject table of trigger (5267)

subquery

HAVING clause (6857)

in HAVING clause, execution of (6858)

in WHERE clause (6830)

subquery, fullselect use as, search conditions (5857)

subselect (6759)

definition (6760)

examples of (6859)

FROM clause, relation to subselect (6761)

sequence of operations, example (6762)

SUBSTR function (6258)

SUBSTR function, returning substring from string (6675)

substrings

cautions and restrictions (6679)

length, defining (6678)

locating in string (6676)

start, setting (6677)

SUM function (6260)

detailed format description (6353)

values and arguments, rules for (6354)

SUMMARY table

in CREATE TABLE statement (7223)

summary tables

REFRESH TABLE statement (7669)

super-aggregate rows (6846)

super-groups (6842)

supertype

supertype name, conventions for (5490)

supertype-name, description (5489)

symetric super-aggregate rows (6847)

synonym

CREATE ALIAS statement (7139)

DROP ALIAS statement (7421)

qualifying a column name (5841)

syntax diagrams

description (5134)

system administration privilege (5370)

system control privilege (5374)

system maintenance privilege (5376)

system managed space (5383) See also SMS table space

system-containers

CREATE TABLESPACE statement (7298)

table (5136), (7987)

adding a column, ALTER TABLE (6982)

alias (7140), (7422)

authorization for creating (7221)

authorization ID, use in name (5506)

base table (5173)

catalog views for use with structured types (7965)

catalog views on system tables (7914)

changing definition (6977)

collocation (5398)

comment descriptions, adding to catalog (7059)

common table expression (5280)

control privilege, granting (7551)

creating a table, granting authority for (7509)

creating, SQL statement instructions (7220)

definition of (5172)

deleting, using DROP statement (7409)

dependent (5247)

descendent (5246)

designator, use to avoid ambiguity (5851)

exception (7764), (8052)

exposed or non-exposed names, FROM clause (5846)

foreign key (5206)

FROM clause, subselect, naming conventions (6802)

index creation, requirements of (7188)

nested table expression, use of (5866)

parent (5224), (5245)

partitioning key (5209)

partitioning map (5397)

primary key (5202)

privileges, granting (7544)

qualifying a column name (5838)

renaming, requirements of (7676)

restricting shared access, LOCK TABLE statement (7612)

result table (5174)

revoking privileges for (7707)

row, inserting (7584)

sample (7988)

scalar fullselect, use of (5863)

schema (7214)

self-referencing (5248)

space (5379), (7146), (7293), (7430)

subquery, use of (5860)

table name, conventions for (5492)

table-reference (6808)

temporary, OPEN statement, use of (7641)

unique correlation names as table designators (5870)

unique key (5199)

updating by row and column, UPDATE statement (7829)

table check constraint

description (5261)

TABLE clause

COMMENT ON statement (7083)

DROP statement (7429)

table expression

common-table-expression (6884)

description (5278)

table join

partitioning key considerations (7286)

table space

comment descriptions, adding to catalog (7063)

deleting, using DROP statement (7413)

description (5384)

identification

CREATE TABLE statement (7278)

index

CREATE TABLE statement (7279)

name description (5494)

pagesize (7296)

table-name

in ALTER TABLE statement (6979)

in CREATE TABLE statement (7224)

in FROM clause (6806)

in LOCK TABLE statement (7613)

in SELECT clause, syntax diagram (6771)

table-name, description (5491)

table-reference

alias (6816)

nested table expressions (6815)

table-name (6809)

view-name (6810)

tables

distributed relational database, use in (5323)

TABLESPACE clause

COMMENT ON statement (7084)

tablespace-name, description (5493)

TABLE_NAME function (6262)

alias (6682)

TABLE_SCHEMA function (6264)

alias (6685)

TAN function (6266)

detailed format description (6687)

values and arguments, rules for (6688)

temporary tables in OPEN (7640)

terminating

unit of work (7096), (7737)

terminating a unit of work (7736)

time

arithmetic operations, rules for (5969)

as data type (5532)

CHAR, use of in format conversion (6405)

duration, format of (5958)

expression, using in (6693)

hour values, using in an expression (HOUR) (6535)

microsecond, returning from datetime value (6581)

minute, returning from datetime value (6588)

returning values based on time (6694)

second, returning from datetime value (6653)

strings (5649)

timestamp

internal representation of (5632)

length of string (5633)

timestamp, as data type (5533)

timestamp, returning from values (6698)

TIME data type (7245)

time data type (5629)

TIME function (6268)

TIME function, using time in an expression (6692)

TIMESTAMP

timestamp

arithmetic operations (5975)

as data type (5534)

data definition (5631)

duration (5960)

from GENERATE_UNIQUE result (6525)

multi-byte character string (MBCS) restriction (5656)

string representation format (5655)

WEEK scalar function, using (6748)

TIMESTAMP data type (7246)

TIMESTAMP function (6270)

TIMESTAMP function, returning from values (6697)

TIMESTAMPDIFF function (6274)

detailed format description (6703)

values and arguments, rules for (6704)

TIMESTAMP_ISO function (6272)

detailed format description (6700)

values and arguments, rules for (6701)

TO clause

GRANT statement (7516), (7522), (7528), (7535), (7567)

tokens

as language element (5408)

delimiter tokens, definition of (5421)

ordinary tokens, definition of (5420)

spaces, rules governing (5423)

upper and lower case, support for (5426)

transform

DROP statement (7418)

transition tables in triggers (5275)

transition variables in triggers (5274)

TRANSLATE function (6276)

character string, using with (6708)

graphic string, using with (6707)

rules and restrictions (6709)

translation table (6710)

trigger

and constraints (8030)

CREATE TRIGGER statement (7311)

DROP statement (7431)

errors executing (7314)

Explain tables (8033)

inoperative (7312)

interactions (8029)

name description (5495)

TRIGGER clause

COMMENT ON statement (7085)

triggered SQL statement

SET transition-variable statement (7814)

SIGNAL SQLSTATE statement (7819)

triggers

activation (5264)

activation time (5270)

cascading (5276)

comment descriptions, adding to catalog (7069)

description (5265)

event (5269)

granularity (5272)

INSERT statement (7600)

set of affected rows (5271)

subject table (5268)

triggered action (5273)

uses of (5266)

TRUNC or TRUNCATE function (6278)

detailed format description (6715)

values and arguments, rules for (6716)

truncation of numbers (5695)

truth table (6057)

truth valued logic, search conditions, rules for (6051)

type

type name, conventions for (5497)

TYPE clause

COMMENT ON statement (7086)

DROP statement (7432)

TYPE predicate, detailed format (6040)

type-name, description (5496)

typed-table

typed-table name, conventions for (5499)

typed-table-name, description (5498)

typed-view

typed-view name, conventions for (5501)

typed-view-name, description (5500)

TYPE_ID function (6280)

data type (6719)

TYPE_NAME function (6282)

data type (6722)

TYPE_SCHEMA function (6284)

data type (6725)

UCASE function (6286)

detailed format description (6727)

values and arguments, rules for (6728)

unary

minus sign, results of (5925)

plus sign, results of (5924)

uncommitted changes, relation to locks (5292)

uncommitted read (5314), (8025)

unconnected state (5344)

undefined reference, error conditions for (5855)

UNDER clause

CREATE VIEW statement (7332)

UNION clause, role in comparison

of fullselect (6870)

UNIQUE clause

ALTER TABLE statement (6991)

CREATE INDEX statement (7190)

CREATE TABLE statement (7256)

unique constraint (5204), (5215)

adding or dropping, ALTER TABLE (6972)

ALTER TABLE statement (6990)

CREATE TABLE statement (7255)

unique correlation names as table designators (5871)

UNIQUE key

unique key (5197), (5200), (5214)

ALTER TABLE statement (6988)

CREATE TABLE statement (7254)

unique values

generating (6523)

unit of work

COMMIT (7094)

description (5294)

destroying prepared statements (7664)

initiating closes cursors (7639)

referring to prepared statements (7649)

ROLLBACK statement, effect of (7733)

terminating (7095)

terminating destroys prepared statements (7662)

terminating without saving changes (7732)

unknown condition

null value (6045)

updatable

view (7345)

UPDATE clause

GRANT statement (7565)

REVOKE statement, removing privileges for (7718)

update locks (5302)

UPDATE statement (7825), (7846)

row fullselect (7835)

updating statistics (7954), (7956), (7962)

uppercase, folding to (5429)

UR (uncommitted read) isolation level (5315), (8016)

USA (5648) See also datetime format

USA date format (5639)

USA time format (5651)

USER special register (5827)

user-defined data type

distinct-type-name

CREATE TABLE statement (7247)

user-defined function (6754)

CREATE FUNCTION (External Scalar) statement (7172)

CREATE FUNCTION (External Table) statement (7177)

CREATE FUNCTION (Sourced) statement (7182)

CREATE FUNCTION statement (7169)

description (5895)

DROP statement (7415)

GRANT (Database Authorities) statement (7510)

REVOKE (Database Authorities) statement (7680)

user-defined type

comment descriptions, adding to catalog (7064)

description (5659)

user-defined types

casting (5675)

USING clause

EXECUTE statement (7450)

FETCH statement (7488)

OPEN statement, listing host variables (7630)

USING DESCRIPTOR (7456)

USING DESCRIPTOR clause

EXECUTE statement (7455)

OPEN statement (7633)

VALUE function (6288), (6732)

value in SQL (5517)

value, data definition of (5178)

VALUES clause

fullselect (6868)

INSERT statement, loading one row (7591)

number of values, rules for (7592)

VALUES INTO statement (7847), (7853)

VARCHAR

DOUBLE scalar function, using (6503)

function (6734)

VARCHAR data type (7235)

VARCHAR function (6290)

VARCHAR strings

attributes, summary (5562)

restrictions on usage (5563)

VARCHAR(26)

WEEK scalar function, using (6746)

VARGRAPHIC

function (6738)

VARGRAPHIC function (6292)

VARGRAPHIC strings

attributes, summary (5577)

restrictions on usage (5578)

VARIANCE function, detailed description (6367)

VARIANCE or VAR function (6294)

view

alias (7141), (7423)

authorization ID, use in name (5507)

comment descriptions, adding to catalog (7058)

control privilege

granting (7552)

limitations on (7553)

creating (7328)

deletable (7344)

deleting, using DROP statement (7410)

description (5185)

exposed or non-exposed names, FROM clause (5847)

foreign key, referential constraints (5186)

FROM clause, subselect, naming conventions (6803)

index, relation to view (5192)

inoperative (7351)

insertable (7348)

preventing view definition loss, WITH CHECK OPTION (7843)

privileges, granting (7543)

qualifying a column name (5839)

read-only (7350)

revoking privileges for (7708)

row, inserting in viewed table (7585)

schema (7215)

updatable (7346)

updating rows by columns, UPDATE statement (7830)

validity and usage rules when revoking privilege (7723)

view name, conventions for (5503)

WITH CHECK OPTION, effect on UPDATE (7844)

VIEW clause

CREATE VIEW statement (7329)

DROP statement (7434)

view-name

description of (5502)

in ALTER VIEW statement (7028)

in FROM clause (6807)

in SELECT clause, syntax diagram (6772)

warning return code (6941)

WEEK

function (6745)

WEEK function (6296)

WHENEVER statement (7854), (7864)

WHENEVER statement, changing flow of control (6913)

WHERE clause

DELETE statement, row selection (7385)

search function, subselect, rules for (6825)

UPDATE statement, conditional search (7836)

WHERE CURRENT OF clause

DELETE statement, use of DECLARE CURSOR (7388)

UPDATE statement (7838), (7839)

wildcard character

LIKE predicate, values for (6034)

WITH CHECK OPTION clause

CREATE VIEW statement (7340)

WITH clause

CREATE VIEW statement (7338)

INSERT statement (7595)

WITH common-table-expression (6881)

WITH DEFAULT clause

ALTER TABLE statement (6983)

WITH GRANT OPTION clause

GRANT statement (7569)

WITH HOLD clause

DECLARE CURSOR statement (7363)

WITH OPTIONS clause

CREATE VIEW statement (7334)

WORK

in COMMIT statement (7093)

in ROLLBACK statement (7738)

YEAR function (6298)

YEAR function, using in expressions (6751)

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

[ DB2 List of Books | Search the DB2 Books ]