Index

Special Characters
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Special Characters
  • " (quotation mark) (4378)
  • ' (apostrophe) (4377), (4632), (4640)
  • * (asterisk) (4831), (4838)
  • in subselect (5091)
  • * (multiply) (4740)
  • ** (exponentiation) (4741)
  • *ALL (read stability) precompiler option (4281)
  • *APOST precompiler option (4653)
  • *APOSTSQL precompiler option (4651)
  • *CHG (uncommitted read) precompiler option (4291)
  • *CNULRQD precompiler option (4591), (5882), (6248), (6299)
  • *CS (cursor stability) precompiler option (4286)
  • *DMY date and time format (4532)
  • *EUR date and time format (4526), (4554)
  • *HMS date and time format (4558)
  • *ISO date and time format (4527), (4555)
  • *JIS date and time format (4528), (4556)
  • *JUL date and time format (4530)
  • *MDY date and time format (4531)
  • *NC (no commit) precompiler option (4296)
  • *NOCNULRQD precompiler option (4587), (4592), (5883), (6249), (6300)
  • *NONE (no commit) precompiler option (4297)
  • *PUBLIC
  • authority (4355)
  • *QUOTE precompiler option (4654)
  • *QUOTESQL precompiler option (4652)
  • *RR (repeatable read) precompiler option (4275)
  • *RS (read stability) precompiler option (4280)
  • *UR (uncommitted read) precompiler option (4290)
  • *USA date and time format (4529), (4557)
  • *YMD date and time format (4533)
  • + (addition) (4744)
  • - (subtraction) (4743)
  • / (divide) (4742)
  • ? (question mark) (5832) See also parameter marker
  • || (concatenation operator) (4728)
    • A
  • ABS function (4874)
  • ABSVAL function (4873)
  • access plan and packages (4252)
  • ACOS function (4876)
  • activation group (4260)
  • ADD check-constraint clause
  • ALTER TABLE statement (5236)
  • ADD COLUMN clause
  • in ALTER TABLE statement (5167)
  • ADD unique-constraint clause
  • ALTER TABLE statement (5206)
  • AFTER clause
  • in FETCH statement (5856), (5858), (5864)
  • alias See also CREATE ALIAS statement
  • description (4250), (4426)
  • dropping (5783)
  • ALIAS clause
  • COMMENT ON statement (5296)
  • CREATE ALIAS statement (5352)
  • DROP statement (5781)
  • LABEL ON statement (6002)
  • alias-name
  • description (4390)
  • in CREATE ALIAS statement (5353)
  • in DROP statement (5782)
  • in LABEL ON statement (6003)
  • ALL clause
  • clause of subselect (5088)
  • DISCONNECT statement (5772)
  • GRANT (function or procedure privileges) statement (5902)
  • GRANT (package privileges) statement (5918)
  • GRANT (type privileges) statement (5954)
  • in USING clause
  • DESCRIBE statement (5732)
  • DESCRIBE TABLE statement (5759)
  • PREPARE statement (6068)
  • keyword
  • AVG function (4826)
  • COUNT function (4830)
  • COUNT_BIG function (4837)
  • MAX function (4844)
  • MIN function (4848)
  • STDDEV function (4852)
  • SUM function (4856)
  • VAR function (4860)
  • VARIANCE function (4861)
  • quantified predicate (4798)
  • RELEASE statement (6086)
  • REVOKE (function or procedure privileges) statement (6105)
  • REVOKE (package privileges) statement (6121)
  • REVOKE (table privileges) statement (6135)
  • REVOKE (type privileges) statement (6155)
  • ALL PRIVILEGES clause
  • GRANT (function or procedure privileges) statement (5903)
  • GRANT (package privileges) statement (5919)
  • GRANT (table privileges) statement (5930)
  • GRANT (type privileges) statement (5955)
  • REVOKE (function or procedure privileges) statement (6106)
  • REVOKE (package privileges) statement (6122)
  • REVOKE (table privileges) statement (6134)
  • REVOKE (type privileges) statement (6156)
  • ALL SQL clause
  • DISCONNECT statement (5773)
  • RELEASE statement (6087)
  • ALLOCATE clause
  • CREATE TABLE statement (5508)
  • ALLOW READ clause
  • in LOCK TABLE statement (6026), (6027)
  • ALTER clause
  • GRANT (function or procedure privileges) statement (5904)
  • GRANT (package privileges) statement (5920)
  • GRANT (table privileges) statement (5933)
  • GRANT (type privileges) statement (5956)
  • REVOKE (function or procedure privileges) statement (6107)
  • REVOKE (package privileges) statement (6123)
  • REVOKE (table privileges) statement (6136)
  • REVOKE (type privileges) statement (6157)
  • ALTER COLUMN clause
  • ALTER TABLE statement (5193)
  • ALTER TABLE statement (5163), (5252)
  • ALWBLK clause
  • in SET OPTION statement (6195)
  • ALWCPYDTA clause
  • in SET OPTION statement (6196)
  • ambiguous reference (4691)
  • AND
  • operator in search condition (5001)
  • truth table (4818)
  • ANTILOG function (4878)
  • ANY clause
  • in USING clause
  • DESCRIBE statement (5730)
  • DESCRIBE TABLE statement (5757)
  • PREPARE statement (6066)
  • quantified predicate (4797)
  • application process (4257)
  • application program
  • SQLCA (6328)
  • C (6331)
  • COBOL (6334)
  • FORTRAN (6337)
  • ILE RPG/400 (6346)
  • PL/I (6340)
  • RPG/400 (6343)
  • SQLDA
  • C (6376)
  • COBOL (6379)
  • description (6349)
  • ILE COBOL (6382)
  • ILE RPG/400 (6386)
  • PL/I (6385)
  • application requester (4303), (4308), (6395)
  • application server (4304), (4309), (6396)
  • application-directed distributed unit of work (4319)
  • arithmetic operators (4731)
  • ARRAY clause
  • SET RESULT SETS statement (6222)
  • AS clause (5137)
  • clause of subselect (5094)
  • CREATE VIEW statement (5585)
  • FROM clause of UPDATE (6254)
  • in FROM clause of DELETE (5695)
  • AS LOCATOR clause
  • in CREATE FUNCTION statement (5378), (5382), (5446)
  • in DECLARE PROCEDURE statement (5651)
  • ASC clause
  • CREATE INDEX statement (5410)
  • of select-statement (5138)
  • ASIN function (4880)
  • assignment
  • conversion rules (4594)
  • DataLink (4606)
  • date and time values (4599)
  • distinct type (4608)
  • numbers (4581), (4584)
  • strings (4586)
  • asterisk (*)
  • in COUNT function (4835)
  • in COUNT_BIG function (4842)
  • in subselect (5090)
  • ATANH function (4883)
  • authorization
  • description (4350)
  • privileges (4352)
  • authorization ID
  • description (4427)
  • authorization-name
  • definition (4391)
  • description (4429)
  • in CONNECT (Type 1) statement (5328)
  • in CONNECT (Type 2) statement (5342)
  • in CREATE SCHEMA statement (5469)
  • in GRANT (function or procedure privileges) statement (5911)
  • in GRANT (package privileges) statement (5923)
  • in GRANT (table privileges) statement (5945)
  • in GRANT (type privileges) statement (5959)
  • in REVOKE (function or procedure privileges) statement (6115)
  • in REVOKE (package privileges) statement (6128)
  • in REVOKE (table privileges) statement (6149)
  • in REVOKE (type privileges) statement (6162)
  • AVG function (4827)
    • B
  • base table (4181)
  • basic operations in SQL (4568)
  • basic predicate (4793)
  • BEFORE clause
  • in FETCH statement (5855), (5857), (5863)
  • BEGIN DECLARE SECTION statement (5254), (5258)
  • BETWEEN predicate (4800)
  • bibliography (6452)
  • big integers (4500)
  • BIGINT
  • data type for CREATE PROCEDURE (5424)
  • data type for CREATE TABLE (5485)
  • data type for DECLARE PROCEDURE (5629)
  • BIGINT data type (4499)
  • BIGINT function (4885)
  • binary data string
  • constants (4629)
  • binary large object (BLOB)
  • data type (4468)
  • description (4471)
  • binary string
  • description (4436)
  • bind (4167)
  • bit data (4453)
  • BLOB
  • CREATE PROCEDURE statement (5435)
  • data type (4434), (4467)
  • data type for CREATE TABLE (5494)
  • DECLARE PROCEDURE statement (5640)
  • description (4470)
  • BLOB function (4887)
  • BOTH clause
  • in USING clause
  • DESCRIBE statement (5731)
  • DESCRIBE TABLE statement (5758)
  • PREPARE statement (6067)
  • built-in function (4823) See also function
    • C
  • C
  • application program
  • host variable (4708)
  • host structure arrays (4716)
  • host variable (4699)
  • SQLCA (SQL communication area) (6333)
  • SQLDA (SQL descriptor area) (6375)
  • call level interface (CLI) (4177)
  • CALL statement (5260), (5276)
  • calling
  • procedures, external (5261)
  • CASCADE clause
  • DROP statement (5812)
  • in DROP COLUMN of ALTER TABLE statement (5203)
  • in DROP constraint of ALTER TABLE statement (5250)
  • CASCADE delete rule
  • description (4237)
  • in ALTER TABLE statement (5223)
  • in CREATE TABLE statement (5550)
  • CASCADED CHECK OPTION clause
  • CREATE VIEW statement (5590)
  • CASE expression (4784)
  • CAST specification (4787)
  • cast-function
  • ALTER TABLE statement (5180), (5269)
  • CREATE TABLE statement (5520)
  • INSERT statement (5986)
  • catalog (4256), (6410)
  • catalog table
  • SYSPARMS (6436)
  • SYSROUTINES (6442)
  • SYSTYPES (6446)
  • catalog view
  • description (6408)
  • SQL_LANGUAGES (6411)
  • SYSCHKCST (6415)
  • SYSCOLUMNS (6417)
  • SYSCST (6419)
  • SYSCSTCOL (6421)
  • SYSCSTDEP (6423)
  • SYSFUNCS (6425)
  • SYSINDEXES (6427)
  • SYSKEYCST (6429)
  • SYSKEYS (6431)
  • SYSLANGS (6412)
  • SYSPACKAGE (6435)
  • SYSPROCS (6438)
  • SYSREFCST (6440)
  • SYSTABLES (6444)
  • SYSVIEWDEP (6448)
  • SYSVIEWS (6450)
  • CCSID (coded character set identifier)
  • default (4348)
  • definition (4346)
  • specifying
  • in SQLDATA (6371)
  • in SQLNAME (6372)
  • values (6391), (6392)
  • CCSID clause
  • CREATE PROCEDURE statement (5419)
  • CREATE TABLE statement (5512)
  • DECLARE PROCEDURE statement (5624)
  • DECLARE VARIABLE statement (5681)
  • CDRA (Character Data Representation Architecture) (4344)
  • CEILING function (4889)
  • CHAR
  • data type (4438)
  • data type for CREATE PROCEDURE (5420)
  • data type for CREATE TABLE (5495)
  • data type for DECLARE PROCEDURE (5625)
  • function (4891)
  • character conversion (4332)
  • character set (4333)
  • code page (4335)
  • code point (4337)
  • coded character set (4339)
  • encoding scheme (4340)
  • substitution character (4342)
  • Character Data Representation Architecture (CDRA) (4345)
  • character data string
  • assignment (4585)
  • bit data (4452)
  • comparison (4613)
  • constants (4637)
  • description (4440)
  • empty (4444)
  • mixed data (4456)
  • SBCS data (4454)
  • character large object (CLOB)
  • data type (4474)
  • description (4477)
  • character set (4334)
  • CHARACTER_LENGTH function (4895)
  • CHAR_LENGTH function (4896)
  • check
  • ALTER TABLE statement (5238)
  • CHECK clause
  • ALTER TABLE statement (5192), (5239)
  • CREATE TABLE statement (5532), (5560)
  • check constraint (4243)
  • effect on insert (5995)
  • effect on update (6274)
  • CHECK OPTION clause
  • CREATE VIEW statement (5588)
  • effect on update (6276)
  • check-condition
  • in CHECK clause of ALTER TABLE statement (5240)
  • CLOB
  • CREATE PROCEDURE statement (5436)
  • data type (4473)
  • data type for CREATE TABLE (5498)
  • DECLARE PROCEDURE statement (5641)
  • description (4476)
  • CLOB function (4898)
  • CLOSE statement (5277), (5282)
  • closed state of cursor (6048)
  • CLOSQLCSR clause
  • in SET OPTION statement (6197)
  • CNULRQD clause
  • in SET OPTION statement (6198)
  • COALESCE function (4900)
  • COBOL
  • application program
  • host structure arrays (4714)
  • host variable (4696), (4707)
  • integers (4496)
  • varying-length string variables (4448)
  • SQLCA (SQL communication area) (6336)
  • SQLDA (SQL descriptor area) (6378), (6381)
  • code page (4336)
  • code point (4338)
  • coded character set identifier (CCSID) (4347) See also CCSID (coded character set identifier)
  • collection
  • creating (5361)
  • description (4178)
  • dropping (5787)
  • COLLECTION clause
  • CREATE COLLECTION statement (5362), (5363)
  • DROP statement (5786)
  • collection-name
  • definition (4392)
  • in CREATE COLLECTION (5364)
  • in CREATE SCHEMA statement (5468)
  • in DROP statement (5788)
  • column
  • definition (4180)
  • length attribute (4445)
  • name
  • in a result (5100)
  • qualified (4682)
  • rules (5134)
  • system column name (4186)
  • COLUMN clause
  • COMMENT ON statement (5297)
  • LABEL ON statement (6004)
  • column function (4824) See also function
  • column-name
  • definition (4393)
  • in ADD PRIMARY clause of ALTER TABLE statement (5213)
  • in ADD UNIQUE clause of ALTER TABLE statement (5210)
  • in ALTER TABLE statement (5168), (5194)
  • in CREATE TABLE statement (5479), (5537), (5539), (5544), (5547)
  • in CREATE VIEW statement (5580)
  • in DROP COLUMN of ALTER TABLE statement (5202)
  • in FOREIGN KEY clause of ALTER TABLE statement (5218)
  • in INSERT statement (5978)
  • in LABEL ON statement (6005)
  • in REFERENCES clause of ALTER TABLE statement (5221)
  • in UPDATE statement (6257)
  • comment
  • in catalog table (5285)
  • SQL (4366), (5162)
  • COMMENT ON statement (5283), (5309)
  • name qualification (4683)
  • COMMIT
  • effect on SET TRANSACTION (6238)
  • COMMIT clause
  • in SET OPTION statement (6199)
  • commit point (5317)
  • COMMIT statement (5311), (5321)
  • commitment control (4274) See also isolation level
  • commitment definition (4261)
  • common table expression clause
  • of select-statement (5135)
  • comparison
  • compatibility rules (4574), (4577)
  • conversion rules (4615)
  • date and time values (4616)
  • distinct type values (4618)
  • numbers (4610)
  • strings (4614)
  • compatibility
  • data types (4572), (4575)
  • rules (4573), (4576)
  • composite key (4193)
  • CONCAT (concatenation operator) (4727)
  • CONCAT function (4902)
  • concatenation operator (CONCAT) (4726)
  • concurrency (4258)
  • with LOCK TABLE statement (6020)
  • CONNECT
  • differences, type 1 and type 2 (6405)
  • CONNECT (Type 1) statement (5324), (5335)
  • CONNECT (Type 2) statement (5337), (5349)
  • connected state (4328)
  • connection
  • changing with SET CONNECTION (6186)
  • ending (6080)
  • releasing (6079)
  • SQL (4317)
  • connection states
  • activation group (4327)
  • CONNECT (Type 2) statement (4316)
  • distributed unit of work (4318)
  • remote unit of work (4315)
  • constant
  • in ALTER TABLE statement (5174), (5181)
  • in CALL statement (5265), (5270)
  • in CREATE TABLE statement (5521)
  • in INSERT statement (5980), (5987)
  • in LABEL ON statement (6013)
  • constants
  • binary string (4630)
  • character string (4638)
  • decimal (4627)
  • floating point (4625)
  • graphic string (4646)
  • hexadecimal (4635), (4643)
  • integer (4623)
  • CONSTRAINT clause
  • in ALTER TABLE statement (5187), (5205), (5215), (5235)
  • in CREATE TABLE statement (5527), (5533), (5542), (5558)
  • constraint-name
  • description (4394)
  • in ALTER TABLE statement (5188), (5207), (5237)
  • in CONSTRAINT clause of ALTER TABLE statement (5216)
  • in CREATE TABLE statement (5528), (5534), (5541), (5559)
  • in DROP CHECK clause of ALTER TABLE statement (5246)
  • in DROP CONSTRAINT clause of ALTER TABLE statement (5248)
  • in DROP FOREIGN KEY clause of ALTER TABLE statement (5242)
  • in DROP UNIQUE clause of ALTER TABLE statement (5244)
  • CONTAINS SQL clause
  • in CREATE FUNCTION (5386)
  • in CREATE PROCEDURE (5451)
  • in DECLARE PROCEDURE (5656)
  • CONTINUE clause
  • WHENEVER statement (6306)
  • control characters (4364)
  • conversion of numbers
  • conversion rule for comparisons (4593)
  • scale and precision (4583)
  • correlated reference (4694)
  • correlation name
  • defining (4687)
  • description (4395)
  • FROM clause
  • of subselect (5109)
  • qualifying a column name (4685)
  • correlation-name
  • in DELETE statement (5696)
  • in UPDATE statement (6255)
  • COS function (4904)
  • COSH function (4906)
  • COT function (4908)
  • COUNT function (4832), (4836)
  • COUNT_BIG function (4839), (4843)
  • CREATE ALIAS statement (4249), (5350), (5357)
  • CREATE COLLECTION statement (5359), (5368)
  • CREATE DISTINCT TYPE statement (5370), (5375)
  • CREATE INDEX statement (5400), (5413)
  • *PUBLIC authority (4358)
  • CREATE PROCEDURE statement (5415), (5417), (5464)
  • CREATE SCHEMA statement (5466), (5473)
  • CREATE TABLE statement (5475), (5571), (5573)
  • *PUBLIC authority (4356)
  • CREATE VIEW statement (4246), (5575), (5598)
  • *PUBLIC authority (4357)
  • CROSS JOIN clause
  • in FROM clause (5117)
  • CS (cursor stability) (4287)
  • CURDATE function (4910)
  • CURRENT clause
  • in DISCONNECT statement (5771)
  • in FETCH statement (5865)
  • in RELEASE statement (6085)
  • current connection state (4323)
  • CURRENT DATE special register (4656)
  • CURRENT PATH special register (4660)
  • CURRENT SERVER special register (4664)
  • CURRENT TIME special register (4670)
  • CURRENT TIMESTAMP special register (4672)
  • CURRENT TIMEZONE special register (4676)
  • CURRENT_DATE
  • ALTER TABLE statement (5177), (5183)
  • CREATE TABLE statement (5517), (5523)
  • CURRENT_DATE special register (4657)
  • CURRENT_PATH special register (4661)
  • CURRENT_SERVER special register (4665)
  • CURRENT_TIME
  • ALTER TABLE statement (5178), (5184)
  • CREATE TABLE statement (5518), (5524)
  • CURRENT_TIME special register (4671)
  • CURRENT_TIMESTAMP
  • ALTER TABLE statement (5179), (5185)
  • CREATE TABLE statement (5519), (5525)
  • CURRENT_TIMESTAMP special register (4673)
  • CURRENT_TIMEZONE special register (4677)
  • cursor (4397) See also cursor-name, DECLARE CURSOR statement
  • active set (6039)
  • closed by error
  • FETCH statement (5879)
  • UPDATE (6284)
  • closed state (6047)
  • closing (5279)
  • current row (5878)
  • defining (5603)
  • moving position (5854)
  • positions for open (5877)
  • preparing (6038)
  • cursor stability (4285)
  • cursor-name
  • description (4396)
  • in CLOSE statement (5280)
  • in DECLARE CURSOR statement (5604)
  • in DELETE statement (5700)
  • in FETCH statement (5867)
  • in OPEN statement (6040)
  • in SET RESULT SETS statement (6221)
  • in UPDATE statement (6268)
  • CURTIME function (4912)
    • D
  • DATA DICTIONARY clause
  • CREATE COLLECTION statement (5367)
  • CREATE SCHEMA statement (5472)
  • data representation
  • in DRDA (4330)
  • data type
  • binary large object (BLOB) (4472)
  • binary string (4437)
  • character large object (CLOB) (4478)
  • character string (4441)
  • DataLink (4560)
  • datetime (4508)
  • description (4431), (5483)
  • distinct types (4564)
  • double-byte character large object (DBCLOB) (4484)
  • in SQLDA (6353)
  • large object (LOB) (4466)
  • numeric (4489)
  • result columns (5102)
  • user-defined types (UDFs) (4562)
  • data-type (5380), (5396)
  • in ALTER TABLE statement (5171), (5196)
  • in CAST specification (4791)
  • in CREATE FUNCTION statement (5381), (5395), (5397)
  • in CREATE PROCEDURE statement (5445)
  • in CREATE TABLE (5484)
  • in DECLARE PROCEDURE statement (5650)
  • data-type-name
  • description (4398)
  • database manager limits (6325)
  • DATALINK
  • DataLink
  • assignment (4605)
  • CREATE PROCEDURE statement (5438)
  • data type
  • description (4561)
  • data type for CREATE TABLE (5506)
  • DECLARE PROCEDURE statement (5643)
  • limits (6323)
  • datalink-options
  • in ALTER TABLE statement (5186)
  • in CREATE TABLE statement (5526)
  • DATE
  • date
  • arithmetic operations (4775)
  • assignment (4601)
  • data type (4510)
  • data type for CREATE TABLE (5503)
  • duration (4768)
  • function (4914)
  • strings (4516)
  • date and time (4513)
  • arithmetic operations (4774), (4778)
  • assignments (4600)
  • comparisons (4617)
  • data types
  • string representation (4515)
  • format (4892)
  • day/month/year (4524)
  • EUR (4517), (4549)
  • hours/minutes/seconds (4553)
  • ISO (4518), (4550)
  • JIS (4519), (4551)
  • Julian (4522)
  • month/day/year (4523)
  • unformatted Julian (4521)
  • USA (4520), (4552)
  • year/month/day (4525)
  • datetime
  • data types
  • description (4509)
  • limits (6321)
  • DATFMT clause
  • in SET OPTION statement (6200)
  • DATSEP clause
  • in SET OPTION statement (6201)
  • DAY function (4916)
  • day, month, year date format (4545) See also date and time
  • DAYOFMONTH function (4918)
  • DAYOFWEEK function (4920)
  • DAYOFYEAR function (4922)
  • DAYS function (4924)
  • DB2GENERAL clause
  • CREATE PROCEDURE statement (5459)
  • DECLARE PROCEDURE statement (5664)
  • DB2SQL clause
  • CREATE FUNCTION statement (5393)
  • DBCLOB
  • CREATE PROCEDURE statement (5437)
  • data type (4479)
  • data type for CREATE TABLE (5502)
  • DECLARE PROCEDURE statement (5642)
  • description (4482)
  • function (4926)
  • DBCS (double-byte character set)
  • description (4459)
  • truncated during assignment (4595)
  • DECIMAL
  • decimal
  • constants (4628)
  • data type (4505)
  • data type for CREATE PROCEDURE (5422)
  • data type for CREATE TABLE (5488)
  • data type for DECLARE PROCEDURE (5627)
  • numbers (4504)
  • decimal data
  • arithmetic (4759)
  • DECIMAL function (4928)
  • decimal point (4650)
  • declaration
  • inserting into a program (5966)
  • DECLARE CURSOR statement (5600), (5602), (5613), (5618)
  • DECLARE PROCEDURE statement (5620), (5622), (5668)
  • DECLARE STATEMENT statement (5670), (5676)
  • DECLARE statements
  • BEGIN DECLARE SECTION statement (5256)
  • END DECLARE SECTION statement (5821)
  • DECLARE VARIABLE statement (5678), (5686)
  • DECMPT clause
  • in SET OPTION statement (6202)
  • DEFAULT
  • in UPDATE statement (6261)
  • DEFAULT clause
  • ALTER TABLE statement (5173)
  • CREATE TABLE statement (5516)
  • in INSERT statement (5984)
  • default collection
  • name qualification (4424)
  • DEGREES function (4930)
  • DELETE clause
  • GRANT (table privileges) statement (5934)
  • in ON DELETE clause of ALTER TABLE statement (5222)
  • in ON DELETE clause of CREATE TABLE statement (5548)
  • REVOKE (table privileges) statement (6137)
  • delete rules
  • referential constraint (4241)
  • referential integrity (5705)
  • triggers (5703)
  • DELETE statement (5688), (5706)
  • delete-connected table (4242)
  • deleting SQL objects (5780)
  • delimited identifier (4374)
  • in system names (4383)
  • dependent row (4214), (4223)
  • dependent table (4210), (4220)
  • DESC clause
  • CREATE INDEX statement (5411)
  • of select-statement (5139)
  • descendent row (4215)
  • descendent table (4211), (4221)
  • DESCRIBE statement (5708), (5735)
  • variables
  • SQLD (5722)
  • SQLDABC (5720)
  • SQLDAID (5718)
  • SQLN (5716)
  • SQLVAR (5724)
  • DESCRIBE TABLE statement (5737), (5765)
  • description (5763)
  • variables
  • SQLD (5749)
  • SQLDABC (5747)
  • SQLDAID (5745)
  • SQLN (5743)
  • SQLVAR (5751)
  • descriptor-name
  • description (4399)
  • in CALL statement (5273)
  • in DESCRIBE statement (5715)
  • in EXECUTE statement (5836)
  • in FETCH statement (5871)
  • in OPEN statement (6044)
  • in PREPARE statement (6061)
  • designator
  • table (4690), (5031)
  • DETERMINISTIC clause
  • in CREATE FUNCTION (5385)
  • in CREATE PROCEDURE (5450)
  • in DECLARE PROCEDURE (5655)
  • DFTRDBCOL clause
  • in SET OPTION statement (6203)
  • DIGITS function (4932)
  • DISCONNECT statement (5766), (5777)
  • DISCONNECT (5775)
  • disconnecting SQL objects (5768)
  • DISTINCT
  • AVG function (4829)
  • COUNT function (4834)
  • COUNT_BIG function (4841)
  • MAX function (4847)
  • MIN function (4851)
  • STDDEV function (4855)
  • SUM function (4859)
  • VAR function (4865)
  • VARIANCE function (4866)
  • DISTINCT clause
  • subselect (5089)
  • distinct type
  • assignment (4607)
  • comparisons (4619)
  • DISTINCT TYPE clause (5288)
  • COMMENT ON statement (5286)
  • distinct types
  • data types
  • description (4565)
  • distinct-type
  • CREATE PROCEDURE statement (5439)
  • data type for CREATE TABLE (5507)
  • DECLARE PROCEDURE statement (5644)
  • distinct-type-name
  • in CREATE DISTINCT TYPE statement (5372)
  • distributed data
  • CONNECT statement (6407)
  • distributed relational database
  • application requester (4301), (4306)
  • application server (4302), (4307)
  • application-directed distributed unit of work (4320)
  • considerations for using (6393), (6397), (6399), (6401), (6403)
  • data representation considerations (4331)
  • distributed unit of work (4321)
  • isolation level (4300)
  • remote unit of work (4314)
  • use of extensions to IBM SQL on unlike application servers (6394), (6398), (6400), (6402), (6404)
  • distributed relational database architecture (DRDA) (4310)
  • distributed tables
  • definition (4189)
  • syntax (5562)
  • division by zero (4786)
  • division operator (4738)
  • DLCOMMENT function (4934)
  • DLLINKTYPE function (4936)
  • DLURLCOMPLETE function (4938)
  • DLURLPATH function (4940)
  • DLURLPATHONLY function (4942)
  • DLURLSCHEME function (4944)
  • DLURLSERVER function (4946)
  • DLVALUE function (4948)
  • in INSERT statement (5268), (5985)
  • DLYPRP clause
  • in SET OPTION statement (6204)
  • dormant connection state (4324)
  • DOUBLE
  • function (4952)
  • DOUBLE PRECISION
  • data type for CREATE PROCEDURE (5421)
  • data type for CREATE TABLE (5493)
  • data type for DECLARE PROCEDURE (5626)
  • double-byte character
  • in COMMENT ON statement (5308)
  • in LIKE predicates (4809)
  • truncated during assignment (4588)
  • double-byte character large object (DBCLOB)
  • data type (4480)
  • description (4483)
  • double-byte character set (DBCS)
  • truncated during assignment (4596)
  • double-precision floating point (4503)
  • DOUBLE_PRECISION function (4951)
  • DRDA (4305) See also distributed relational database
  • DRDA (Distributed Relational Database Architecture) (4311)
  • DROP CHECK clause
  • ALTER TABLE statement (5247)
  • DROP COLUMN clause
  • ALTER TABLE statement (5201)
  • DROP CONSTRAINT clause
  • ALTER TABLE statement (5249)
  • DROP DEFAULT clause
  • ALTER TABLE statement (5199)
  • DROP FOREIGN KEY clause
  • ALTER TABLE statement (5243)
  • DROP NOT NULL clause
  • ALTER TABLE statement (5200)
  • DROP PRIMARY KEY clause
  • ALTER TABLE statement (5241)
  • DROP statement (5778), (5815), (5817)
  • DROP UNIQUE clause
  • ALTER TABLE statement (5245)
  • duplicate rows with UNION (5132)
  • duration
  • date (4769)
  • labeled (4766)
  • time (4770)
  • timestamp (4772)
  • DYNAMIC SCROLL clause
  • in DECLARE CURSOR statement (5607)
  • dynamic select (5158)
  • dynamic SQL
  • defined (5153)
  • description (4170)
  • execution
  • EXECUTE IMMEDIATE statement (5842)
  • EXECUTE statement (5827)
  • in USING clause of DESCRIBE statement (5712)
  • obtaining statement information with
  • DESCRIBE (5711)
  • DESCRIBE TABLE (5740)
  • preparation and execution (5156)
  • PREPARE statement (6056)
  • SQLDA (SQL descriptor area) (6351)
  • DYNDFTCOL clause
  • in SET OPTION statement (6205)
  • DYNUSRPRF clause
  • in SET OPTION statement (6206)
    • E
  • empty character string (4443)
  • ENCODED VECTOR clause
  • CREATE INDEX statement (5406)
  • encoding scheme (4341)
  • END DECLARE SECTION statement (5818), (5820), (5823)
  • ending
  • unit of work (5316), (6168)
  • error
  • closes cursor (6046)
  • during UPDATE (6285)
  • FETCH statement (5880)
  • escape character in SQL
  • delimited identifier (4375)
  • ESCAPE clause of LIKE predicate (4811)
  • EUR (IBM European standard) (4534) See also date and time
  • evaluation order (4782)
  • EXCEPTION JOIN clause
  • in FROM clause (5116)
  • EXCLUSIVE
  • ALLOW READ clause
  • LOCK TABLE statement (6028)
  • IN EXCLUSIVE MODE clause
  • LOCK TABLE statement (6032)
  • exclusive locks (4270)
  • EXCLUSIVE MODE clause
  • in LOCK TABLE statement (6031)
  • executable statement (5150), (5154)
  • EXECUTE clause
  • GRANT (function or procedure privileges) statement (5905)
  • GRANT (package privileges) statement (5921)
  • REVOKE (function or procedure privileges) statement (6108)
  • REVOKE (package privileges) statement (6124)
  • EXECUTE IMMEDIATE statement (5840), (5851)
  • EXECUTE statement (5824), (5837)
  • EXISTS predicate (4802)
  • EXP function (4954)
  • exponentiation operator (4739)
  • exposed name (5107)
  • expression
  • CASE expression (4785)
  • CAST specification (4788)
  • date and time operands (4764)
  • decimal operands (4749), (4754)
  • floating-point operands (4760)
  • grouping (5122)
  • in SET variable statement (6244)
  • in subselect (5093)
  • in UPDATE statement (6259)
  • in VALUES INTO statement (6293)
  • integer operands (4746), (4748)
  • numeric operands (4750), (4755)
  • precedence of operation (4781)
  • user-defined type operands (4762)
  • with arithmetic operators (4729)
  • with concatenation operator (4725)
  • without operators (4724)
  • extended dynamic SQL
  • description (4172)
  • EXTERNAL clause
  • in CREATE FUNCTION (5390)
  • in CREATE PROCEDURE (5456)
  • in DECLARE PROCEDURE (5661)
  • EXTERNAL NAME clause
  • in CREATE FUNCTION (5391)
  • in CREATE PROCEDURE (5457)
  • in DECLARE PROCEDURE (5662)
  • external procedures (4255) See also procedures
  • external-procedure-body
  • in CREATE PROCEDURE (5455)
  • in DECLARE PROCEDURE (5660)
  • external-program-name
  • description (4400)
    • F
  • FETCH statement (5852), (5885)
  • file reference
  • variable (4703), (4706)
  • FIRST clause
  • in FETCH statement (5861)
  • FLOAT
  • data type for CREATE PROCEDURE (5423)
  • data type for CREATE TABLE (5490), (5491)
  • data type for DECLARE PROCEDURE (5628)
  • FLOAT function (4956)
  • floating point
  • constants (4626)
  • numbers (4501)
  • FLOOR function (4958)
  • FOR BIT DATA clause
  • CREATE PROCEDURE statement (5432)
  • CREATE TABLE statement (5509)
  • DECLARE PROCEDURE statement (5637)
  • DECLARE VARIABLE statement (5683)
  • FOR clause
  • CREATE ALIAS statement (5354)
  • FOR COLUMN clause
  • ALTER TABLE statement (5170)
  • CREATE TABLE statement (5481)
  • CREATE VIEW statement (5582)
  • FOR FETCH ONLY clause
  • of select-statement (5144)
  • FOR MIXED DATA clause
  • CREATE PROCEDURE statement (5433)
  • CREATE TABLE statement (5511), (5513)
  • DECLARE PROCEDURE statement (5638)
  • DECLARE VARIABLE statement (5685)
  • FOR READ ONLY clause
  • of select-statement (5143)
  • FOR ROWS clause
  • FETCH statement (5872)
  • SET RESULT SETS statement (6224)
  • FOR SBCS DATA clause
  • CREATE PROCEDURE statement (5434)
  • CREATE TABLE statement (5510)
  • DECLARE PROCEDURE statement (5639)
  • DECLARE VARIABLE statement (5684)
  • FOR UPDATE OF clause
  • of select-statement (5141)
  • prohibited in views (5595)
  • foreign key (4202), (4205)
  • FOREIGN KEY clause
  • of ALTER TABLE statement (5217)
  • of CREATE TABLE statement (5543)
  • FORTRAN
  • SQLCA (SQL communication area) (6339)
  • FREE LOCATOR statement (5886), (5891)
  • FROM clause
  • correlation clause (5106)
  • correlation-clause (5692)
  • DELETE statement (5691)
  • joined-table (5110)
  • nested table expression (5105)
  • of subselect (5103)
  • PREPARE statement (6069)
  • REVOKE (function or procedure privileges) statement (6114)
  • REVOKE (package privileges) statement (6127)
  • REVOKE (table privileges) statement (6148)
  • REVOKE (type privileges) statement (6161)
  • table reference (5104)
  • fullselect (5127)
  • function (4868)
  • best fit (4722)
  • column (4825)
  • AVG (4828)
  • COUNT (4833)
  • COUNT_BIG (4840)
  • MAX (4846)
  • MIN (4850)
  • STDDEV (4854)
  • SUM (4858)
  • VARIANCE or VAR (4864)
  • description (4822)
  • invocation (4723)
  • nesting (4870)
  • resolution (4721)
  • scalar (4867)
  • ABS (4872)
  • ABSVAL (4871)
  • ACOS (4875)
  • ANTILOG (4877)
  • ASIN (4879)
  • ATAN (4881)
  • ATANH (4882)
  • BIGINT (4884)
  • BLOB (4886)
  • CEILING (4888)
  • CHAR (4890)
  • CHARACTER_LENGTH (4893)
  • CHAR_LENGTH (4894)
  • CLOB (4897)
  • COALESCE (4899)
  • CONCAT (4901)
  • COS (4903)
  • COSH (4905)
  • COT (4907)
  • CURDATE (4909)
  • CURTIME (4911)
  • DATE (4913)
  • DAY (4915)
  • DAYOFMONTH (4917)
  • DAYOFWEEK (4919)
  • DAYOFYEAR (4921)
  • DAYS (4923)
  • DBCLOB (4925)
  • DECIMAL (4927)
  • DEGREES (4929)
  • DIGITS (4931)
  • DLCOMMENT (4933)
  • DLLINKTYPE (4935)
  • DLURLCOMPLETE (4937)
  • DLURLPATH (4939)
  • DLURLPATHONLY (4941)
  • DLURLSCHEME (4943)
  • DLURLSERVER (4945)
  • DLVALUE (4947)
  • DOUBLE (4949)
  • DOUBLE_PRECISION (4950)
  • EXP (4953)
  • FLOAT (4955)
  • FLOOR (4957)
  • HASH (4959)
  • HEX (4961)
  • HOUR (4963)
  • IFNULL (4965)
  • INTEGER (4967)
  • LAND (4969)
  • LCASE (4987)
  • LEFT (4971)
  • LENGTH (4973)
  • LN (4975)
  • LNOT (4977)
  • LOCATE (4979)
  • LOG (4981)
  • LOG10 (4982)
  • LOR (4985)
  • LOWER (4988)
  • LTRIM (4992)
  • MAX (4993)
  • MICROSECOND (4995)
  • MIN (4997)
  • MINUTE (4999)
  • MOD (5002)
  • MONTH (5004)
  • NODENAME (5006)
  • NODENUMBER (5008)
  • NOW (5010)
  • NULLIF (5012)
  • PARTITION (5014)
  • POSITION (5017)
  • POSSTR (5016)
  • POWER (5020)
  • QUARTER (5022)
  • REAL (5024)
  • ROUND (5026)
  • RRN (5028)
  • RTRIM (5033)
  • SECOND (5034)
  • SIGN (5036)
  • SIN (5038)
  • SINH (5040)
  • SMALLINT (5042)
  • SQRT (5044)
  • STRIP (5046)
  • SUBSTR (or SUBSTRING) (5048)
  • TAN (5051)
  • TANH (5053)
  • TIME (5055)
  • TIMESTAMP (5057)
  • TRANSLATE (5059)
  • TRIM (5061)
  • TRUNCATE (5063)
  • UCASE (5065)
  • UPPER (5066)
  • VALUE (5069)
  • VARCHAR (5071)
  • VARGRAPHIC (5073)
  • WEEK (5075)
  • XOR (5077)
  • YEAR (5079)
  • ZONED (5081)
  • types (4720)
  • FUNCTION clause (5289)
  • COMMENT ON statement (5287), (5299)
  • DROP statement (5792)
  • GRANT (function or procedure privileges) statement (5906)
  • REVOKE (function or procedure) statement (6109)
  • function-name
  • description (4401)
  • in CREATE FUNCTION (5377), (5394)
  • in DROP statement (5793)
  • functions
  • description (4719)
    • G
  • GENERAL clause
  • CREATE PROCEDURE statement (5460)
  • DECLARE PROCEDURE statement (5665)
  • GENERAL WITH NULLS clause
  • CREATE PROCEDURE statement (5461)
  • DECLARE PROCEDURE statement (5666)
  • GET DIAGNOSTICS statement (5899)
  • GET DIAGNOSTICS statement (5892)
  • description (5897)
  • GO TO clause
  • WHENEVER statement (6307)
  • GRANT (function or procedure privileges) statement (5900), (5914)
  • GRANT (package privileges) statement (5916), (5926)
  • GRANT (table privileges) statement (5928), (5931), (5948), (5950)
  • GRANT (type privileges) statement (5952), (5962)
  • GRAPHIC
  • data type for CREATE PROCEDURE (5431)
  • data type for CREATE TABLE (5499)
  • data type for DECLARE PROCEDURE (5636)
  • graphic constant
  • hexadecimal (4648)
  • graphic string
  • constants (4645)
  • definition (4458)
  • GROUP BY clause
  • cannot join view using (5594)
  • of subselect (5121)
  • results with subselect (5096)
    • H
  • HASH function (4960)
  • HASHING
  • in CREATE TABLE statement (5565)
  • HAVING clause
  • of subselect (5124)
  • results with subselect (5097)
  • held connection state (4325)
  • HEX function (4962)
  • hexadecimal constants (4634), (4642)
  • HOLD clause (5612)
  • COMMIT statement (5319)
  • ROLLBACK statement (6173)
  • host identifier (4384)
  • host structure
  • description (4711)
  • host structure arrays
  • description (4718)
  • host variable
  • DECLARE VARIABLE statement (5680)
  • description (4403), (4695)
  • in CALL statement (5271)
  • in INSERT statement (5988)
  • indicator variable (4701)
  • statement string (5847)
  • substitution for parameter markers (5833)
  • host-identifier
  • in host variable (4404)
  • host-label
  • description (4402)
  • in WHENEVER statement (6308)
  • host-structure-array
  • in FETCH statement (5874)
  • in INSERT statement (5994)
  • in SET RESULT SETS statement (6223)
  • host-variable
  • in CALL statement (5263), (5264)
  • in CONNECT (Type 1) statement (5325), (5329), (5332)
  • in CONNECT (Type 2) statement (5339), (5341), (5345)
  • in DECLARE VARIABLE statement (5682)
  • in DESCRIBE TABLE statement (5741)
  • in DISCONNECT statement (5770)
  • in EXECUTE IMMEDIATE statement (5845)
  • in EXECUTE statement (5834)
  • in FETCH statement (5869)
  • in FREE LOCATOR statement (5889)
  • in INSERT statement (5981), (5992)
  • in LIKE predicate (4812)
  • in OPEN statement (6042)
  • in PREPARE statement (6071)
  • in RELEASE statement (6084)
  • in SELECT INTO statement (6181)
  • in SET CONNECTION statement (6190)
  • in VALUES INTO statement (6298)
  • HOUR function (4964)
    • I
  • IBM European standard (EUR) (4535) See also date and time
  • IBM USA standard (USA) (4542) See also date and time
  • identifiers
  • in SQL
  • delimited (4379)
  • description (4369)
  • host (4385)
  • ordinary (4371)
  • system (4381)
  • limits (4365), (4421), (6315)
  • IFNULL function (4966)
  • ILE RPG/400
  • SQLCA (SQL communication area) (6348)
  • SQLDA (SQL descriptor area) (6388)
  • IMMEDIATE
  • EXECUTE IMMEDIATE statement (5843), (5849)
  • IN ASP clause
  • CREATE COLLECTION statement (5365)
  • CREATE SCHEMA statement (5470)
  • IN clause
  • CREATE PROCEDURE statement (5441)
  • DECLARE PROCEDURE statement (5646)
  • IN EXCLUSIVE clause
  • in LOCK TABLE statement (6030)
  • IN predicate (4804)
  • IN SHARE MODE clause
  • in LOCK TABLE statement (6022)
  • INCLUDE statement (5964), (5971)
  • index (4245)
  • dropping (5784), (5798)
  • INDEX clause (5291)
  • COMMENT ON statement (5293), (5302)
  • CREATE INDEX statement (5402)
  • DROP statement (5796)
  • GRANT (table privileges) statement (5935)
  • RENAME statement (6097)
  • REVOKE (table privileges) statement (6138)
  • index-name
  • description (4405)
  • in CREATE INDEX statement (5407)
  • in DROP statement (5797)
  • in RENAME statement (6098)
  • indicator
  • array (4712)
  • variable (4713), (5844)
  • infix operators (4735)
  • INNER JOIN clause
  • in FROM clause (5112)
  • INOUT clause
  • CREATE PROCEDURE statement (5443)
  • DECLARE PROCEDURE statement (5648)
  • INSENSITIVE clause
  • in DECLARE CURSOR statement (5605)
  • INSERT clause
  • GRANT (table privileges) statement (5936)
  • REVOKE (table privileges) statement (6139)
  • insert rule with referential constraint (4235)
  • insert rules
  • check constraint (5996)
  • INSERT statement (5974), (5998)
  • INTEGER
  • data type for CREATE PROCEDURE (5425)
  • data type for CREATE TABLE (5486)
  • data type for DECLARE PROCEDURE (5630)
  • integer constants (4624)
  • INTEGER data type (4497)
  • INTEGER function (4968)
  • interactive entry of SQL statements (5159)
  • interactive SQL (4175)
  • International Standards Organization (ISO) (4537) See also date and time
  • INTO clause
  • in FETCH statement (5868), (5873), (5875)
  • in PREPARE statement (6060)
  • in SELECT INTO statement (6180)
  • in VALUES INTO statement (6297)
  • INTO DESCRIPTOR clause
  • FETCH statement (5870)
  • INTO keyword
  • DESCRIBE statement (5714)
  • DESCRIBE TABLE statement (5742)
  • INSERT statement (5975)
  • IS clause
  • COMMENT ON statement (5307)
  • LABEL ON statement (6012)
  • ISO (International Standards Organization) (4536) See also date and time
  • isolation level
  • CS (4284)
  • cursor stability (4283)
  • description (4266)
  • in distributed applications (4299)
  • NC (4294)
  • no commit (4293)
  • read stability
  • phantom rows (4277)
  • repeatable read (4271)
  • RR (4272)
  • RS (4278)
  • set using SET TRANSACTION (6230)
  • uncommitted read (UR) (4288)
  • ISOLATION LEVEL clause
  • SET TRANSACTION statement (6231)
  • isolation-clause (5147)
  • in DELETE statement (5701)
  • in INSERT statement (5990)
  • in SELECT INTO statement (6179)
  • in UPDATE statement (6269)
    • J
  • Japanese Industrial Standard (JIS) (4539) See also date and time
  • JAVA clause
  • CREATE PROCEDURE statement (5462)
  • DECLARE PROCEDURE statement (5667)
  • JIS (Japanese Industrial Standard) (4538) See also date and time
  • JOIN clause
  • in FROM clause (5111)
  • Julian date format (4547) See also date and time
    • K
  • KEEP LOCKS (5148)
  • key
  • ALTER TABLE statement (5208), (5211)
  • composite (4191)
  • CREATE TABLE statement (5535)
  • foreign (4204)
  • parent (4209)
  • primary (4195)
  • primary index (4198)
  • unique (4192)
  • unique index (4199)
    • L
  • LABEL ON statement (5999), (6015)
  • labeled duration (4767)
  • LABELS
  • in catalog tables (6001)
  • in USING clause
  • DESCRIBE statement (5729)
  • DESCRIBE TABLE statement (5756)
  • PREPARE statement (6065)
  • LAND function (4970)
  • LANGID clause
  • in SET OPTION statement (6207)
  • LANGUAGE clause
  • in CREATE FUNCTION statement (5384)
  • in CREATE PROCEDURE statement (5448)
  • in DECLARE PROCEDURE statement (5653)
  • large integers (4498)
  • large object (LOB)
  • data type (4462)
  • description (4465)
  • locator (4486)
  • LAST clause
  • in FETCH statement (5862)
  • LCASE function (4989)
  • LEFT function (4972)
  • LEFT JOIN clause
  • in FROM clause (5113)
  • LEFT OUTER JOIN clause
  • in FROM clause (5114)
  • LENGTH function (4974)
  • LIKE predicate (4806)
  • limits
  • database manager (6324)
  • DataLink (6322)
  • datetime (6320)
  • identifier (4420), (6314)
  • in SQL (6312)
  • numeric (6316)
  • string (6318)
  • literals (4622)
  • LN function (4976)
  • LNOT function (4978)
  • LOB
  • data type (4461)
  • description (4464)
  • locator (4487)
  • LOCAL CHECK OPTION clause
  • CREATE VIEW statement (5592)
  • LOCAL time standard (4540) See also date and time
  • LOCATE function (4980)
  • locator
  • description (4485)
  • FREE LOCATOR statement (5888)
  • LOCK TABLE statement (6016), (6035)
  • locking
  • COMMIT statement (5320)
  • during UPDATE (6287)
  • LOCK TABLE statement (6019)
  • table spaces (6018)
  • locks
  • exclusive (4269)
  • share (4267)
  • LOG function (4984)
  • LOG10 function (4983)
  • logical operator (4815)
  • LONG VARCHAR
  • data type for CREATE TABLE (5497)
  • LONG VARGRAPHIC
  • data type for CREATE TABLE (5501)
  • LOR function (4986)
  • LOWER function (4990)
  • LTRIM function (4991)
    • M
  • MAX
  • column function (4845)
  • scalar function (4994)
  • member-name
  • in INCLUDE statement (5969)
  • MICROSECOND function (4996)
  • MIN
  • column function (4849)
  • scalar function (4998)
  • MINUTE function (5000)
  • mixed data
  • description (4457)
  • in LIKE predicates (4808)
  • in string assignments (4590)
  • MOD function (5003)
  • MODE
  • IN EXCLUSIVE MODE clause
  • LOCK TABLE statement (6025)
  • IN SHARE MODE clause
  • LOCK TABLE statement (6029), (6033)
  • MODIFIES SQL DATA clause
  • in CREATE FUNCTION (5389)
  • in CREATE PROCEDURE (5454)
  • in DECLARE PROCEDURE (5659)
  • MONTH function (5005)
  • month, day, year date format (4544) See also date and time
  • multiplication operator (4736)
    • N
  • name
  • exposed (5108)
  • for SQL statements (5673)
  • subselect (5095)
  • name qualification (4422)
  • default collection (4423)
  • NAMES
  • in USING clause
  • DESCRIBE statement (5727)
  • DESCRIBE TABLE statement (5754)
  • PREPARE statement (6063)
  • NAMING clause
  • in SET OPTION statement (6208)
  • naming conventions in SQL (4386)
  • NC (no commit) (4298)
  • nested programs (6309)
  • NEXT clause
  • in FETCH statement (5859)
  • NO ACTION delete rule
  • in ALTER TABLE statement (5225)
  • in CREATE TABLE statement (5553)
  • NO ACTION update rule
  • in ALTER TABLE statement (5231)
  • in CREATE TABLE statement (5557)
  • no commit (4295)
  • NO COMMIT clause
  • SET TRANSACTION statement (6232)
  • NO SQL clause
  • in CREATE FUNCTION (5387)
  • in CREATE PROCEDURE (5452)
  • in DECLARE PROCEDURE (5657)
  • nodegroup
  • definition (4187)
  • in CREATE TABLE statement (5561)
  • nodegroup-name (4406)
  • NODENAME function (5007)
  • NODENUMBER function (5009)
  • NONE clause
  • SET RESULT SETS statement (6225)
  • nonexecutable statement (5151), (5155)
  • NOT FOUND clause
  • WHENEVER statement (6303)
  • NOT NULL clause
  • ALTER TABLE statement (5172)
  • CREATE TABLE statement (5514)
  • NOW function (5011)
  • NUL-terminated string variables allowed (4451)
  • NULL
  • in CAST specification (4789)
  • in SET variable statement (6245)
  • in UPDATE statement (6260)
  • in VALUES INTO statement (6294)
  • keyword SET NULL delete rule
  • description (4240)
  • in ALTER TABLE statement (5228)
  • in CREATE TABLE statement (5552)
  • keyword SET NULL update rule
  • in ALTER TABLE statement (5234)
  • NULL clause
  • ALTER TABLE statement (5175)
  • in CALL statement (5266)
  • in INSERT statement (5983)
  • NULL predicate (4813)
  • null value in SQL
  • assignment (4578)
  • defined (4433)
  • in grouping expressions (5123)
  • in result columns (5099)
  • specified by indicator variable (4702)
  • NULLIF function (5013)
  • numbers (4491)
  • NUMERIC
  • numeric
  • assignments (4579)
  • comparisons (4609)
  • data type (4490)
  • data type for CREATE PROCEDURE (5426)
  • data type for CREATE TABLE (5489)
  • data type for DECLARE PROCEDURE (5631)
  • limits (6317)
    • O
  • object table (4688)
  • ON clause
  • CREATE INDEX statement (5408)
  • ON DISTINCT TYPE clause
  • REVOKE (type privileges) statement (6159)
  • ON PACKAGE clause
  • GRANT (package privileges) statement (5922)
  • REVOKE (package privileges) statement (6125)
  • ON TABLE clause
  • GRANT (table privileges) statement (5942)
  • REVOKE (table privileges) statement (6145)
  • ON TYPE clause
  • GRANT (type privileges) statement (5958)
  • open state of cursor (5881)
  • OPEN statement (6036), (6053)
  • operand
  • date and time (4765)
  • decimal (4752), (4756)
  • floating point (4761)
  • integer (4747), (4751)
  • numeric (4753), (4757)
  • user-defined type (4763)
  • operation
  • assignment (4570), (4598), (4604)
  • comparison (4611), (4620)
  • description (4567)
  • operators (4745)
  • arithmetic (4730)
  • OPTIMIZE clause (5145)
  • OPTLOB clause
  • in SET OPTION statement (6209)
  • OR
  • truth table (4819)
  • ORDER BY clause
  • of select-statement (5136)
  • prohibited in views (5596)
  • order of evaluation (4783)
  • ordinary identifier
  • in SQL (4370)
  • in system names (4382)
  • OUT clause
  • CREATE PROCEDURE statement (5442)
  • DECLARE PROCEDURE statement (5647)
  • outer join (5115) See also LEFT OUTER JOIN clause
  • OVRDBF (Override with Data Base file) (4425)
  • ownership (4353)
    • P
  • package
  • description (4251)
  • dropping (5801)
  • in DRDA (4312)
  • PACKAGE clause (5292)
  • COMMENT ON statement (5294)
  • DROP statement (5799)
  • LABEL ON statement (6007)
  • package view
  • SYSPACKAGE (6433)
  • package-name (4407)
  • in DROP statement (5800)
  • in LABEL ON statement (6008)
  • in REVOKE (package privileges) statement (6126)
  • PARAMETER clause
  • COMMENT ON statement (5303)
  • parameter marker
  • in EXECUTE statement (5830)
  • in OPEN statement (6045)
  • in PREPARE statement (6072)
  • rules (6073)
  • parameter-marker
  • in CAST specification (4790)
  • parameter-name
  • description (4408)
  • in CREATE PROCEDURE (5444)
  • in DECLARE PROCEDURE (5649)
  • parent key (4208)
  • parent row (4216), (4224)
  • parent table (4207), (4219)
  • parentheses
  • with UNION (5133)
  • PARTITION function (5015)
  • partitioning key
  • definition (4190)
  • in CREATE TABLE statement (5563)
  • password
  • in CONNECT (Type 1) statement (5331)
  • in CONNECT (Type 2) statement (5344)
  • PL/I
  • application program
  • varying-length string variables (4449)
  • host structure arrays (4715)
  • host variable (4697), (4710)
  • SQLCA (SQL communication area) (6342)
  • SQLDA (SQL descriptor area) (6384)
  • POSITION function (5019)
  • POSSTR function (5018)
  • POWER function (5021)
  • precedence
  • level (4780)
  • operation (4779)
  • precision of a number (4492)
  • predicate
  • basic (4794)
  • BETWEEN (4801)
  • description (4792)
  • EXISTS (4803)
  • IN (4805)
  • LIKE (4807)
  • NULL (4814)
  • quantified (4796)
  • prefix operator (4732)
  • PREPARE statement (6054), (6076)
  • prepared SQL statement
  • dynamically prepared by PREPARE (6057), (6074)
  • executing (5826), (5839)
  • identifying by DECLARE (5674)
  • obtaining information
  • by INTO with PREPARE (5734), (5761)
  • with DESCRIBE (5710)
  • with DESCRIBE TABLE (5739)
  • with SQLDA (6352)
  • primary index (4200)
  • primary key (4197)
  • PRIMARY KEY clause
  • ALTER TABLE statement (5189), (5212)
  • CREATE TABLE statement (5529), (5536)
  • PRIOR clause
  • in FETCH statement (5860)
  • privileges
  • description (4351)
  • procedure See also CREATE PROCEDURE statement, DECLARE PROCEDURE statement
  • creating (5418)
  • defining (5623)
  • dropping (5802)
  • RELEASE statement (6082)
  • ROLLBACK (6171)
  • PROCEDURE clause (5290)
  • COMMENT ON statement (5295)
  • DROP statement (5803)
  • procedure-name
  • description (4409)
  • in CALL statement (5262)
  • in CREATE PROCEDURE (5440)
  • in DECLARE PROCEDURE (5645)
  • in DROP statement (5804)
  • procedures (4253)
  • SET CONNECTION statement (6188)
  • PUBLIC
  • authority (4354)
  • PUBLIC clause
  • GRANT (table privileges) statement (5946)
  • in GRANT (function or procedure privileges) statement (5912)
  • in GRANT (package privileges) statement (5924)
  • in GRANT (type privileges) statement (5960)
  • in REVOKE (table privileges) statement (6150)
  • REVOKE (function or procedure privileges) statement (6116)
  • REVOKE (package privileges) statement (6129)
  • REVOKE (type privileges) statement (6163)
    • Q
  • qualification of column names (4684)
  • quantified predicate (4795)
  • QUARTER function (5023)
  • query (5083), (5149)
  • question mark (?) (5831) See also parameter marker
    • R
  • RDBCNNMTH clause
  • in SET OPTION statement (6210)
  • READ COMMITTED clause
  • SET TRANSACTION statement (6234)
  • read stability (4279)
  • READ UNCOMMITTED clause
  • SET TRANSACTION statement (6233)
  • read-only
  • result table (5616)
  • view (5593)
  • read-only-clause (5142)
  • READS SQL DATA clause
  • in CREATE FUNCTION (5388)
  • in CREATE PROCEDURE (5453)
  • in DECLARE PROCEDURE (5658)
  • REAL
  • data type for CREATE PROCEDURE (5427)
  • data type for CREATE TABLE (5492)
  • data type for DECLARE PROCEDURE (5632)
  • REAL function (5025)
  • recovery (4259)
  • REFERENCES clause
  • ALTER TABLE statement (5191), (5219)
  • CREATE TABLE statement (5531), (5545)
  • GRANT (table privileges) statement (5937), (5938)
  • REVOKE (table privileges) statement (6140), (6141)
  • referential constraint (4203)
  • referential cycle (4212), (4222)
  • referential integrity (4213)
  • delete rules (5704)
  • update rules (6282)
  • referential-constraint clause
  • of ALTER TABLE statement (5214)
  • of CREATE TABLE statement (5540)
  • related information (6453)
  • relational database (4164)
  • RELATIVE clause
  • in FETCH statement (5610), (5866)
  • RELEASE statement (6077), (6089)
  • release-pending connection state (4326)
  • remote unit of work (4313)
  • RENAME statement (6090), (6100), (6102)
  • renaming SQL objects (6092)
  • repeatable read (4273)
  • REPEATABLE READ clause
  • SET TRANSACTION statement (6235)
  • reserved words (4372), (6389)
  • RESET clause
  • CONNECT (Type 1) statement (5333)
  • CONNECT (Type 2) statement (5346)
  • RESTRICT clause
  • DROP statement (5813)
  • in DROP COLUMN of ALTER TABLE statement (5204)
  • in DROP constraint of ALTER TABLE statement (5251)
  • RESTRICT delete rule
  • description (4236)
  • in ALTER TABLE statement (5224)
  • in CREATE TABLE statement (5549)
  • RESTRICT update rule
  • in ALTER TABLE statement (5230)
  • in CREATE TABLE statement (5556)
  • result columns of subselect (5101)
  • RESULT SETS clause
  • in CREATE PROCEDURE (5447)
  • in DECLARE PROCEDURE (5652)
  • result table (4182)
  • read-only (5617)
  • temporary (5609)
  • RETURNS clause
  • in CREATE FUNCTION statement (5379)
  • REVOKE (function or procedure privileges) statement (6103), (6117)
  • REVOKE (package privileges) statement (6119), (6130)
  • REVOKE (table privileges) statement (6132), (6151)
  • REVOKE (type privileges) statement (6153), (6164)
  • REXX
  • host variable (4700)
  • ROLLBACK
  • rollback
  • definition (4263), (4265)
  • description (4262), (4264)
  • effect on SET TRANSACTION (6239)
  • ROLLBACK statement (6166), (6175)
  • ROUND function (5027)
  • row
  • deleting (5690)
  • dependent (4233)
  • descendent (4232)
  • inserting (5973)
  • parent (4231)
  • self-referencing (4234)
  • ROW clause
  • in UPDATE statement (6258)
  • row-storage-area
  • in FETCH statement (5876)
  • row-subselect
  • in SET variable statement (6247)
  • in UPDATE statement (6263)
  • in VALUES statement (6296)
  • ROWS clause
  • INSERT statement (5991)
  • ROW_COUNT
  • GET DIAGNOSTICS statement (5895)
  • RPG
  • application program
  • host variable (4709)
  • varying-length string variables not allowed (4450)
  • host structure arrays (4717)
  • host variable (4698)
  • integers (4495)
  • RPG/400
  • SQLCA (SQL communication area) (6345)
  • RR (repeatable read) (4276)
  • RRN function (5029)
  • RS (read stability) (4282)
  • RTRIM function (5032)
  • rules
  • names in SQL (4388)
  • system name generation (5566)
  • table name generation (5569)
  • run-time authorization ID (4428)
    • S
  • SBCS data (4455)
  • scalar function (4869) See also function
  • scalar-subselect
  • in SET variable statement (6246)
  • in UPDATE statement (6262)
  • in VALUES INTO statement (6295)
  • scale of data
  • comparisons in SQL (4612)
  • conversion of numbers in SQL (4582)
  • determined by SQLLEN variable (6361)
  • in results of arithmetic operations (4758)
  • in SQL (4506)
  • SCROLL clause
  • in DECLARE CURSOR statement (5606)
  • search condition
  • description (4817)
  • in JOIN clause (5118)
  • order of evaluation (4821)
  • with DELETE (5698)
  • with HAVING (5125)
  • with UPDATE (6265)
  • with WHERE (5120)
  • search-condition
  • in UPDATE statement (6266)
  • SECOND function (5035)
  • SELECT clause
  • as syntax component (5087)
  • GRANT (table privileges) statement (5939)
  • REVOKE (table privileges) statement (6142)
  • SELECT INTO statement (6176), (6183)
  • select list
  • application (5098)
  • notation (5092)
  • SELECT statement
  • fullselect (5128)
  • subselect (5085)
  • select-statement
  • in DECLARE CURSOR statement (5614)
  • used in INSERT statement (5989)
  • self-referencing row (4217), (4225)
  • self-referencing table (4218), (4226)
  • SERIALIZABLE clause
  • SET TRANSACTION statement (6236)
  • server-name
  • description (4410)
  • in CONNECT (Type 1) statement (5326)
  • in CONNECT (Type 2) statement (5338)
  • in DISCONNECT statement (5769)
  • in RELEASE statement (6083)
  • in SET CONNECTION statement (6189)
  • SET clause
  • UPDATE statement (6256)
  • SET CONNECTION statement (6184), (6192)
  • SET DATA TYPE clause
  • ALTER TABLE statement (5195)
  • SET DEFAULT delete rule
  • description (4239)
  • in ALTER TABLE statement (5226)
  • in CREATE TABLE statement (5554)
  • SET DEFAULT update rule
  • in ALTER TABLE statement (5232)
  • SET default-clause
  • ALTER TABLE statement (5197)
  • SET NOT NULL clause
  • ALTER TABLE statement (5198)
  • SET NULL delete rule
  • description (4238)
  • in ALTER TABLE statement (5227)
  • in CREATE TABLE statement (5551)
  • SET NULL update rule
  • in ALTER TABLE statement (5233)
  • SET OPTION statement (6193), (6218)
  • SET RESULT SETS statement (6219), (6227)
  • SET TRANSACTION statement (6228), (6241)
  • SET variable statement (6242)
  • SHARE
  • IN SHARE MODE clause
  • LOCK TABLE statement (6024)
  • share locks (4268)
  • SHARE MODE clause
  • in LOCK TABLE statement (6023)
  • shift-in character (4597)
  • not truncated by assignments (4589)
  • SIGN function (5037)
  • SIN function (5039)
  • single row select (6178)
  • single-byte character
  • in LIKE predicates (4810)
  • single-precision floating-point (4502)
  • SINH function (5041)
  • small integers (4494)
  • SMALLINT
  • data type for CREATE PROCEDURE (5428)
  • data type for CREATE TABLE (5487)
  • data type for DECLARE PROCEDURE (5633)
  • SMALLINT data type (4493)
  • SMALLINT function (5043)
  • SOME quantified predicate (4799)
  • sort sequence (4349)
  • source data type
  • CREATE DISTINCT TYPE statement (5373)
  • special register (4655)
  • CURRENT DATE (4658)
  • CURRENT PATH (4662)
  • CURRENT SERVER (4666)
  • CURRENT TIME (4668)
  • CURRENT TIMESTAMP (4674)
  • CURRENT TIMEZONE (4678)
  • CURRENT_DATE (4659)
  • CURRENT_PATH (4663)
  • CURRENT_SERVER (4667)
  • CURRENT_TIME (4669)
  • CURRENT_TIMESTAMP (4675)
  • CURRENT_TIMEZONE (4679)
  • in CALL statement (5267), (5274)
  • in INSERT statement (5982)
  • USER (4681)
  • SPECIFIC clause
  • COMMENT ON statement (5300), (5304)
  • CREATE FUNCTION statement (5398)
  • DROP statement (5794), (5805)
  • GRANT (function or procedure) statement (5907), (5909)
  • in CREATE FUNCTION statement (5383)
  • in CREATE PROCEDURE (5449)
  • in DECLARE PROCEDURE (5654)
  • REVOKE (function or procedure) statement (6110), (6112)
  • specific-name
  • description (4411)
  • in COMMENT ON statement (5301), (5305), (5399)
  • in DROP statement (5795), (5806)
  • in GRANT (function or procedure) statement (5910)
  • in GRANT (function or procedure) statement (5908)
  • in REVOKE (function or procedure) statement (6111), (6113)
  • SQL (Structured Query Language) (4359), (5347), (5572), (5762), (5774) , (5814), (5896), (5932), (6099), (6288)
  • SQL (Structured Query language)
  • SQL (structured query language)
  • assignment operation (4569)
  • assignments and comparisons (4566)
  • binary large object (BLOB) (4469)
  • binary strings (4435)
  • bind (4165)
  • call level interface (CLI) (4176)
  • character large object (CLOB) (4475)
  • character strings (4439)
  • characters (4360)
  • comparison operation (4571)
  • constants (4621)
  • data types (4430)
  • dates and times (4507)
  • double-byte character large object (DBCLOB) (4481)
  • dynamic SQL (4171)
  • escape character (4376)
  • extended dynamic SQL (4173)
  • identifiers (4368)
  • interactive SQL facility (4174)
  • large object (LOB) (4463)
  • limits (6313)
  • naming conventions (4387)
  • null value (4432)
  • numbers (4488)
  • static SQL (4168)
  • tokens (4361)
  • variable names used (4389)
  • SQL clause
  • CREATE FUNCTION statement (5392)
  • CREATE PROCEDURE statement (5458)
  • DECLARE PROCEDURE statement (5663)
  • SQL procedure statement
  • in CREATE PROCEDURE (5463)
  • SQL Statements
  • SQL statements
  • ALTER TABLE (5164), (5253)
  • BEGIN DECLARE SECTION (5255), (5257)
  • CALL (5259), (5275)
  • CLOSE (5278), (5281)
  • COMMENT ON (5284), (5310)
  • COMMIT (5312), (5322)
  • CONNECT (Type 1) (5323), (5334)
  • CONNECT (Type 2) (5336), (5348)
  • CONNECT differences (6406)
  • CREATE ALIAS (5351), (5358)
  • CREATE COLLECTION (5360), (5369)
  • CREATE DISTINCT TYPE (5371), (5376)
  • CREATE INDEX (5401), (5414)
  • CREATE PROCEDURE (5416), (5465)
  • CREATE SCHEMA (5467), (5474)
  • CREATE TABLE (5476), (5574)
  • CREATE VIEW (5576), (5599)
  • DECLARE CURSOR (5601), (5619)
  • DECLARE PROCEDURE (5621), (5669)
  • DECLARE STATEMENT (5671), (5677)
  • DECLARE VARIABLE (5679), (5687)
  • DELETE (5689), (5707)
  • DESCRIBE (5709), (5736)
  • DESCRIBE TABLE (5738), (5764)
  • DISCONNECT (5767), (5776)
  • DROP (5779), (5816)
  • END DECLARE SECTION (5819), (5822)
  • EXECUTE (5825), (5838)
  • EXECUTE IMMEDIATE (5841), (5850)
  • FETCH (5853), (5884)
  • FREE LOCATOR (5887), (5890)
  • GET DIAGNOSTICS (5893), (5898)
  • GRANT (function or procedure privileges) (5901), (5915)
  • GRANT (package privileges) (5917), (5927)
  • GRANT (table privileges) (5929), (5949), (5951)
  • GRANT (type privileges) (5953), (5963)
  • INCLUDE (5965), (5970)
  • INSERT (5972), (5997)
  • LABEL ON (6000), (6014)
  • LOCK TABLE (6017), (6034)
  • names for (5672)
  • OPEN (6037), (6052)
  • PREPARE (6055), (6075)
  • prepared (4166)
  • RELEASE (6078), (6088)
  • RENAME (6091), (6101)
  • REVOKE (function or procedure privileges) (6104), (6118)
  • REVOKE (package privileges) (6120), (6131)
  • REVOKE (table privileges) (6152)
  • REVOKE (table privileges) (6133)
  • REVOKE (type privileges) (6154), (6165)
  • ROLLBACK (6167), (6174)
  • SELECT INTO (6177), (6182)
  • SET CONNECTION (6185), (6191)
  • SET OPTION (6194), (6217)
  • SET RESULT SETS (6220), (6226)
  • SET TRANSACTION (6229), (6240)
  • SET variable (6243)
  • UPDATE (6251), (6289)
  • VALUES INTO (6292)
  • WHENEVER (6302), (6310)
  • SQL-label
  • description (4412)
  • SQL-parameter-name
  • description (4413)
  • SQL-variable-name
  • description (4414)
  • in GET DIAGNOSTICS statement (5894)
  • SQLCA (SQL communication area)
  • C (6332)
  • COBOL (6335)
  • contents (6326)
  • description (6327)
  • entry changed by UPDATE (6286)
  • FORTRAN (6338)
  • ILE RPG/400 (6347)
  • PL/I (6341)
  • RPG/400 (6344)
  • SQLCA (SQL communication area) clause
  • INCLUDE statement (5967)
  • SQLCODE (5160)
  • SQLCURRULE clause
  • in SET OPTION statement (6211)
  • SQLD field of SQLDA (5723), (5750), (6357)
  • SQLDA (SQL descriptor area)
  • ILE COBOL (6380)
  • C (6374)
  • COBOL (6377)
  • contents (6350)
  • ILE RPG/400 (6387)
  • PL/I (6383)
  • SQLDA (SQL descriptor area) clause
  • INCLUDE statement (5968)
  • SQLDABC field of SQLDA (5721), (5748), (6355)
  • SQLDAID field of SQLDA (5719), (5746), (6354)
  • SQLDATA field of SQLDA (6369)
  • SQLDATALEN field of SQLDA (6366)
  • SQLERRMC field of SQLCA
  • values for CONNECT (6329)
  • values for SET CONNECTION (6330)
  • SQLERROR clause
  • WHENEVER statement (6304)
  • SQLIND field of SQLDA (6362)
  • SQLLEN field of SQLDA (6360), (6368)
  • SQLLONGLEN field of SQLDA (6365)
  • SQLN field of SQLDA (5717), (5744), (6356)
  • SQLNAME field of SQLDA (6363), (6364), (6370)
  • SQLPATH clause
  • in SET OPTION statement (6212)
  • SQLSTATE
  • description (5161)
  • SQLTYPE
  • unsupported (6373)
  • SQLTYPE field of SQLDA (6359), (6367)
  • SQLVAR field of SQLDA (5725), (5752), (6358)
  • SQLWARNING clause
  • WHENEVER statement (6305)
  • SQL_LANGUAGES table (6413)
  • SQRT function (5045)
  • SRTSEQ clause
  • in SET OPTION statement (6213)
  • statement string (5848)
  • statement-name
  • description (4415)
  • in DECLARE CURSOR statement (5615)
  • in DECLARE STATEMENT statement (5675)
  • in DESCRIBE statement (5713)
  • in EXECUTE statement (5828)
  • in PREPARE statement (6059)
  • states
  • SQL connection (4322)
  • static select (5157)
  • static SQL (4169), (5152)
  • STDDEV function (4853)
  • stored procedures (4254) See also procedures
  • string
  • columns (4442)
  • constant
  • binary (4631)
  • character (4639)
  • graphic (4647)
  • hexadecimal (4636), (4644)
  • limits (6319)
  • variable
  • fixed-length (4446)
  • varying-length (4447)
  • string delimiter (4363), (4633), (4641)
  • string-expression
  • in EXECUTE IMMEDIATE statement (5846)
  • in PREPARE statement (6070)
  • STRIP function (5047)
  • subquery
  • description (4693)
  • in HAVING clause (5126)
  • subselect (5084)
  • in CREATE VIEW statement (5086)
  • used in CREATE VIEW statement (5586)
  • substitution character (4343)
  • SUBSTR function (5049)
  • SUBSTRING function (5050)
  • subtraction operator (4737)
  • SUM function (4857)
  • synonym for qualifying a column name (4686)
  • SYSCHKCST view (6416)
  • SYSCOLUMNS view (6418)
  • SYSCST view (6420)
  • SYSCSTCOL view (6422)
  • SYSCSTDEP view (6424)
  • SYSFUNCS view (6426)
  • SYSINDEXES view (6428)
  • SYSKEYCST view (6430)
  • SYSKEYS view (6432)
  • SYSLANGS table (6414)
  • SYSPACKAGE view (6434)
  • SYSPARMS table (6437)
  • SYSPROCS view (6439)
  • SYSREFCST view (6441)
  • SYSROUTINES table (6443)
  • SYSTABLES view (6445)
  • system column name (4185), (4248), (5482), (5581), (5584) , (5733), (5760)
  • system identifier (4380)
  • SYSTEM NAME clause
  • RENAME statement (6096)
  • system name generation
  • rules (5567)
  • SYSTEM NAMES
  • in USING clause
  • DESCRIBE statement (5728)
  • DESCRIBE TABLE statement (5755)
  • PREPARE statement (6064)
  • system table name (4183)
  • system-column-name (5568)
  • description (4416)
  • in ALTER TABLE statement (5169)
  • in CREATE TABLE statement (5480)
  • in CREATE VIEW statement (5583)
  • system-object-name
  • definition (4417)
  • SYSTYPES table (6447)
  • SYSVIEWDEP view (6449)
  • SYSVIEWS view (6451)
    • T
  • table
  • altering (5165)
  • creating (5477)
  • definition (4179)
  • dependent (4229)
  • descendent (4228)
  • designator (4689), (5030)
  • distributed (4188)
  • dropping (5785)
  • parent (4206), (4227)
  • primary key (4196)
  • self-referencing (4230)
  • system table name (4184)
  • temporary (6051)
  • TABLE clause
  • COMMENT ON statement (5306)
  • DROP statement (5807)
  • LABEL ON statement (6009)
  • RENAME statement (6093)
  • table name generation
  • rules (5570)
  • table-name
  • description (4418)
  • in ALTER TABLE statement (5166)
  • in CREATE ALIAS statement (5355)
  • in CREATE INDEX statement (5409)
  • in CREATE TABLE statement (5478), (5546)
  • in DELETE statement (5693)
  • in DROP statement (5808)
  • in GRANT (table privileges) statement (5943)
  • in INSERT statement (5976)
  • in LABEL ON statement (6010)
  • in LOCK TABLE statement (6021)
  • in REFERENCES clause of ALTER TABLE statement (5220)
  • in RENAME statement (6094)
  • in REVOKE (table privileges) statement (6146)
  • in UPDATE statement (6252)
  • TAN function (5052)
  • TANH function (5054)
  • temporary
  • result table (5608)
  • temporary tables in OPEN (6050)
  • TEXT clause
  • LABEL ON statement (6006)
  • TIME
  • time
  • arithmetic operations (4776)
  • assignment (4602)
  • data type (4511)
  • data type for CREATE TABLE (5504)
  • duration (4771)
  • function (5056)
  • strings (4548)
  • time and date See date and time
  • data types
  • string representation (4514)
  • TIMESTAMP
  • timestamp
  • arithmetic operations (4777)
  • assignment (4603)
  • data type (4512)
  • data type for CREATE TABLE (5505)
  • duration (4773)
  • function (5058)
  • strings (4559)
  • TIMFMT clause
  • in SET OPTION statement (6214)
  • TIMSEP clause
  • in SET OPTION statement (6215)
  • tokens in SQL (4362), (4367)
  • TRANSLATE function (5060)
  • trigger (4244)
  • delete rules (5702)
  • RELEASE statement (6081)
  • ROLLBACK (6170)
  • SET CONNECTION statement (6187)
  • setting isolation level (6237)
  • update rules (6280)
  • TRIM function (5062)
  • TRUNCATE function (5064)
  • truncation of numbers (4580)
  • truth table (4820)
  • truth valued logic (4816)
  • type
  • dropping (5791)
  • TYPE clause
  • COMMENT ON statement (5298)
  • DROP statement (5789)
  • type-name
  • in DROP statement (5790)
  • in REVOKE (type privileges) statement (6160)
    • U
  • UCASE function (5067)
  • UCS-2 (universal coded character set)
  • description (4460)
  • UCS-2 graphic constant
  • hexadecimal (4649)
  • unary
  • minus (4734)
  • plus (4733)
  • uncommitted read (4289)
  • unconnected state (4329)
  • undefined reference (4692)
  • Unformatted Julian date format (4543) See also date and time
  • UNION ALL clause
  • of fullselect (5130)
  • UNION clause
  • of fullselect (5129)
  • with duplicate rows (5131)
  • UNIQUE clause
  • ALTER TABLE statement (5190), (5209)
  • CREATE INDEX statement (5403), (5404)
  • CREATE TABLE statement (5530), (5538)
  • unique index (4201)
  • update rules (6273)
  • unique key (4194)
  • unit of work
  • COMMIT (5314)
  • ending
  • closes cursors (6049)
  • COMMIT (5315)
  • referring to prepared statements (6058)
  • ROLLBACK (6169)
  • UPDATE
  • in ON UPDATE clause of ALTER TABLE statement (5229)
  • in ON UPDATE clause of CREATE TABLE statement (5555)
  • UPDATE clause (5140)
  • GRANT (table privileges) statement (5940), (5941)
  • REVOKE (table privileges) statement (6143), (6144)
  • update rules (6270)
  • check constraint (6275)
  • checking of unique constraints (6271)
  • effect of commitment control (6272)
  • referential integrity (6283)
  • trigger (6281)
  • views with WITH CHECK OPTION (6278)
  • UPDATE statement (6250), (6290)
  • UPPER function (5068)
  • UR (uncommitted read) (4292)
  • USA (IBM USA standard) (4541) See also date and time
  • USAGE clause
  • GRANT (type privileges) statement (5957)
  • REVOKE (type privileges) statement (6158)
  • USER clause
  • ALTER TABLE statement (5176), (5182)
  • CONNECT (Type 1) statement (5327)
  • CONNECT (Type 2) statement (5340)
  • CREATE TABLE statement (5522)
  • USER special register (4680)
  • user-defined types (UDFs)
  • data types
  • description (4563)
  • USING clause
  • CONNECT (Type 1) statement (5330)
  • CONNECT (Type 2) statement (5343)
  • DESCRIBE statement (5726)
  • DESCRIBE TABLE statement (5753)
  • EXECUTE statement (5829)
  • OPEN statement (6041)
  • PREPARE statement (6062)
  • USING DESCRIPTOR clause
  • CALL statement (5272)
  • EXECUTE statement (5835)
  • OPEN statement (6043)
  • USING HASHING
  • in CREATE TABLE statement (5564)
  • USRPRF clause
  • in SET OPTION statement (6216)
    • V
  • VALUE function (5070)
  • VALUES clause
  • INSERT statement (5979), (5993)
  • VALUES INTO statement (6291)
  • VAR function (4863)
  • VARCHAR
  • data type for CREATE PROCEDURE (5429)
  • data type for CREATE TABLE (5496)
  • data type for DECLARE PROCEDURE (5634)
  • function (5072)
  • VARGRAPHIC
  • data type for CREATE PROCEDURE (5430)
  • data type for CREATE TABLE (5500)
  • data type for DECLARE PROCEDURE (5635)
  • function (5074)
  • variable
  • file reference (4704), (4705)
  • VARIANCE function (4862)
  • view See also CREATE VIEW statement
  • catalog (6409)
  • creating (5577)
  • description (4247)
  • dropping (5809)
  • read-only (5597)
  • updating with WITH CHECK OPTION views (6279)
  • VIEW clause
  • CREATE VIEW statement (5578)
  • DROP statement (5810)
  • view-name
  • description (4419)
  • in CREATE ALIAS statement (5356)
  • in CREATE VIEW statement (5579)
  • in DELETE statement (5694)
  • in DROP statement (5811)
  • in GRANT (table privileges) statement (5944)
  • in INSERT statement (5977)
  • in LABEL ON statement (6011)
  • in RENAME statement (6095)
  • in REVOKE (table privileges) statement (6147)
  • in UPDATE statement (6253)
    • W
  • WEEK function (5076)
  • WHENEVER statement (6301), (6311)
  • WHERE clause
  • DELETE statement (5697)
  • of subselect (5119)
  • UPDATE statement (6264)
  • WHERE CURRENT OF clause
  • DELETE statement (5699)
  • UPDATE statement (6267)
  • WHERE NOT NULL clause
  • in CREATE INDEX statement (5405)
  • WITH CASCADED CHECK OPTION clause
  • CREATE VIEW statement (5589)
  • WITH CHECK OPTION clause
  • CREATE VIEW statement (5587)
  • effect on update (6277)
  • WITH clause (5146)
  • WITH COMPARISONS
  • CREATE DISTINCT TYPE statement (5374)
  • WITH DATA DICTIONARY clause
  • CREATE COLLECTION statement (5366)
  • CREATE SCHEMA statement (5471)
  • WITH DEFAULT clause
  • CREATE TABLE statement (5515)
  • WITH DISTINCT VALUES clause
  • CREATE INDEX statement (5412)
  • WITH GRANT OPTION clause
  • in GRANT (function or procedure privileges) statement (5913)
  • in GRANT (package privileges) statement (5925)
  • in GRANT (table privileges) statement (5947)
  • in GRANT (type privileges) statement (5961)
  • WITH HOLD clause
  • in DECLARE CURSOR statement (5611)
  • WITH LOCAL CHECK OPTION clause
  • CREATE VIEW statement (5591)
  • words
  • reserved (4373), (6390)
  • WORK clause
  • in COMMIT statement (5313), (5318)
  • ROLLBACK statement (6172)
    • X
  • XOR function (5078)
    • Y
  • YEAR function (5080)
  • year, month, day date format (4546) See also date and time
    • Z
  • ZONED function (5082)

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