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 V