Index

• ( { } ), braces
  • collection delimiters
  • comment indicators (1), (2)
  • specifying empty collection
• ( [ ] ), brackets
  • array subscripts
  • as range delimiters
  • substring operator (1), (2)
• ( | | ), concatenation operator (1), (2)
• (/* */), slash and asterisk
  • comment indicator (1), (2), (3)
  • comment symbol
• ( @ ), at symbol
• ( | ), pipe character (1), (2), (3), (4), (5)
• (--), double hyphen, comment indicator
• (*), asterisk
  • arithmetic operator
  • as wildcard character
  • in Projection clause
• (\), backslash
  • as wildcard character
  • escape character
• (^), caret
  • as wildcard character
• (:), colon symbol
  • DATETIME separator
  • INTERVAL separator
• (.), decimal point
  • DATETIME separator
  • INTERVAL separator
  • literal numbers (1), (2)
• (/), division symbol
  • arithmetic operator
• ("), double quotes
  • delimiting SQL identifiers
  • literal in a quoted string
  • quoted string delimiter (1), (2)
  • with delimited identifiers (1), (2)
• (=), equal sign
  • assignment operator
  • relational operator (1), (2)
• (!), exclamation point
  • in smart-large-object filename
• (-), hyphen symbol
  • DATETIME separator
  • INTERVAL separator
• (-), minus sign
  • arithmetic operator
  • INTERVAL literals
  • unary operator (1), (2)
• (%), percent sign
  • as wildcard
• (.), period symbol
  • DATETIME separator
  • DECIMAL values
  • dot notation
  • INTERVAL separator
  • MONEY values
• (+), plus sign
  • arithmetic operator
  • in optimizer directives
  • unary operator (1), (2)
• (?), question mark
  • as placeholder in PREPARE (1), (2)
  • as wildcard
  • dynamic parameters
  • generating unique large-object filename
  • variables in PUT
• ('), single quotes
  • literal in a quoted string
  • quoted string delimiter
• (_), underscore
  • as wildcard character
• $INFORMIXDIR/etc/sqlhosts.
  • See sqlhosts file.
• .jar filename extension

• ABS function (1), (2)
• ABSOLUTE keyword, in FETCH statement
• Access control
  • See Privilege.
• ACCESS keyword
  • in ALTER TABLE statement
  • in CREATE TABLE statement
  • in INFO statement
• Access method
  • attributes (1), (2)
  • configuring
  • default operator class, assigning
  • defined
  • index
  • modifying
  • primary
  • privileges (1), (2)
  • privileges needed
    • to drop
  • purpose options
  • registering (1), (2)
  • secondary
  • specifying in CREATE TABLE
  • sysams system catalog table settings
• ACCESS_METHOD keyword
  • in ALTER ACCESS_METHOD statement
  • in CREATE ACCESS_METHOD statement
  • in DROP ACCESS_METHOD statement
• Access mode for transactions
• Accessibility
  • dotted decimal format of syntax diagrams
  • syntax diagrams, reading in a screen reader
• ACOS function (1), (2)
• Action clause, in CREATE TRIGGER statement
  • action list
  • syntax
• Active connection
• ACTIVE keyword, in SAVE EXTERNAL DIRECTIVES statement
• Active set
  • constructing with OPEN statement
  • empty
  • retrieving with FETCH
  • sequential cursor
• ADD CONSTRAINT keywords
  • in ALTER TABLE statement
• ADD keyword
  • in ALTER ACCESS_METHOD statement
  • in ALTER FRAGMENT statement
  • in ALTER FUNCTION statement
  • in ALTER PROCEDURE statement
  • in ALTER ROUTINE statement
  • in ALTER TABLE statement (1), (2)
• ADD ROWIDS keywords
  • in ALTER TABLE statement
• ADD TYPE keywords
  • in ALTER TABLE statement
• AFTER keyword
  • in ALTER FRAGMENT statement (1), (2)
  • in CREATE TRIGGER statement (1), (2)
• Aggregate functions
  • arguments
  • as arguments
  • AVG
  • COUNT
  • in ESQL
  • in EXISTS subquery
  • in expressions
  • in GROUP BY Clause
  • in ORDER BY clause
  • in SELECT statement
  • MAX (1), (2)
  • MIN
  • RANGE
  • STDEV
  • SUM
  • summary
  • syntax
    • AVG
    • COUNT
    • MAX
    • MIN
    • SUM
  • using DISTINCT
  • VARIANCE
• AGGREGATE keyword
  • in CREATE AGGREGATE statement
  • in DROP AGGREGATE statement
• Algebraic functions
  • ABS
  • MOD
  • POW
  • ROOT
  • ROUND
  • SQRT
  • TRUNC
• Alias
  • for a collection in SELECT statement
  • for a table in SELECT statement (1), (2)
  • in optimizer directives
• ALIGNMENT keyword, in CREATE OPAQUE TYPE statement
• ALL keyword
  • beginning a subquery
  • in Condition segment
  • in CREATE INDEX statement
  • in CREATE VIEW statements
  • in DISCONNECT statement
  • in Expression segment (1), (2)
  • in GRANT FRAGMENT statement
  • in GRANT statement
  • in REVOKE FRAGMENT statement
  • in REVOKE statement (1), (2)
  • in SELECT statement
  • in SET Transaction Mode statement (1), (2)
  • with UNION operator (1), (2)
• ALL_MUTABLES keyword, in SET ALL_MUTABLES statement
• ALL_ROWS keyword
  • in Optimizer Directives Segment
  • in SET OPTIMIZATION statement
• ALLOCATE COLLECTION statement
• ALLOCATE DESCRIPTOR statement
• ALLOCATE ROW statement
• Allocating memory
  • for a collection variable
  • for system-descriptor area
• ALLOW_NEWLINE configuration parameter
• Allowing newline characters in quoted strings
• ALPHA class
• ALS.
  • See Global Language Support.
• ALTER ACCESS_METHOD statement
• ALTER FRAGMENT statement
  • am_readwrite purpose flag
  • hybrid fragmentation
  • INIT clause
  • privileges required
  • restrictions
  • reverting to nonfragmented table
    • with DETACH
    • with INIT
  • syntax
  • with generalized-key index
• ALTER INDEX statement
  • reclustering a table
  • specifying lock modes
• ALTER keyword
  • in GRANT statement (1), (2)
  • in REVOKE statement (1), (2)
• Alter privilege
• ALTER privilege (1), (2)
• ALTER SEQUENCE statement
• ALTER TABLE statement
  • adding rowids
  • cascading deletes
  • changing column data type
  • dropping a column
  • privileges needed
  • restrictions
    • ADD clause
    • DROP clause
    • general
    • MODIFY clause
• am_cluster purpose flag
  • defined
• am_defopclass purpose value
  • defined
• am_keyscan purpose flag
  • defined
• am_parallel purpose flag
  • defined
• am_readwrite purpose flag
  • defined
• am_rowids purpose flag
  • defined
• am_sptype purpose value
  • defined
• am_unique purpose flag
  • defined
• American National Standards Institute.
  • See ANSI compliance.
• AND keyword
  • in Condition segment (1), (2)
  • in CREATE INDEX statement
  • with BETWEEN keyword
• ANSI compliance
  • -ansi compilation flag
  • -ansi flag (1), (2), (3)
  • comment symbols
  • creating views
  • list of SQL statements
  • privileges on UDRs
  • renaming a table
  • table privileges
  • unbuffered logging
• ANSI-compliance
  • escape character
  • implicit transactions
  • isolation level (1), (2)
  • owner names
  • SQLSTATE codes
  • update cursors (1), (2), (3)
  • warning after DELETE
• ANSI-compliant database
  • creating
  • database object naming
  • implicit transactions
  • opaque-type naming
  • procedure name
  • table privileges
  • upshifting owner names
  • warning after opening
  • with BEGIN WORK
• ansi flag
• ANSI keyword
  • in CREATE DATABASE statement
• ANSIOWNER environment variable (1), (2)
• ANY keyword
  • in Condition segment
  • in SELECT statement
• APPEND keyword
  • in SET DEBUG FILE statement
  • in SET EXPLAIN statement
  • in SET PLOAD FILE statement
• Application
  • comment indicators
  • single-threaded
  • thread-safe (1), (2), (3), (4)
• Application partitioning.
• Arguments
• Arithmetic functions.
  • See Algebraic functions.
• Arithmetic operators
  • binary
  • syntax
  • unary
• Array, with FETCH
• AS keyword
  • in ALTER FRAGMENT statement
  • in Collection-Derived-Table segment
  • in CONNECT statement
  • in CREATE CAST statement
  • in CREATE DISTINCT TYPE statement
  • in CREATE INDEX statement
  • in CREATE TRIGGER statement
    • Delete triggers
    • Insert triggers
    • SELECT triggers
    • Update triggers
    • view column values
  • in CREATE VIEW statement
  • in DROP CAST statement
  • in explicit casts
  • in GRANT FRAGMENT statement
  • in Iterator segment
  • in MERGE statement
  • in REVOKE statement (1), (2)
  • in SELECT statement Projection clause
  • with display labels
  • with table aliases
• AS PARTITION keywords, in ALTER FRAGMENT statement
• AS REMAINDER keywords, in ALTER FRAGMENT statement
• ASC keyword
  • in CREATE INDEX statement
  • in SELECT statement (1), (2)
  • order with nulls
• Ascending sequence (1), (2)
• ASCII code set
• ASCII keyword
  • in CREATE EXTERNAL TABLE statement
  • in SELECT statement
• ASIN function (1), (2)
• Assign support function (1), (2), (3), (4), (5)
• Associated statement
• Asterisk (*)
  • argument to COUNT function
  • arithmetic operator
  • as wildcard character
  • in C-style comment indicators
  • in projection list
  • Projection clause
• Asterisk (*) symbol
  • in comment indicators
• AT keyword
  • in INSERT statement
• At symbol ( @ )
• ATAN function (1), (2)
• ATAN2 function (1), (2)
• ATTACH keyword, in ALTER FRAGMENT statement
• Attached indexes (1), (2), (3), (4)
• Audit-event mnemonics
• Authorization identifier (1), (2), (3), (4)
• AUTHORIZATION keyword
  • in CREATE SCHEMA statement
  • in SET SESSION AUTHORIZATION statement
• Autofree feature, in SET AUTOFREE
• AVG function (1), (2)
• AVOID_EXECUTE keyword
  • in SET EXPLAIN statement
  • optimizer directive
• AVOID_FULL keyword, in Optimizer Directives segment
• AVOID HASH keyword, in Optimizer Directives segment
• AVOID_INDEX keyword, in Optimizer Directives segment
• AVOID_NL keyword, in Optimizer Directives segment

• B-tree cleaner list
• B-tree index
  • btree_ops operator class
  • default operator class
  • detached
  • uses
• B-tree secondary-access method (1), (2)
• Background mode
• Backslash (\)
  • as escape character
  • as wildcard character
  • escape character
• Base-100 format
• BASE64 encoding of encrypted data
• BASE64 encryption format
• Batch file
• BEFORE keyword
  • in ALTER FRAGMENT statement (1), (2)
  • in ALTER TABLE statement
  • in CREATE TRIGGER statement (1), (2)
• BEGIN keyword
  • in IF statement
  • in Statement Block segment
• BEGIN WORK statement
• BETWEEN keyword
  • in Condition segment (1), (2)
• Big-endian format
• BigDecimal data type of Java (1), (2)
• Binary-format integers
• BINARY keyword
  • in CREATE EXTERNAL TABLE statement
• Binary operator (1), (2)
• Bit-hashing function
• BITMAP keyword, in CREATE INDEX statement
• Blank characters
  • DATETIME separator
  • in index names
  • in literal numbers
  • INTERVAL separator
• BLOB data type
  • copying to a file
  • copying to a smart large object
  • creating from a file
  • declaration syntax
  • default value
  • handle values
  • size limit
  • storing (1), (2)
  • unloading (1), (2)
• BLOB keyword
  • in Data Type segment
  • in DEFINE statement
• Blobspace
• Boldface type
• BOOLEAN data type
  • defined
  • literal values
  • unloading
• Boolean expression
• BOTH keyword, in TRIM expressions
• BOUND_IMPL_PDQ keyword
  • in SET ENVIRONMENT statement
• Braces ( { } )
  • collection delimiters
  • comment indicator (1), (2)
  • specifying empty collection
• Brackets ( [ ] )
  • as range delimiters
• BROADCAST optimizer directive (1), (2)
• BUFFERED keyword
  • in CREATE DATABASE statement
  • in SET LOG statement
• BUFFERED LOG keyword
  • in CREATE DATABASE
• Buffered logging
• Built-in aggregates
  • contrasted with user-defined
  • defined
  • extending
• Built-in data types
  • opaque
  • owner
  • privileges on
  • syntax
• Built-in routines
  • jvpcontrol
  • sqlj.alter_java_path
  • sqlj.install_jar
  • sqlj.remove_jar
  • sqlj.replace_jar
  • sqlj.unsetUDTExtName
• Built-in secondary-access method
• BY keyword
  • in ALTER FRAGMENT statement
  • in ALTER SEQUENCE statement
  • in CREATE SEQUENCE statement
  • in SELECT statement (1), (2)
• BYTE and TEXT columns, fragment storage (1), (2)
• BYTE column
  • modifying
• BYTE data
  • effect of isolation on retrieval (1), (2)
  • loading
  • storage location
  • unloading (1), (2)
• BYTE data type
  • declaration syntax
  • default value
  • with SET DESCRIPTOR
  • with SPL routines (1), (2)
• BYTE keyword
  • in Data Type segment
  • in DEFINE statement
  • in Return Clause segment

• C++ API
• C keyword, in External Routine Reference segment
• Cache cohesion
• CACHE keyword
  • in ALTER SEQUENCE statement
  • in CREATE SEQUENCE statement
  • in SET STATEMENT CACHE statement
• Calculated expression
  • restrictions with GROUP BY
• Calendar
• CALL keyword
  • in WHENEVER statement
• CALL keyword, in WHENEVER statement
• CALL statement
• Callbacks
• CANNOTHASH keyword, in CREATE OPAQUE TYPE statement
• CANNOTHASH modifier
• CARDINALITY function
• Caret (^)
  • as wildcard character
  • use with square brackets
• Cartesian product
• CASCADE keyword
  • in ALTER TABLE statement
  • in CREATE TABLE statement
  • in DROP TABLE statement
  • in DROP VIEW statement
  • in MOVE TABLE statement
  • in REVOKE statement
• Cascading deletes
  • CREATE TABLE with (1), (2)
  • locking associated with
  • logging
  • multiple child tables
• Cascading triggers
  • and triggering table
  • triggered actions
• Case conversion
  • functions
    • INITCAP
    • LOWER
    • UPPER
• CASE keyword
  • in Expression segment (1), (2)
• CASE statement
• CAST keyword
  • in DROP CAST statement
  • in explicit casts
• Casts
  • built-in (1), (2)
  • creating
  • dropping
  • explicit (1), (2)
  • function for
  • implicit (1), (2)
  • operator ( :: ) (1), (2)
  • privileges
  • registering
  • symbol
• cdrserver, replication column name
• cdrserver shadow column
• cdrtime, replication column name
• cdrtime shadow column
• Chaining synonyms
• CHAR data type
  • defined (1), (2), (3)
  • in INSERT
• CHAR_LENGTH function (1), (2)
• Character data types
  • fixed and varying length (1), (2), (3)
  • syntax
• CHARACTER_LENGTH function (1), (2)
• CHARACTER VARYING data type
  • See also $INFORMIXDIR/etc/sqlhostsVARCHAR data type.
  • syntax
• Check constraints
  • defining
  • moving
  • reject files
  • unloading data
• CHECK keyword
  • in ALTER TABLE statement
  • in CREATE EXTERNAL TABLE statement
  • in CREATE TABLE statement
  • in CREATE VIEW statement
• Child table
• CLASS keyword, in Routine Modifier segment
• CLASS_ORIGIN keyword, in GET DIAGNOSTICS statement
• Client APIs of Dynamic Server
• CLIENT_TZ keyword
  • in SET ENVIRONMENT statement (1), (2), (3)
• CLIENTBINVAL data type
• CLOB data type
  • copying to a file
  • copying to a smart large object
  • creating from a file
  • default value
  • handle values
  • size limit
  • unloading (1), (2)
• CLOB keyword
  • in Data Type segment
  • in DEFINE statement
• CLOSE DATABASE statement
  • prerequisites to close
  • syntax
• CLOSE statement
  • closing a collection cursor
  • closing a select cursor
  • closing an insert cursor
  • cursors affected by transaction end
  • syntax
• CLUSTER keyword
  • in ALTER INDEX statement
  • in CREATE INDEX statement
• Clustered index (1), (2)
• Clustering, specifying support for
• Co-locality
• COARSE keyword
  • in ALTER INDEX statement
  • in CREATE INDEX statement
• Code, sample, conventions for
• Code points, ASCII
• Code sets, ISO 8859-1
• CODESET keyword
  • in CREATE EXTERNAL TABLE statement
  • in SELECT statement
• Cogroup name
• Collating order
• Collation
  • with relational operators
• COLLATION keyword, in SET COLLATION statement
• Collection constructors
  • example (1), (2)
  • restrictions
• Collection cursor
  • closing
  • DECLARE for ESQL/C variable
  • declaring
  • defined
  • in SPL
  • inserting into (1), (2), (3)
  • INTO clause
  • opening
• Collection data type (1), (2)
  • allocating memory
  • defining a column
  • deleting
  • element, searching for with IN
  • IN operator
  • LIST
  • loading
  • MULTISET
  • returning number of elements
  • selecting from
  • SET
  • unloading
  • updating
• Collection-derived table
  • collection cursor (1), (2), (3)
  • collection variables with
  • FOREACH statement
  • in SELECT statement
  • INSERT statement with (1), (2)
  • row types in
  • row variables with
  • SELECT statement with
    • fields from row variable
  • TABLE keyword (1), (2), (3)
  • UPDATE statement with (1), (2), (3)
  • where allowed
• COLLECTION keyword
  • in ALLOCATE COLLECTION statement
  • in DEALLOCATE COLLECTION statement
  • in DEFINE statement
  • untyped collection variable
• Collection Subquery
  • segment
• Collection variable
  • accessing
  • accessing values
  • associating cursor with
  • cursor for
  • deallocating memory for
  • in SELECT statement
  • manipulating values
  • opening a cursor
  • selecting, inserting elements
  • selecting from
  • untyped (1), (2)
  • updating (1), (2)
  • with DESCRIBE INPUT statement
  • with DESCRIBE statement
• Collections
  • accessing a nested collection
  • accessing elements
  • allocating memory
  • constructors
  • deleting elements from
  • example of deleting elements
  • example of inserting elements
  • example of updating
  • generating values for
  • inserting values into
  • nested
  • restrictions when accessing elements
  • restrictions when defining
  • restrictions with inserting null values
  • selecting from
  • specifying literal values
  • updating
• Colon symbol (:)
  • cast operator ( :: )
  • DATETIME separator
  • INTERVAL separator
  • with database qualifier
• Column definition clause
• Column expression
• COLUMN keyword, in RENAME COLUMN statement
• Column level encryption
• Column-level encryption
• Column name
  • dot notation
  • using functions as names (1), (2)
  • using keywords as names
• Column substring
• Columns
  • adding
  • adding a NOT NULL constraint
  • changing the data type
  • check constraints
  • defining as primary key
  • dropping (1), (2)
  • expression (1), (2)
  • inserting into
  • modifying with ALTER TABLE
  • number, effect on triggers
  • order in Projection list
  • primary or foreign key
  • privileges
  • projection
  • referenced and referencing
  • removing a NOT NULL constraint
  • renaming
  • specifying a subscript (1), (2)
  • specifying check constraint for
  • varying-length
  • virtual
• COLUMNS keyword, in INFO statement
• COMBINE keyword
  • in CREATE AGGREGATE statement
• Command file
• Command-line conventions
  • how to read
  • sample diagram
• Comment symbol
  • braces ( { } )
  • double hyphen (--)
  • in application programs
  • in optimizer directives
  • in prepared statements
  • slash and asterisk (/* */) (1), (2)
  • slash-and-asterisk ( / * */ )
• COMMIT WORK statement
  • in ANSI-compliant databases
  • in non-ANSI databases
  • syntax
• COMMITTED keyword
  • in SET ISOLATION statement
  • in SET TRANSACTION statement
• COMMITTED keyword, in SET TRANSACTION statement
• Committed Read isolation level
• COMMITTED READ keywords, in SET ISOLATION statement
• Compacted index
• Compare support function
• Complete-connection level settings
  • of SET EXPLAIN
  • of SET ISOLATION
  • of SET LOCK MODE
• Complex data type
  • loading element values
  • unloading
• Complex numbers
• Complex table expression
• Complex view
• Compliance
  • with industry standards
• Composite key
• Compound assignment
• COMPUTE_QUOTA keyword
  • in SET ENVIRONMENT statement
• concat() operator function
• Concatenation operator ( | | ) (1), (2)
• Concurrency
  • with CREATE INDEX
  • with DROP INDEX
  • with SET ISOLATION
  • with SET TRANSACTION
  • with START VIOLATIONS TABLE
• CONCURRENT keyword, in CONNECT statement
• Condition segment
  • join conditions
  • keywords
    • ALL
    • ANY
    • BETWEEN
    • EXISTS
    • IS NOT NULL
    • IS NULL
    • LIKE
    • MATCHES
    • NOT
    • SOME
  • null values
  • subquery in SELECT
  • syntax
• Conditional expressions
  • CASE
  • DECODE
  • NVL
• Conditions
  • comparison (1), (2)
  • IN operator
  • NOT IN operator
• Configuration parameters
  • ALLOW_NEWLINE
  • DATASKIP
  • DB_LIBRARY_PATH
  • DBSERVERALIAS (1), (2), (3), (4)
  • DBSERVERNAME (1), (2), (3), (4)
  • DEADLOCK_TIMEOUT
  • DEF_TABLE_LOCKMODE (1), (2), (3)
  • DIRECTIVES
  • DS_NONPDQ_QUERY_MEM
  • EXT_DIRECTIVES
  • FILLFACTOR
  • IFX_EXTEND_ROLE (1), (2), (3), (4), (5)
  • JVPCLASSPATH
  • LOCKS
  • OPTCOMPIND (1), (2)
  • SEQ_CACHE_SIZE (1), (2)
  • STACKSIZE
  • STMT_CACHE
  • STMT_CACHE_HITS
  • STMT_CACHE_NOLIMIT
  • STMT_CACHE_SIZE
  • USEOSTIME
• Conflict resolution
• CONNECT keyword
  • in GRANT statement
  • in REVOKE statement
• Connect privilege
  • granting
• CONNECT statement
• CONNECTION_ALIAS keyword, in GET DIAGNOSTICS statement
• Connections
  • context (1), (2)
  • current (1), (2), (3)
  • default (1), (2)
  • dormant (1), (2), (3)
  • explicit (1), (2), (3)
  • implicit (1), (2), (3), (4), (5)
  • single-threaded applications
• Constant expression
  • in SELECT
  • inserting with PUT
• Constraint
  • renaming
• CONSTRAINT keyword
  • in ALTER TABLE statement (1), (2), (3)
  • in CREATE TABLE statement
• Constraints
  • adding primary-key
  • adding referential
  • adding to a column with data
  • adding unique
  • adding with ALTER TABLE (1), (2)
  • affected by dropping a column from table
  • B-tree indexes
  • checking (1), (2), (3)
  • detached checking
  • disabled (1), (2)
  • dropping with ALTER TABLE
  • enabled
  • encountering violations while adding
  • filtering
  • filtering to violations table
  • foreign key
  • limit on size
  • mode
  • modifying a column that has constraints
  • moving (1), (2)
  • multiple-column
  • name
  • number of columns allowed
  • privileges needed to create
  • referential (1), (2)
  • single-column
  • system catalog tables
  • transaction mode
• CONSTRAINTS keyword
  • in SET CONSTRAINTS statement
  • in SET Database Object Mode statement (1), (2)
  • in SET Transaction Mode statement
• constrid column
• Constructors
  • functions
    • collections
    • row
• Contact information
• CONTINUE keyword
  • in WHENEVER statement
• CONTINUE statement
• Conventions
  • command-line
  • documentation
  • sample-code
  • syntax diagrams
  • syntax notation
  • typographical
• Correlated subqueries
• Correlated subquery
  • defined
• Correlation name
  • in routines
  • qualifying values
  • restrictions
  • scope of reference
• COS function (1), (2)
• Coserver
  • number
• Coserver number
• COSTFUNC keyword, in Routine Modifier segment (1), (2)
• COUNT field
  • in ALLOCATE DESCRIPTOR statement
  • in GET DESCRIPTOR statement
  • with DESCRIBE INPUT statement
  • with DESCRIBE statement
• COUNT function
  • defined
  • restriction with CREATE TRIGGER statement
  • syntax
• COUNT keyword
  • See also COUNT field.
  • in SET DESCRIPTOR statement
• CPU usage cost
• CPU VP
• CRCOLS keyword
  • in CREATE TABLE statement
• CREATE ACCESS_METHOD statement
• CREATE AGGREGATE statement
• CREATE CAST statement
• CREATE DATABASE statement
  • ANSI compliance
  • syntax
  • using with PREPARE
• CREATE DISTINCT TYPE statement
• CREATE DUPLICATE statement
• CREATE EXTERNAL TABLE statement
• CREATE FUNCTION
  • statement
• CREATE INDEX statement
  • cluster with fragments
  • composite indexes
  • disabled indexes
  • index-type options
  • sort order
  • specifying lock modes
  • specifying object modes
  • storage options
• CREATE OPAQUE TYPE statement
• CREATE PROCEDURE FROM statement
• CREATE PROCEDURE statement
• CREATE ROLE statement
• CREATE ROUTINE FROM statement
• CREATE ROW TYPE statement
• CREATE SCHEMA statement
  • defining a trigger
  • syntax
• CREATE SCRATCH TABLE statement
• CREATE SEQUENCE statement
• CREATE SYNONYM statement
  • syntax
• CREATE TABLE statement
  • access-method option
  • column definition clause
  • column-level constraints
  • constraints
    • check
    • composite keys (1), (2)
    • defining
    • distinct
    • example
    • NOT NULL (1), (2)
    • primary key
    • referential
    • restrictions
    • unique
  • CRCOLS keyword
  • creating composite columns
  • creating shadow-replication columns
  • defining constraints
  • fragmenting
    • by expression
    • by hash
    • by hybrid
    • by range
    • round-robin
    • syntax
  • locking options
  • ON DELETE CASCADE keywords
  • OPERATIONAL keyword (1), (2)
  • PUT clause
  • RAW keyword (1), (2)
  • specifying cascading deletes
  • specifying column-default values
  • specifying storage location
  • STANDARD keyword (1), (2)
  • STATIC keyword (1), (2)
  • syntax
  • WITH CRCOLS keywords
  • WITH ROWIDS keywords
• CREATE TEMP TABLE
  • statement
• CREATE TEMP TABLE.
  • See CREATE Temporary TABLE statement.
• CREATE Temporary TABLE statement
  • storage options
  • syntax
• CREATE TRIGGER statement
  • no table expressions
  • syntax
• CREATE VIEW statement (1), (2)
• CREATE XADATASOURCE statement
• Creation-time settings of environment variables
• CROCOLS keyword, in CREATE Temporary TABLE statement
• Cross-database DML operations (1), (2), (3), (4)
• Cross joins
• CROSS keyword in SELECT statement
• CRPT audit-event mnemonic
• CSN encryption
• CTRL-J
  • newline
    • preserving in quoted strings
• Current database, specifying with DATABASE
• Current date (1), (2)
• CURRENT DORMANT keywords, in SET CONNECTION statement
• CURRENT function
  • as an argument
  • as constant expression
  • example
  • in ALTER TABLE statement
  • in Condition segment
  • in CREATE TABLE statement
  • in DEFINE statement
  • in INSERT statement (1), (2)
  • in WHERE condition
• CURRENT keyword
  • in DELETE statement
  • in DISCONNECT statement
  • in FETCH statement
  • in SET CONNECTION statement
  • in UPDATE statement (1), (2)
• CURRENT_ROLE operator
  • defined (1), (2)
  • syntax
• CURRVAL operator (1), (2), (3)
• Cursor
  • activating with OPEN
  • affected by transaction end
  • characteristics
  • closing
  • closing with ROLLBACK WORK
  • declaring
  • for update
    • restricted statements
    • using in ANSI-mode databases (1), (2)
    • using in non-ANSI databases (1), (2)
  • freeing automatically with SET AUTOFREE
  • implicit
  • manipulation statements
  • opening (1), (2)
  • prepared statement with
  • read-only
    • restricted statements
    • using in ANSI-mode databases (1), (2)
    • using in non-ANSI databases (1), (2)
    • where required
  • retrieving values with FETCH
  • select hold examples
  • sequence of program operations
  • stability
  • statement identifier with
  • types of
  • with INTO keyword in SELECT
  • with transactions
• Cursor function (1), (2), (3)
• CURSOR keyword, in DECLARE statement
• Cursor Stability isolation level
• CURSOR STABILITY keywords, in SET ISOLATION statement
• CYCLE keyword
  • in ALTER SEQUENCE statement
  • in CREATE SEQUENCE statement

• Dangling child records
• Data
  • access statements
  • confidentiality
  • data definition statements
  • data manipulation statements
  • encryption
  • inserting with LOAD
  • integrity statements
• Data buffering
• data column of sysprocbody table
• Data distributions
  • confidence
  • on temporary tables
  • RESOLUTION
• DATA field
  • in GET DESCRIPTOR statement
  • in SET DESCRIPTOR statement
  • with DESCRIBE INPUT statement
  • with DESCRIBE statement
• Data-integrity violations (1), (2)
• DATA keyword.
  • See DATA field.
• Data replication
• Data type segment
• Data types
  • See also each data type listed under its own name.
  • alignment
  • casting (1), (2)
  • changing with ALTER TABLE
  • collection
  • complex
  • considerations for INSERT (1), (2)
  • distinct
  • opaque
  • representation
  • simple large object
  • specifying with CREATE VIEW
• Database administrator
  • granting privileges
• Database administrator (DBA)
  • revoking privileges
• DATABASE keyword
  • in DROP DATABASE statement
  • in MOVE TABLE statement
  • in RENAME DATABASE statement
• Database-level privilege
  • See also Privilege.
  • not available for roles
  • revoking
• Database object
  • naming
  • naming owner
• Database object mode
  • for triggers (1), (2)
  • privileges required
  • specifying
• Database Object Name segment
• Database Server Administrator
• Database Server Administrator (DBSA) (1), (2), (3), (4), (5), (6)
• DATABASE statement
  • determining database type
  • exclusive mode
  • specifying current database
  • SQLWARN after
  • syntax
• Database System Administrator (DBSA)
• Databases
  • ANSI-compliant
  • closing with CLOSE DATABASE
  • data warehousing
  • default isolation levels (1), (2)
  • dropping
  • external
  • global variables
  • isolation level
  • lock
  • naming conventions
  • nonlogging database
  • OLTP
  • opening in exclusive mode
  • optimizing queries
  • read-only mode
  • remote
  • renaming
  • running in secondary mode
• DataBlade API
• DataBlade API (LIBDMI)
• DataBlade Developer's Kit
• DataBlade modules
• DATAFILES keyword
  • in CREATE EXTERNAL TABLE statement
  • in SELECT statement
• DATASKIP configuration parameter
• DATASKIP keyword
  • in SET DATASKIP statement
• DATE data type
  • declaration syntax
  • functions in
  • literal DATE values
• DATE function (1), (2), (3)
• DATETIME data type
  • as quoted string
  • field qualifiers
  • in INSERT
  • literal values (1), (2)
• DATETIME Field Qualifier segment
• datetime.h header file
• DATETIME keyword, in Literal DATETIME
• DAY function (1), (2)
• DAY keyword
  • in DATETIME Field Qualifier (1), (2)
  • in INTERVAL Field Qualifier (1), (2), (3), (4), (5)
  • in Literal DATETIME
• DB-Access utility
• DB_LIBRARY_PATH configuration parameter
• DB_LOCALE environment variable (1), (2), (3), (4), (5), (6)
• DBA.
  • See Database administrator.
• DBA keyword
  • in CREATE FUNCTION statement
  • in CREATE PROCEDURE statement
  • in GRANT statement
  • in REVOKE statement
• DBA privilege
  • with CREATE ACCESS_METHOD statement
  • with CREATE SCHEMA
  • with DROP DATABASE
  • with DROP TRIGGER statement
  • with REVOKE statement
• DBA-privileged UDR
• DBANSIWARN environment variable (1), (2), (3), (4), (5)
• DBBLOBBUF environment variable (1), (2)
• DBCENTURY environment variable (1), (2), (3), (4)
• DBDATE environment variable (1), (2), (3)
• DBDELIMITER environment variable (1), (2)
• dbhostname option of DBINFO
• DBINFO function
• DBMONEY environment variable (1), (2), (3)
• DBPATH environment variable (1), (2)
• DBSA.
  • See Database System Administrator.
• dbschema utility
• dbsendrecv data type
• DBSERVERALIAS configuration parameter (1), (2), (3), (4)
• DBSERVERNAME configuration parameter (1), (2), (3), (4)
• DBSERVERNAME function
  • constant expression
  • in ALTER TABLE statement
  • in Condition segment
  • in CREATE TABLE statement
  • in DEFINE statement
• dbspace
  • renaming with onspaces
• dbspaces
  • number
  • skipping if unavailable
• DBSPACETEMP configuration parameter
• DBSPACETEMP environment variable (1), (2), (3), (4)
• DBTIME environment variable (1), (2)
• DBUPSPACE environment variable
• DDL (Data Definition Language) statements
  • listed
• Deadlock (1), (2)
• Deadlock detection
• DEADLOCK_TIMEOUT setting in ONCONFIG
• DEALLOCATE COLLECTION statement (1), (2)
• DEALLOCATE DESCRIPTOR statement
• DEALLOCATE ROW statement
• DEBUG environment variable
• DEBUG keyword
  • in SET DEBUG FILE statement
• Debugging sysdbopen() routines
• DECIMAL data type (1), (2)
  • literal values
• Decimal point (.)
  • DATETIME separator
  • INTERVAL separator
  • literal numbers (1), (2)
• Declarative statements
• DECLARE statement
  • cursor characteristics
  • CURSOR keyword
  • cursors with prepared statements
  • cursors with transactions
  • FOR UPDATE keywords
  • function cursor
  • insert cursor (1), (2)
  • restrictions with SELECT with ORDER BY
  • SCROLL keyword
  • select cursor
  • syntax
  • updating specified columns
  • WHERE CURRENT OF clause
  • WITH HOLD keywords
  • with SELECT statement
• DECODE function
• DECRYPT_BINARY function
• DECRYPT_CHAR function
• DEF_TABLE_LOCKMODE configuration parameter
• DEF_TABLE_LOCKMODE setting, in ONCONFIG
• DEFAULT_ATTACH environment variable (1), (2)
• Default escape character
• Default isolation level
• DEFAULT keyword
  • in ALTER TABLE statement
  • in CONNECT statement
  • in CREATE EXTERNAL TABLE statement
  • in CREATE TABLE statement
  • in DEFINE statement
  • in DISCONNECT statement
  • in GRANT statement
  • in REVOKE statement
  • in SET CONNECTION statement (1), (2)
  • in SET DATASKIP statement
  • in SET Default Table Space statement
  • in SET Default Table Type statement
  • in SET ENVIRONMENT statement (1), (2)
  • in SET PDQPRIORITY statement
  • in SET ROLE statement
  • SET ROLE statement
• Default locale
• Default role (1), (2), (3)
• DEFERRED keyword, in SET Transaction Mode statement
• Deferred-Prepare feature
• DEFERRED_PREPARE keyword
  • n SET DEFERRED_PREPARE statement
• DEFINE keyword, in Statement Block segment
• DEFINE statement
  • default value clause
  • syntax
• Delete join
• DELETE keyword
  • in CREATE TABLE statement
  • in CREATE TRIGGER statement
  • in GRANT FRAGMENT statement
  • in GRANT statement
  • in REVOKE FRAGMENT statement
  • in REVOKE statement
• Delete privilege (1), (2)
• DELETE statements
  • and triggers
  • cascading
  • collection columns with
  • cursor with
  • distributed
  • OUT parameter
  • restrictions when using a join
  • syntax
  • using joins
  • with SELECT... FOR UPDATE
  • with update cursor
  • within a transaction
• Delete trigger (1), (2)
• Deleting from a specific table in a table hierarchy
• DELIMIDENT environment variable (1), (2), (3), (4), (5), (6), (7)
• Delimited identifiers
  • multibyte characters
  • non-ASCII characters
  • syntax
• DELIMITED keyword
  • in CREATE EXTERNAL TABLE statement
  • in SELECT statement
• Delimiter
  • for LOAD input file
  • specifying with UNLOAD
• DELIMITER keyword
  • in CREATE EXTERNAL TABLE statement
  • in LOAD statement
  • in SELECT statement
  • in UNLOAD statement
• DELUXE keyword
  • in CREATE EXTERNAL TABLE statement
• Demonstration databases
• Dependencies, software
• DESC keyword
  • in CREATE INDEX statement
  • in SELECT statement (1), (2)
  • order with nulls
• Descending sequence (1), (2)
• DESCRIBE INPUT statement
• DESCRIBE statement
  • collection variable with
  • distinct data type with
  • opaque data type with
  • relation to GET DESCRIPTOR
  • syntax
  • with SET DESCRIPTOR
• DESCRIPTOR keyword
  • in ALLOCATE DESCRIPTOR statement (1), (2)
  • in DEALLOCATE DESCRIPTOR statement
  • in EXECUTE statement (1), (2)
  • in FETCH statement
  • in GET DESCRIPTOR statement
  • in OPEN statement
  • in PUT statement
• destroy() support function (1), (2), (3)
• DETACH keyword, in ALTER FRAGMENT statement
• Detached index (1), (2), (3)
• Detached statement
• dev/null output destination
• Diagnostics area
• DIAGNOSTICS keyword, in GET DIAGNOSTICS statement
• Diagnostics table
  • creating
  • examples
  • filtering mode
  • how to stop
  • relationship to target table
  • relationship to violations table
  • restriction on dropping
  • restriction on moving (1), (2)
  • schema
• Directive
• DIRECTIVES configuration parameter
• DIRECTIVES keyword, in SAVE EXTERNAL DIRECTIVES statement
• Dirty Read isolation level (1), (2), (3), (4)
• DIRTY READ keywords, in SET ISOLATION statement
• Disabilities, visual
  • reading syntax diagrams
• DISABLED keyword
  • CREATE TRIGGER statement
  • in ALTER TABLE statement
  • in CREATE INDEX statement
  • in CREATE TABLE statement (1), (2)
  • in CREATE TRIGGER statement
  • in SET AUTOFREE statement
  • in SET Database Object Mode statement (1), (2)
  • in SET DEFERRED_PREPARE statement
• DISCONNECT statement
• DISK keyword
  • in CREATE EXTERNAL TABLE statement
• Display labels
  • in CREATE VIEW statement
  • in Projection clause
  • in SELECT statement (1), (2)
• Distinct data types (1), (2)
  • casting
  • casts and DROP TYPE
  • creating with CREATE DISTINCT TYPE
  • DESCRIBE with
  • distributed queries
  • dropping
  • dynamic SQL with
  • GET DESCRIPTOR with
  • in a remote database
  • in dynamic SQL
  • privileges (1), (2), (3)
  • restrictions on source type
  • source data type (1), (2)
  • Usage privilege
  • with SET DESCRIPTOR
• DISTINCT keyword
  • in ALTER TABLE statement (1), (2)
  • in CREATE DISTINCT TYPE statement
  • in CREATE INDEX statement (1), (2)
  • in CREATE TABLE statement (1), (2)
  • in CREATE Temporary TABLE statement (1), (2)
  • in Expression segment (1), (2)
  • in SELECT statement
  • in subquery
• Distributed DML operations (1), (2), (3)
• Distributed queries (1), (2)
• Distributions
  • dropping
  • medium
  • privileges required to create
• DISTRIBUTIONS keyword, in UPDATE STATISTICS statement (1), (2)
• divide() operator function
• Division (/) symbol, arithmetic operator
• DML (Data Manipulation Language) statements
• DOCUMENT keyword
  • in CREATE FUNCTION statement
  • in CREATE PROCEDURE statement
• Documentation, types of
  • machine notes
  • online manuals
  • printed manuals
• Documentation conventions
• Documentation Notes
• Documentation set of all manuals
• Dominant table
• DORMANT keyword, in SET CONNECTION statement
• Dot notation
• Dotted decimal format of syntax diagrams
• Double hyphen (--) comment indicator (1), (2)
• DOUBLE PRECISION data type
• Double quotes (")
  • delimiting SQL identifiers
  • literal in a quoted string
  • quoted string delimiter (1), (2)
• DROP ACCESS_METHOD statement
• DROP AGGREGATE statement
• DROP CAST statement
• DROP CONSTRAINT keywords, in ALTER TABLE statement
• DROP DATABASE statement
• DROP DISTRIBUTIONS keywords, in UPDATE STATISTICS statement
• DROP DUPLICATE statement
• DROP FUNCTION statement
• DROP INDEX statement
• DROP keyword
  • in ALTER ACCESS_METHOD statement
  • in ALTER FRAGMENT statement
  • in ALTER FUNCTION statement
  • in ALTER PROCEDURE statement
  • in ALTER ROUTINE statement
  • in ALTER TABLE statement
  • in TRUNCATE statement
  • in UPDATE STATISTICS statement
• DROP OPCLASS statement
• DROP PARTITION keywords, in ALTER FRAGMENT statement
• DROP ROLE statement
• DROP ROUTINE statement
• DROP ROW TYPE statement
• DROP SEQUENCE statement
• DROP SYNONYM statement
• DROP TABLE statement
• DROP TRIGGER statement
• DROP TYPE statement
• DROP VIEW statement
• DROP XADATASOURCE statement
• DROP XADATASOURCE TYPE statement
• DS_ADM_POLICY configuration parameter
• DS_NONPDQ_QUERY_MEM configuration parameter
• DS_TOTAL_TMPSPACE configuration parameter
• DUPLICATE keyword
  • in CREATE DUPLICATE statement
  • in DROP DUPLICATE statement
• Duplicate table
  • CREATE DUPLICATE
• Duplicate values
  • in a query
• Dynamic cursor names
• Dynamic link library
• Dynamic log feature
• Dynamic management statement (1), (2)
• Dynamic parameters
• Dynamic routine-name specification
  • of SPL functions
  • of SPL procedures
• Dynamic SQL

• EACH keyword, in CREATE TRIGGER statement (1), (2)
• East Asian locales
• EBCDIC keyword
  • in CREATE EXTERNAL TABLE statement
  • in SELECT statement
• ELECT INTO clause
  • no table expressions
• Element variable
• ELIF keyword, in IF statement
• ELSE keyword
  • in CASE statement
  • in Expression segment (1), (2)
  • in IF statement
• en_us.8859-1 locale
• ENABLED keyword
  • in ALTER TABLE statement
  • in CREATE INDEX statement
  • in CREATE TABLE statement (1), (2)
  • in CREATE TRIGGER statement
  • in SET AUTOFREE statement
  • in SET Database Object Mode statement (1), (2)
  • in SET DEFERRED_PREPARE statement
• ENCRYPT_AES function
• ENCRYPT_TDES function
• Encrypted data (1), (2)
• Encryption and decryption functions
  • DECRYPT_BINARY
  • DECRYPT_CHAR
  • ENCRYPT_AES
  • ENCRYPT_TDES
  • GETHINT
  • syntax
• Encryption communication support module (1), (2)
• ENCRYPTION keyword
  • in SET ENCRYPTION PASSWORD statement
• END CASE keywords, in CASE statement
• END EXCEPTION keywords, in ON EXCEPTION statement
• END FOR keywords, in FOR statement
• END FOREACH keywords, in FOREACH statement
• END FUNCTION keyword
  • in CREATE FUNCTION statement
• END IF keywords, in IF statement
• END keyword
  • in Expression segment (1), (2)
  • in Statement Block segment
• END PROCEDURE keyword
  • in CREATE PROCEDURE statement
• END WHILE keywords, in WHILE statement
• Enterprise Replication
• ENVIRONMENT keyword
  • in SET ENVIRONMENT statement
• Environment variables
  • ANSIOWNER (1), (2)
  • DB_LOCALE (1), (2), (3), (4), (5)
  • DBANSIWARN (1), (2), (3), (4)
  • DBBLOBBUF (1), (2)
  • DBCENTURY (1), (2), (3), (4)
  • DBDATE (1), (2), (3), (4)
  • DBDELIMITER (1), (2)
  • DBMONEY (1), (2)
  • DBPATH
  • DBSPACETEMP
  • DBTIME (1), (2)
  • DEBUG
  • DEFAULT_ATTACH (1), (2)
  • DELIMIDENT (1), (2), (3), (4), (5)
  • GL_DATE (1), (2), (3), (4)
  • GL_DATETIME (1), (2), (3)
  • IBM_XPS_PARAMS (1), (2), (3), (4), (5)
  • IFX_DEF_TABLE_LOCKMODE (1), (2), (3)
  • IFX_DIRECTIVES
  • IFX_DIRTY_WAIT (1), (2)
  • IFX_EXTDIRECTIVES
  • IFX_LONGID
  • IFX_MULTIPREPSTMT
  • IFX_TABLE_LOCKMODE
  • IFX_UPDDESC (1), (2)
  • IMPLICIT_PDQ
  • INFORMIXCONCSMCFG
  • INFORMIXSERVER (1), (2)
  • MAXERRORS
  • NODEFDAC (1), (2), (3)
  • OPT_GOAL
  • OPTCOMPIND (1), (2)
  • PDQPRIORITY (1), (2), (3), (4)
  • RECORDEND
  • setting with SYSTEM statement
  • STMT_CACHE
  • USETABLENAME (1), (2), (3), (4)
• equal() function
• equal() operator function
• Equal sign (=)
  • assignment operator
  • relational operator (1), (2)
• Error checking
  • continuing after error in SPL routine
  • error status with ON EXCEPTION
  • with SYSTEM
  • with WHENEVER
• ERROR keyword
  • in ALTER TABLE statement
  • in CREATE INDEX statement
  • in CREATE TABLE statement
  • in SET CONSTRAINTS statement
  • in SET Database Object Mode statement
  • in SET INDEXES statement
  • in WHENEVER statement
  • synonym for SQLERROR
• Error messages
• ESCAPE keyword
  • in Condition segment (1), (2)
  • in CREATE EXTERNAL TABLE statement
  • in SELECT statement
  • with LIKE keyword (1), (2)
  • with MATCHES keyword (1), (2)
• ESQL/C
  • collection cursor with FETCH
  • collection cursor with PUT
  • cursor example
  • deallocating collection-variable memory
  • deallocating row-variable memory
  • inserting collection variables with
  • inserting row variables (1), (2)
  • statements valid only in ESQL/C
• ESQL/C API
• Exception handler
• EXCEPTION keyword
  • in GET DIAGNOSTICS statement
  • in ON EXCEPTION statement
  • in RAISE EXCEPTION statement
• Excess-65 format
• Exclamation point (!)
  • in smart-large-object filename
• EXCLUSIVE keyword
  • in DATABASE statement
  • in LOCK TABLE statement
• Exclusive lock mode (1), (2), (3), (4)
• Executable file location
• Executable statements
• EXECUTE FUNCTION keywords
  • in DECLARE statement
  • in FOREACH statement
  • in INSERT statement
  • in Statement Block segment
• EXECUTE FUNCTION statement
  • and triggers
  • how it works
  • INTO clause
  • preparing
  • syntax
• EXECUTE IMMEDIATE statement
  • restricted statement types
  • syntax
• EXECUTE ON keywords
  • in GRANT statement
  • in REVOKE statement
• EXECUTE PROCEDURE keywords
  • in DECLARE statement
  • in FOREACH statement
  • in INSERT statement
  • in Statement Block segment
• EXECUTE PROCEDURE statement
  • in FOREACH
  • in triggered action
  • syntax
• EXECUTE statement
  • INTO clause
  • INTO SQL DESCRIPTOR clause
  • parameterizing a statement
  • returned SQLCODE values
  • syntax
  • USING DESCRIPTOR clause
  • with USING keyword
• EXISTS keyword
  • beginning a subquery
  • in Condition segment
  • in Condition subquery
• EXIT statement (1), (2)
• EXP function
• EXPLAIN keyword
  • optimizer directive
  • SET EXPLAIN statement
• EXPLICIT keyword
  • in CREATE CAST statement
• Exponential function
• Exponential number
• Export support function (1), (2)
• exportbinary support function
• Exportbinary support function
• EXPRESS keyword
  • in CREATE EXTERNAL TABLE statement
• Expression
  • Boolean (1), (2)
  • casting
  • constant
  • list of
  • ordering by
  • smart large objects in
• EXPRESSION keyword
  • in ALTER FRAGMENT statement (1), (2)
  • in CREATE INDEX statement
  • in CREATE TABLE statement
• Expression segment
  • aggregate expressions
  • cast expressions
  • column expressions
  • combined expressions
  • list of expressions
  • syntax
• EXT_DIRECTIVES configuration parameter
• EXTEND function (1), (2)
• EXTEND keyword
  • in GRANT statement
  • in REVOKE statement
• EXTEND role (1), (2), (3), (4), (5), (6), (7), (8), (9), (10)
• Extent
  • counting how many in a table
• EXTENT keyword
  • in ALTER TABLE statement
• EXTENT SIZE keywords
  • in ALTER TABLE statement
  • in CREATE TABLE statement (1), (2)
• Extents
  • revising the size (1), (2)
• External function
  • as operator-class support function
  • CREATE FUNCTION
  • dropping (1), (2)
  • executing (1), (2)
  • limits on return values
  • non-variant
  • OUT parameter
  • registering
  • strategy functions
  • variant
• EXTERNAL keyword
  • in CREATE EXTERNAL TABLE statement
  • in External Routine Reference segment
  • in SAVE EXTERNAL DIRECTIVES statement
  • in SELECT statement
• External language
• EXTERNAL NAME
  • in CREATE FUNCTION statement
  • in CREATE PROCEDURE statement
• EXTERNAL NAME keywords
  • in ALTER FUNCTION statement
  • in ALTER PROCEDURE statement
  • in ALTER ROUTINE statement
  • in CREATE FUNCTION statement
  • in CREATE PROCEDURE statement
• External optimizer directives
• External procedure
  • creating body of
  • dropping
  • executing
  • restrictions on optimizing
• External Routine Reference segment
• External routines
  • as triggered action
  • CREATE PROCEDURE FROM statement in
  • creating a function in
  • defined
  • dropping
  • EXTEND role
  • pathname syntax
  • preparing
  • referencing
• External synonym
• External tables
  • creating
  • integer data types
  • NULL values
  • restrictions in joins and subqueries
  • restrictions on calculating statistics
  • restrictions on optimizer directives
  • with SELECT statement
• EXTYPEID field
  • in GET DESCRIPTOR statement
  • in SET DESCRIPTOR statement
  • with DESCRIBE INPUT statement
  • with DESCRIBE statement
• EXTYPEID keyword.
  • See EXTYPEID field.
• EXTYPELENGTH field
  • in GET DESCRIPTOR statement
  • in SET DESCRIPTOR statement
  • with DESCRIBE INPUT statement
  • with DESCRIBE statement
• EXTYPELENGTH keyword.
  • See EXTYPELENGTH field.
• EXTYPENAME field
  • in GET DESCRIPTOR statement
  • in SET DESCRIPTOR statement
  • with DESCRIBE INPUT statement
  • with DESCRIBE statement
• EXTYPENAME keyword.
  • See EXTYPENAME field.
• EXTYPEOWNERLENGTH field
  • in GET DESCRIPTOR statement
  • in SET DESCRIPTOR statement
  • with DESCRIBE INPUT statement
  • with DESCRIBE statement
• EXTYPEOWNERLENGTH keyword.
  • See EXTYPEOWNERLENGTH field.
• EXTYPEOWNERNAME field
  • in GET DESCRIPTOR statement
  • in SET DESCRIPTOR statement
  • with DESCRIBE INPUT statement
  • with DESCRIBE statement
• EXTYPEOWNERNAME keyword.
  • See EXTYPEOWNERNAME field.

• FETCH statement
  • as affected by CLOSE
  • relation to GET DESCRIPTOR
  • with concatenation operator
• Field projection (1), (2)
• Field qualifier
  • for DATETIME
  • for INTERVAL (1), (2)
• FILE TO keywords
  • in SET DEBUG FILE statement
  • in SET EXPLAIN statement
  • in SET PLOAD FILE statement (1), (2)
• Files
  • sending output with the OUTPUT statement
• FILETOBLOB function (1), (2), (3)
• FILETOCLOB function (1), (2), (3), (4)
• FILLFACTOR configuration parameter
• FILLFACTOR keyword
  • in CREATE INDEX statement
• FILTERING keyword
  • in ALTER TABLE statement
  • in CREATE INDEX statement
  • in CREATE TABLE statement (1), (2)
  • in SET Database Object Mode statement
  • with diagnostics tables
• FINAL keyword
  • in CREATE AGGREGATE statement
• FIRST keyword
  • in FETCH statement
  • in SELECT statement (1), (2)
  • invalid in INSERT
• FIRST_ROWS keyword
  • in Optimizer Directives Segment
  • in SET OPTIMIZATION statement
• Fixed and Known Defects File
• Fixed format
  • files
• FIXED keyword
  • in CREATE EXTERNAL TABLE statement
• Fixed-length opaque data type
• Fixed-point numbers
• FLOAT data type
  • literal values
  • systems not supporting
• Floating-point numbers
• FLUSH statement
• Flushing an insert buffer
• FOR EACH ROW keyword, in CREATE TRIGGER statement
• FOR EACH ROW keywords, in CREATE TRIGGER statement
• FOR keyword
  • in CONTINUE statement
  • in CREATE OPCLASS statement
  • in CREATE SYNONYM statement
  • in CREATE TRIGGER statement (1), (2)
  • in DECLARE statement
  • in EXIT statement
  • in FOREACH statement
  • in INFO statement
  • in SAVE EXTERNAL DIRECTIVES statement
  • in SELECT statement (1), (2)
  • in SET AUTOFREE statement
  • in SET CONSTRAINTS statement
  • in SET Database Object Mode statement
  • in SET INDEXES statement
  • in SET TRIGGERS statement
  • in START VIOLATIONS TABLE statement
  • in STOP VIOLATIONS TABLE statement
  • in UPDATE STATISTICS statement (1), (2)
• FOR READ ONLY keywords, in DECLARE statement
• FOR statement
• FOR TABLE keywords, in UPDATE STATISTICS statement
• FOR UPDATE keywords
  • in DECLARE statement
  • in SELECT statement (1), (2)
  • relation to UPDATE
  • with column list
• FOREACH keyword
  • in CONTINUE statement
  • in EXIT statement
• FOREACH statement
  • syntax
• Foreign key
  • dropping
  • establishing (1), (2)
  • examples (1), (2)
  • multiple columns
• Foreign key constraint (1), (2)
• FOREIGN KEY keywords
  • in ALTER TABLE statement (1), (2)
  • in CREATE TABLE statement (1), (2)
• FORMAT keyword
  • in CREATE EXTERNAL TABLE statement
  • in SELECT statement (1), (2)
• FRACTION keyword
  • as INTERVAL field qualifier
  • in DATETIME field qualifier
  • in DATETIME Field Qualifier segment
  • in INTERVAL Field Qualifier
• FRAGMENT BY keywords
  • in ALTER FRAGMENT statement (1), (2)
  • in CREATE INDEX statement
  • in CREATE TABLE statement
• FRAGMENT keyword
  • in GRANT FRAGMENT statement
• Fragment-level privilege
  • granting
  • revoking
• Fragmentation
  • adding a fragment
  • adding rowids
  • altering fragments
  • arbitrary rule
  • built-in hash distribution scheme
  • by expression
  • combining tables
  • Dataskip feature
  • defining a new strategy
  • detaching a table fragment
  • dropping an existing fragment
  • dropping rowids
  • hybrid
  • insufficient log space or disk space
  • list of dbspaces
  • modifying an existing fragment expression
  • number of rows in fragment
  • of indexes
  • of tables
  • of temporary tables
  • reading data from local fragments
  • reinitializing strategy
  • remainder
  • reverting to nonfragmented
  • round-robin
  • rowid
  • rowid columns with
  • strategy
    • by expression (1), (2)
    • by round-robin (1), (2)
    • range rule
  • TEXT and BYTE data types
• Fragmentation strategy, modifying
• FRAGMENTS keyword, in INFO statement
• FREE statement
• FROM keyword
  • in CREATE INDEX statement
  • in DELETE statement
  • in LOAD statement
  • in PREPARE statement
  • in PUT statement
  • in REVOKE FRAGMENT statement
  • in REVOKE statement
  • in SELECT statement
  • in TRIM expressions
  • in UPDATE statement
• FROM ONLY.
  • See ONLY keyword.
• FULL keyword
  • in SELECT statement
  • Optimizer Directives Segment
• Full outer joins
• Function cursor
  • defined
  • opening
  • reopening
• Function expressions
• FUNCTION keyword
  • in ALTER PROCEDURE statement
  • in CREATE FUNCTION statement
  • in DROP FUNCTION statement
  • in GRANT statement
  • in REVOKE statement
  • in SELECT statement
  • in UPDATE STATISTICS statement
• Functional index (1), (2), (3), (4), (5)
• Functions
  • altering with ALTER FUNCTION
  • casting
  • collection manipulation
  • creating indirectly from a stored file
  • creating with CREATE FUNCTION
  • creating with CREATE FUNCTION FROM
  • cursor
  • dropping with DROP FUNCTION
  • dropping with DROP ROUTINE
  • modifying
    • path to executable file
  • modifying routine modifiers
  • noncursor
  • nonvariant
  • shared library
  • smart large object
  • specific name
  • system catalog tables
  • thread-safe
  • user-defined
    • defined
  • variant
• Functions, SQL
  • ABS
  • ACOS
  • ASIN
  • ATAN
  • ATAN2
  • AVG
  • CARDINALITY
  • CASE expression
  • CHAR_LENGTH
  • COS
  • COUNT
  • CURRVAL
  • DAY
  • DECODE
  • DECRYPT_BINARY
  • DECRYPT_CHAR
  • ENCRYPT_TDES
  • Encryption and decryption
  • EXNCRYPT_AES
  • EXP
  • Exponential
  • EXTEND
  • FILETOBLOB
  • FILETOCLOB
  • GETHINT
  • HEX
  • IFX_REPLACE_MODULE
  • INITCAP
  • LENGTH
  • LOCOPY
  • LOG10 (1), (2)
  • Logarithmic
  • LOGN
  • LOTOFILE
  • LOWER
  • LPAD
  • MAX
  • MDY
  • MIN
  • MOD
  • MONTH
  • NEXTVAL
  • NVL
  • OCTET_LENGTH
  • POW
  • RANGE
  • ROOT
  • ROUND
  • RPAD
  • SIN
  • SQRT
  • STDEV
  • SUBSTR
  • SUM
  • TAN
  • Time
  • TO_CHAR
  • TRIM
  • TRIM function
  • TRUNC
  • UPPER
  • VARIANCE
  • WEEKDAY
• Fuzzy index

• Generalized-key index
  • affected by dropping a column
  • affected by modifying a column
  • defined
  • no renamed table
  • no table expressions
  • SELECT clause
  • WHERE clause
• Generic B-tree index
• GET DESCRIPTOR statement
  • syntax
  • use with FETCH statement
• GET DIAGNOSTICS statement
  • SQLSTATE codes
  • syntax
• GET keyword
  • in GET DESCRIPTOR statement
  • in GET DIAGNOSTICS statement
• GETHINT function
• GK
  • See Generalized-key index
• GK index (1), (2)
  • See also Generalized-key index.
• GK INDEX keywords, in CREATE INDEX statement
• GL_DATE environment variable (1), (2), (3), (4)
• GL_DATETIME environment variable (1), (2), (3)
• Global environment
• GLOBAL keyword, in DEFINE statement
• Global Language Support (GLS)
• Global variables
• GLS.
  • See Global Language Support.
• GO TO keywords, in WHENEVER statement
• GOTO keyword, in WHENEVER statement
• GRANT FRAGMENT statement
• GRANT keyword
  • in GRANT FRAGMENT statement
  • in GRANT statement
• GRANT statement
• greaterthan() operator function
• greaterthanorequal() operator function
• GROUP BY keywords, in SELECT statement

• Handle value (1), (2)
• HANDLESNULLS keyword
  • in CREATE AGGREGATE statement
  • in Routine Modifier segment (1), (2)
• Hash join (1), (2), (3)
• HASH keyword
  • in ALTER FRAGMENT statement
  • in CREATE INDEX statement
  • in CREATE TABLE statement
• HAVING keyword
  • in SELECT statement
• HEADINGS keyword, in OUTPUT statement
• Help
• HEX function (1), (2), (3)
• HEX keyword
  • in CREATE EXTERNAL TABLE statement
• Hexadecimal digits
• Hexadecimal dump format
• Hexadecimal smart-large-object identifier (1), (2)
• HIGH INTEG keywords
  • in ALTER TABLE statement
  • in CREATE TABLE statement
• HIGH keyword
  • in SET OPTIMIZATION statement
  • in SET PDQPRIORITY statement
  • in UPDATE STATISTICS statement
• High-Performance Loader (1), (2)
• HINT keyword
  • in SET ENCRYPTION PASSWORD statement
• Hold cursor
  • defined
  • insert cursor with hold
  • update cursor with hold
• HOLD keyword
  • in DECLARE statement
  • in FOREACH statement
• hosts.equiv file
• HOUR keyword
  • as DATETIME field qualifier
  • as INTERVAL field qualifier
  • in DATETIME Field Qualifier segment
  • in INTERVAL field qualifier
• HYBRID keyword
  • in ALTER FRAGMENT statement
  • in CREATE INDEX statement
  • in CREATE TABLE statement (1), (2)
• Hyphen symbol (-)
  • DATETIME separator
  • INTERVAL separator

• IBM
  • format binary
    • in external tables
• IBM_XPS_PARAMS environment variable
• IDATA field
  • in GET DESCRIPTOR statement
  • in SET DESCRIPTOR statement
  • with X/Open programs
• IDATA keyword
  • See IDATA field.
• Identifier
  • column names
  • cursor name (1), (2)
  • defined
  • delimited identifiers
  • multibyte characters
  • non-ASCII characters
  • routines
  • storage objects
  • syntax
  • table names (1), (2), (3), (4)
  • uppercase characters
  • using keywords
  • using keywords as column names
  • variable name
• IF statement
• IFX_ALLOW_NEWLINE function
  • effect on quoted strings
  • syntax
• IFX_DEF_TABLE_LOCKMODE environment variable (1), (2)
• IFX_DIRECTIVES environment variable
• IFX_DIRTY_WAIT environment variable (1), (2)
• IFX_EXTDIRECTIVES environment variable
• IFX_EXTEND_ROLE configuration parameter (1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12)
• IFX_LO_SPEC data type
• IFX_LO_STAT data type
• IFX_LONGID environment variable
• IFX_MULTIPREPSTMT environment variable
• IFX_REPLACE_MODULE function (1), (2)
• IFX_TABLE_LOCKMODE environment variable
• IFX_UPDDESC environment variable (1), (2)
• ILENGTH field
  • in GET DESCRIPTOR statement
  • in SET DESCRIPTOR statement
  • with X/Open programs
• ILENGTH keyword
  • See ILENGTH field.
• Ill-behaved C UDR
• Imaginary numbers
• IMMEDIATE keyword
  • in SET Transaction Mode statement
• IMMUTABLE keyword
  • in SET ALL_MUTABLES statement
  • in SET DEFAULT TABLE_SPACE statement
  • in SET DEFAULT TABLE_TYPE statement
  • in SET PDQPRIORITY statement
• IMPEX data type
• IMPEXBIN data type
• Implicit cursor
• Implicit inner join
• IMPLICIT keyword
  • in CREATE CAST statement
• IMPLICIT_PDQ environment variable
• IMPLICIT_PDQ keyword
  • in SET ENVIRONMENT statement
• Implicit transactions
• Import support function (1), (2)
• Importbinary support function (1), (2)
• IN keyword
  • as a condition
  • in ALTER FRAGMENT statement
  • in ALTER TABLE statement
  • in Condition segment (1), (2)
  • in CREATE DATABASE statement
  • in CREATE DUPLICATE statement
  • in CREATE INDEX statement
  • in CREATE PROCEDURE statement
  • in CREATE TABLE statement (1), (2), (3), (4), (5)
  • in CREATE Temporary TABLE statement
  • in Data Type segment
  • in FOR statement
  • in LOCK TABLE statement
  • in ON EXCEPTION statement
  • in SELECT statement
• INACTIVE keyword, in SAVE EXTERNAL DIRECTIVES statement
• INCREMENT keyword
  • in ALTER SEQUENCE statement
  • in CREATE SEQUENCE statement
• Index
  • access method
  • altering table fragmentation
  • attached (1), (2)
  • B-tree (1), (2)
  • bidirectional traversal
  • cleaner list.
    • See B-tree cleaner list.
  • clustered fragments
  • compacted
  • composite
  • converting during upgrade (1), (2)
  • creating
  • delete flag
  • detached (1), (2), (3)
  • disabled (1), (2)
  • displaying information for
  • Dropping with DROP INDEX
  • filtering to violations table
  • fragmented (1), (2), (3)
  • functional (1), (2), (3)
  • fuzzy
  • generalized-key
  • internal
  • maximum key size (1), (2)
  • memory resident
  • multilingual index
  • nonfragmented
  • on ORDER BY columns
  • on temporary tables
  • online
  • privilege
  • provide for expansion
  • R-Tree (1), (2)
  • renaming
  • residency status (1), (2)
  • ROOT argument
  • shared (1), (2), (3)
  • side-effect
  • system-generated (1), (2), (3)
  • system-generated names
  • unique
    • restrictions
  • unique keys
    • specifying support for
  • virtual (1), (2)
• INDEX_ALL optimizer directive
• INDEX keyword
  • in ALTER FRAGMENT statement
  • in ALTER INDEX statement
  • in CREATE INDEX statement
  • in DROP INDEX statement
  • in GRANT statement
  • in Optimizer Directives Segment
  • in REVOKE statement
  • in SET INDEX statement
  • in SET Residency statement
• Index Name.
  • See Database Object Name.
• Index privilege (1), (2)
• INDEXES keyword
  • in INFO statement
  • in SET Database Object Mode statement
  • in SET INDEXES statement
• INDEXKEYARRAY data type
• INDICATOR field
  • in GET DESCRIPTOR statement
  • in SET DESCRIPTOR statement
• INDICATOR keyword
  • See also INDICATOR field.
  • in EXECUTE FUNCTION statement
  • in EXECUTE statement (1), (2)
  • in FETCH statement
  • in PUT statement
  • in SELECT statement
• Indicator variable
  • in expression
• INDICATOR variable
  • See INDICATOR keyword.
• Indirect typing
• Industry standards, compliance with
• INFO statement, syntax
• Informix 4GL
• Informix Dynamic Server documentation set
• INFORMIX.JVPCONTROL function
• INFORMIX keyword
  • in CREATE EXTERNAL TABLE statement
  • in External Routine Reference segment
  • in SELECT statement
• informix user name (1), (2), (3)
• INFORMIXCONCSMCFG environment variable
• INFORMIXDIR/bin directory
• INFORMIXSERVER environment variable (1), (2), (3)
• Inheritance hierarchy
  • dropping tables
  • named ROW types (1), (2)
• INIT keyword
  • in ALTER FRAGMENT statement
  • in CREATE AGGREGATE statement
• INITCAP function
• Initial-cap characters, converting to
• Inner joins
• INNER keyword
  • in SELECT statement
• INOUT parameters (1), (2)
• Input support function
• Insert buffer
  • counting inserted rows (1), (2)
  • filling with constant values
  • inserting rows
    • with a cursor
  • storing rows with PUT
  • triggering flushing
• Insert cursor
  • benefits
  • closing
  • declaring
  • in INSERT
  • in PUT
  • opening
  • reopening
  • result of CLOSE in SQLCA
  • with hold
• INSERT INTO keywords
  • in INSERT
  • in LOAD
• INSERT keyword
  • in CREATE TRIGGER statement (1), (2)
  • in DECLARE statement
  • in GRANT FRAGMENT statement
  • in GRANT statement
  • in LOAD statement
  • in MERGE statement
  • in REVOKE FRAGMENT statement
  • in REVOKE statement (1), (2)
• Insert privilege (1), (2)
• INSERT statements
  • and triggers
  • AT clause
  • collection-column values
  • collection-derived table, with
  • distributed
  • effect of transactions
  • ESQL/C (1), (2), (3)
  • filling insert buffer with PUT
  • flex inserts
  • in dynamic SQL
  • insert cursor compared with
  • insert triggers
  • inserting
    • rows through a view
    • rows with a cursor
  • into collection cursor
  • nulls
  • OUT parameter and
  • row type field values
  • row variables
  • SERIAL and SERIAL8 columns
  • smart large objects with
  • specifying values to insert
  • syntax
  • using functions
  • VALUES clause, expressions with
  • with DECLARE statement
  • with insert cursor
  • with SELECT statement
• Insert trigger (1), (2)
• install_jar() procedure (1), (2)
• Installation Guides
• INSTEAD OF keywords, in CREATE TRIGGER statement
• INSTEAD OF trigger
• INT8 data type
• INTEG keyword
  • in ALTER TABLE statement
  • in CREATE TABLE statement
• INTEGER data type
  • in external tables
  • literal values
• INTERNAL keyword, in Routine Modifier segment (1), (2)
• INTERNALLENGTH keyword, in CREATE OPAQUE TYPE statement
• INTERVAL data type
  • as quoted string
  • field qualifier
  • in expression
  • in INSERT
  • literal
  • loading
  • precision
  • syntax (1), (2)
• INTERVAL keyword, in Literal INTERVAL
• INTO DESCRIPTOR keywords, in EXECUTE
• INTO EXTERNAL keywords
  • in SELECT statement
• INTO keyword
  • in DESCRIBE INPUT statement
  • in DESCRIBE statement
  • in EXECUTE FUNCTION statement
  • in EXECUTE PROCEDURE statement
  • in EXECUTE statement
  • in FETCH statement
  • in FOREACH statement
  • in INSERT statement
  • in LOAD statement
  • in MERGE statement
  • in SELECT statement
• INTO SCRATCH keywords, in SELECT statement
• INTO SQL DESCRIPTOR keywords, in EXECUTE statement
• INTO TEMP clause
  • in SELECT statement
  • invalid in INSERT
  • with UNION operator
• IS keyword
  • in Condition segment
  • in WHERE clause
• IS NOT NULL keywords, in Condition segment
• IS NULL keywords, in Condition segment
• ISAM error code (1), (2), (3)
• ISO 8859-1 code set
• ISOLATION keyword
  • in SET ISOLATION statement
  • in SET TRANSACTION statement
• Isolation level
  • defined (1), (2)
  • with FETCH statement
• Item descriptor
• ITEM keyword
  • in Collection Subquery segment
• ITER keyword
  • in CREATE AGGREGATE
• Iterator functions (1), (2), (3)
• ITERATOR keyword, in Routine Modifier segment (1), (2)
• ITYPE field
  • in GET DESCRIPTOR statement
  • in SET DESCRIPTOR statement
  • with X/Open programs
• ITYPE keyword.
  • See ITYPE field.

• Jagged rows
• JAR files, renaming
• JAVA keyword, in External Routine Reference segment
• Java UDRs (1), (2), (3)
  • CLASS routine modifier
  • creating functions
  • creating procedures
  • Getting JVP memory information
  • Getting JVP thread information
  • installing a Jar file
  • Java signature
  • jvpcontrol function
  • removing a Jar file
  • replacing a Jar file
  • shared-object file
  • sqlj.alter_java_path procedure
  • sqlj.replace_jar procedure
  • sqlj.setUDTExtName procedure
  • sqlj.unsetUDTExtName procedure
  • static method
  • unmapping a user-defined type
• Java virtual processor class
  • CLASS modifier
• Java Virtual Processor Class
  • getting memory information
  • getting thread information
• Java Virtual-Table Interface
• JDBC API
• JDBC connection
• JDBC Driver built-in function
• Join
  • condition
  • hash join (1), (2)
  • in Condition segment
  • in DELETE statement
  • in UPDATE statement
  • multiple-table join (1), (2)
  • nested-loop join (1), (2)
  • outer
  • outer, Informix extension syntax
  • self-join
  • sort-merge join
  • transitively joined on key
• Join column.
  • See Foreign key.
• Join filter
• JOIN keyword
  • in SELECT statement
• Join-method directive
• Join on key query
• Join-order directive
• JVP.
  • See Java Virtual Processor Class.
• JVPCLASSPATH configuration parameter
• jvpcontrol function

• KEEP ACCESS TIME keyword
  • in ALTER TABLE statement
• KEEP ACCESS TIME keywords
  • in CREATE TABLE statement
• KEEP keyword
  • in ALTER TABLE statement
• keep option of esqlc
• KEY keyword
  • CREATE TABLE statement
  • in CREATE TABLE statement
  • in CREATE Temporary Table statement
• Key management for encrypted data
• Key-only index scan
• Keywords
  • as identifiers
  • in syntax diagrams
  • list for IDS
  • list for XPS

• Language
  • privileges on
• Language, privileges on
• LANGUAGE keyword
  • in External Routine Reference segment
  • in GRANT statement
  • in REVOKE statement
• Large objects
  • constraints (1), (2)
  • declaration syntax
  • pointer structure
• LAST keyword, in FETCH statement
• LEADING keyword, in TRIM expressions
• LEFT keyword
  • in SELECT statement
• Left outer joins
• LENGTH field
  • in GET DESCRIPTOR statement
  • in SET DESCRIPTOR statement
  • with DATETIME and INTERVAL types
  • with DECIMAL and MONEY types
  • with DESCRIBE INPUT statement
  • with DESCRIBE statement
• Length function
• LENGTH function (1), (2), (3)
• LENGTH keyword.
  • See LENGTH field.
• lessthan() operator function
• lessthanorequal() operator function
• LET statement
• Lettercase conversion
• Level-0 backup (1), (2)
• LEVEL keyword
  • in SET SCHEDULE LEVEL statement
  • in SET TRANSACTION statement
• Library
  • shared
• Light append (1), (2)
• Light appends (1), (2)
• Light scan (1), (2), (3)
• like() operator function
• LIKE keyword
  • in Condition segment (1), (2)
  • in DEFINE statement
  • in Routine Parameter List segment
  • in SELECT statement
  • wildcard characters
• LIST.
  • See Collections.
• LIST data type
  • columns, generating values for
  • defined
  • deleting elements from
  • unloading
  • updating elements
• LIST keyword
  • in DEFINE statement
  • in Expression segment
  • in Literal Collection
• LISTING keyword
  • in CREATE FUNCTION statement
  • in CREATE PROCEDURE statement
• Literal
  • BOOLEAN
  • DATE
  • DATETIME
    • in ALTER TABLE statement
    • in INSERT statement
    • with IN keyword
  • INTERVAL
    • in expression
    • in INSERT statement
  • nested row
  • number
    • as constant expression
  • Number
    • in INSERT
    • with IN keyword
• Literal collection
  • nested
  • syntax
• Literal number, exponential notation
• Literal Row segment
• Literal values, specifying as default values
• Little-endian format
• LOAD statement
• local command-line option (1), (2)
• LOCAL keyword
  • in SELECT statement
• Local variable
• Locales
  • default
  • en_us.8859-1
• Localized collation
• Localized collation order (1), (2), (3)
• LOCK keyword
  • in ALTER INDEX statement
  • in ALTER TABLE statement
  • in CREATE Temporary TABLE statement
  • in SET LOCK MODE statement
• LOCK MODE keyword
  • in ALTER TABLE statement
• LOCK MODE keywords
  • in ALTER INDEX statement
  • in CREATE INDEX statement
  • in CREATE TABLE statement
• Lock table overflow
• LOCK TABLE statement
  • syntax
  • use in transactions
• Locking
  • blobspaces
  • during
    • inserts
    • updates (1), (2)
  • exclusive lock
  • exclusive locks
  • in transactions
  • overriding row-level
  • promotable lock
  • releasing with COMMIT WORK statement (1), (2)
  • releasing with ROLLBACK WORK statement
  • shared locks
  • types of locks (1), (2)
  • update cursors effect on
  • update locks (1), (2)
  • waiting period
  • when creating a referential constraint (1), (2)
  • with
    • SET ISOLATION statement
    • SET LOCK MODE statement
    • UNLOCK TABLE statement
  • with FETCH statement
  • with SET TRANSACTION statement
  • write lock
• Locking granularity (1), (2)
• LOCKS configuration parameter (1), (2)
• LOCKS keyword, in SET ISOLATION statement
• LOCOPY function (1), (2)
• Log files, for load and unload jobs
• LOG keyword
  • ALTER TABLE statement
  • in CREATE DATABASE statement
  • in CREATE TABLE statement
  • in CREATE Temporary TABLE statement
  • in SET LOG statement
• LOG10 function
• Logarithmic functions
  • LOG10 function
  • LOGN function
• Logging
  • buffered versus unbuffered
  • cascading deletes
  • changing mode with SET LOG
  • in CREATE DATABASE statement
  • log space requirements
  • table type options
  • temporary tables
  • with triggers
• Logical operator, in Condition segment
• LOGN function
• Lohandles support function
• LOLIST data type
• Long transaction rollback
• Loop
  • controlled
  • indefinite with WHILE
• LOTOFILE function (1), (2), (3)
• LOW keyword
  • in SET OPTIMIZATION statement
  • in SET PDQPRIORITY statement
  • in UPDATE STATISTICS statement
• LOWER function
• Lowercase characters, converting to
• LPAD function (1), (2)
• LVARCHAR data type (1), (2), (3)
  • syntax

• Machine notes
• Mail, sending from SPL routines
• Mantissa
• MATCHED keyword
  • in MERGE statement
• matches() operator function
• MATCHES keyword
  • in Condition segment (1), (2)
  • in SELECT statement
  • wildcard characters
• Materialized table expression
• Materialized view
• MAX function (1), (2)
• MAX keyword
  • in ALLOCATE DESCRIPTOR statement
  • in CREATE TABLE statement
  • in START VIOLATIONS TABLE statement
• MAX_PDQPRIORITY configuration parameter
• MAX ROWS keywords, in START VIOLATIONS TABLE statement
• MAX VIOLATIONS keywords, in START VIOLATIONS TABLE statement
• MAXERRORS environment variable
• MAXERRORS keyword
  • in CREATE EXTERNAL TABLE statement
• MAXLEN keyword, in CREATE OPAQUE TYPE statement
• MAXSCAN keyword
  • in SET ENVIRONMENT statement
• MAXVALUE keyword
  • in ALTER SEQUENCE statement
  • in CREATE SEQUENCE statement
• MDY function (1), (2)
• MEDIUM keyword, in UPDATE STATISTICS statement
• Membership operator
• Memory
  • allocating for collection variable
  • allocating for query
  • allocating for ROW variable
  • deallocating cursors
  • deallocating for collection variable
  • deallocating for cursors
  • deallocating for row variable
  • deallocating prepared objects (1), (2)
• MEMORY keyword, in EXECUTE FUNCTION statement
• Memory-resident indexes, setting
  • See SET Residency statement.
• MEMORY_RESIDENT keyword
  • in SET INDEX statement
  • in SET Residency statement (1), (2)
  • in SET TABLE statement
• Memory-resident tables, setting.
  • See SET Residency statement.
• MERGE statement
• MESSAGE_LENGTH keyword, in GET DIAGNOSTICS statement
• MESSAGE_TEXT keyword, in GET DIAGNOSTICS statement
• mi_collection* functions
• MIN function (1), (2)
• MIN keyword, in CREATE TABLE statement
• Minus (-) sign
  • arithmetic operator
• minus() operator function
• Minus operator (-)
  • unary (1), (2)
• Minus sign (-)
  • INTERVAL literals
  • unary operator
• MINUTE keyword
  • in DATETIME Field Qualifier segment
  • in INTERVAL Field Qualifier (1), (2)
• MINVALUE keyword
  • in ALTER SEQUENCE statement
  • in CREATE SEQUENCE statement
• Missing arguments
• Mixed-case characters, converting to
• MOD function (1), (2)
• MODE keyword
  • in ALTER INDEX statement
  • in ALTER TABLE statement
  • in CREATE DATABASE statement
  • in CREATE INDEX statement
  • in CREATE TABLE statement
  • in CREATE Temporary TABLE statement
  • in LOCK TABLE statement
  • in SET LOCK MODE statement
• MODIFY EXTERNAL NAME keywords
  • in ALTER FUNCTION statement
  • in ALTER PROCEDURE statement (1), (2)
  • in ALTER ROUTINE statement
• MODIFY keyword
  • in ALTER ACCESS_METHOD statement
  • in ALTER FRAGMENT statement
  • in ALTER FUNCTION statement
  • in ALTER PROCEDURE statement
  • in ALTER ROUTINE statement
  • in ALTER TABLE statement
• MODIFY NEXT SIZE keyword
  • in ALTER TABLE statement
• Modifying routine modifiers
  • with ALTER FUNCTION statement
  • with ALTER PROCEDURE statement
  • with ALTER ROUTINE statement
• Modulus
• MONEY data type
  • literal values
  • loading
  • syntax
• MONTH function (1), (2)
• MONTH keyword
  • in DATETIME Field Qualifier segment
  • in INTERVAL Field Qualifier (1), (2), (3)
• MORE keyword, in GET DIAGNOSTICS statement
• MOVE TABLE statement
• MQ DataBlade module
• Multi-index scan
• Multibyte characters
• Multibyte locales
• Multilingual index
• Multiple-column constraints
  • in ALTER TABLE statement
  • in CREATE TABLE statement
• Multiple triggers
  • example
  • preventing overriding
• Multiplication sign (*), arithmetic operator
• Multirepresentational data (1), (2), (3)
• Multirow query
• MULTISET
  • See Collections.
• MULTISET, creating from subquery results
• MULTISET columns, generating values for
• MULTISET data type
  • collection subqueries
  • defined
  • deleting elements from
  • unloading
  • updating elements
• MULTISET keyword
  • in Collection-Subquery segment
  • in DEFINE statement
  • in Expression segment
  • in Literal Collection
• Mutability
  • property
  • setting for all variables
• MUTABLE keyword
  • in SET ALL_MUTABLES statement
  • in SET DEFAULT TABLE_SPACE statement
  • in SET DEFAULT TABLE_TYPE statement
  • in SET ENVIRONMENT statement
  • in SET PDQPRIORITY statement

• NAME field
  • in GET DESCRIPTOR statement
  • in SET DESCRIPTOR statement
  • with DESCRIBE INPUT statement
  • with DESCRIBE statement
• NAME keyword
  • See also NAME field.
  • External Routine Reference segment
  • in ALTER FUNCTION statement
  • in ALTER PROCEDURE statement
  • in ALTER ROUTINE statement
• Named row type
  • assigning with ALTER TABLE
  • associating with a column
  • creating with CREATE ROW TYPE
  • dropping with DROP ROW TYPE
  • inheritance
  • privileges on (1), (2)
  • Under privilege
  • unloading (1), (2)
  • updating fields
• Naming convention
  • database
  • database objects (1), (2)
• Natural logarithms
• NCHAR data type syntax
• negate() operator function
• Negator functions (1), (2), (3), (4)
• NEGATOR keyword
  • Routine Modifier segment (1), (2)
• Nested loop join (1), (2), (3), (4)
• NESTED optimizer directive
• Nested ordering
  • in SELECT statement
• NET API
• New features (1), (2)
• NEW keyword, in CREATE TRIGGER statement (1), (2), (3), (4)
• Newline characters in quoted strings
• NEXT keyword
  • in ALTER TABLE statement
  • in CREATE TABLE statement
  • in FETCH statement
• NEXT SIZE keywords
  • in ALTER TABLE statement
  • in CREATE TABLE statement
• NEXTVAL operator (1), (2)
• NO KEEP ACCESS TIME keywords
  • in ALTER TABLE statement
  • in CREATE TABLE statement
• NO keyword
  • in SET COLLATION statement
• NO LOG keywords
  • in ALTER TABLE statement
  • in CREATE TABLE statement
  • in SELECT statement
• NOCACHE keyword
  • in ALTER SEQUENCE statement
  • in CREATE SEQUENCE statement
• NOCTCLE keyword
  • in CREATE SEQUENCE statement
• NOCYCLE keyword
  • in ALTER SEQUENCE statement
• NODEFDAC environment variable (1), (2), (3), (4)
  • effects on new routine (1), (2)
  • effects on new table
  • GRANT statement with
• NOMAXVALUE keyword
  • in ALTER SEQUENCE statement
  • in CREATE SEQUENCE statement
• NOMINVALUE keyword
  • in ALTER SEQUENCE statement
  • in CREATE SEQUENCE statement
• NON_RESIDENT keyword
  • in SET INDEX statement
  • in SET Residency statement (1), (2)
  • in SET TABLE statement
• Noncursor function
• Nondefault code sets
• NONE keyword, in SET ROLE statement
• NONE role (1), (2)
• Nonlogging temporary tables
  • creating
  • duration
• Nonvariant functions
• NOORDER keyword
  • in ALTER SEQUENCE statement
  • in CREATE SEQUENCE statement
• NORMAL keyword
  • in ALTER INDEX statement (1), (2)
  • in CREATE INDEX statement
• NOT FOUND keywords, in WHENEVER statement
• NOT keyword
  • in ALTER INDEX statement
  • in Condition segment (1), (2), (3), (4), (5)
  • in MERGE statement
  • in SELECT statement (1), (2)
  • in SET LOCK MODE statement
  • Routine Modifier segment
  • with BETWEEN keyword
  • with IN keyword
• NOT NULL keywords
  • in ALTER TABLE statement
  • in collection data type declarations
  • in CREATE EXTERNAL TABLE statement
  • in CREATE ROW TYPE statement
  • in CREATE TABLE statement
  • in CREATE Temporary TABLE statement
  • in DEFINE statement
  • in SELECT statement
• NOT VARIANT keywords, in External Routine Reference segment
• NOT WAIT keywords in SET LOCK MODE
• notequal() operator function
• NULL keyword
  • ambiguous as a routine variable
  • Argument segment
  • in ALTER TABLE statement
  • in Condition segment
  • in CREATE EXTERNAL TABLE statement
  • in CREATE ROW TYPE statement
  • in CREATE TABLE statement
  • in CREATE Temporary TABLE statement
  • in DEFINE statement
  • in Expression segment (1), (2), (3)
  • in INSERT statement
  • in SELECT statement
  • in SET ROLE statement
  • in UPDATE statement (1), (2)
• Null values
  • checking for in SELECT statement (1), (2)
  • in IF statement
  • inserting with the VALUES clause
  • invalid for collection types
  • loading
  • returned implicitly by SPL function
  • updating a column
  • used in Condition with NOT operator
  • used in the ORDER BY clause
  • WHILE statement
  • with AND and OR keywords
  • with NVL function
• NULLABLE field
  • in GET DESCRIPTOR statement
  • in SET DESCRIPTOR statement
  • with DESCRIBE INPUT statement
  • with DESCRIBE statement
• NULLABLE keyword
  • See NULLABLE field.
• NUMBER keyword, in GET DIAGNOSTICS statement
• Numeric data types
• NVARCHAR data type
  • syntax
• NVL function

• Object-List format, in SET Database Object Mode statement
• Object mode.
  • See Database object mode.
• Octal numbers (1), (2)
• OCTET_LENGTH function (1), (2)
• ODBC API
• OF keyword
  • in CREATE DUPLICATE statement
  • in CREATE TRIGGER statement (1), (2), (3), (4)
  • in CREATE VIEW statement
  • in DECLARE statement
  • in DELETE statement
  • in DROP DUPLICATE statement
  • in SELECT statement
  • in UPDATE statement
• OF TYPE keywords
  • in CREATE TABLE statement
  • in CREATE VIEW statement
• OFF keyword
  • in SET DATASKIP statement
  • in SET ENVIRONMENT statement
  • in SET EXPLAIN statement
  • in SET PDQPRIORITY statement
  • in SET STATEMENT CACHE statement
  • in TRACE statement
• OLD keyword, in CREATE TRIGGER statement (1), (2), (3)
• OLEDB API
• OLTP
  • See Online transaction processing.
• OLTP (on-line transaction processing)
• ON DELETE CASCADE keywords
  • in ALTER TABLE statement
  • in CREATE TABLE statement
  • restrictions with triggers
• ON EXCEPTION statement
• ON EXECPTION keyword
  • Statement Block segment
• ON keyword
  • in ALTER FRAGMENT statement
  • in CREATE INDEX statement
  • in CREATE TABLE statement
  • in CREATE TRIGGER statement (1), (2), (3), (4), (5)
  • in GRANT FRAGMENT statement
  • in GRANT statement (1), (2), (3)
  • in MERGE statement
  • in REVOKE FRAGMENT statement
  • in REVOKE statement (1), (2), (3), (4), (5)
  • in SET DATASKIP statement
  • in SET ENVIRONMENT statement
  • in SET EXPLAIN statement
  • in SET STATEMENT CACHE statement
  • in TRACE statement
• oncheck utility (1), (2)
• ONCONFIG paramaters
  • DIRECTIVES
• ONCONFIG parameter
  • SYSSBSPACENAME
• ONCONFIG parameters
  • DATASKIP
  • DBSERVERALIAS (1), (2), (3), (4)
  • DBSERVERNAME (1), (2), (3), (4)
  • DEADLOCK_TIMEOUT
  • DEF_TABLE_LOCKMODE (1), (2), (3)
  • DS_ADM_POLICY
  • DS_NONPDQ_QUERY_MEM
  • DS_TOTAL_TMPSPACE
  • EXT_DIRECTIVES
  • FILLFACTOR configuration parameter
  • IFX_EXTEND_ROLE (1), (2)
  • LOCKS
  • MAX_PDQPRIORITY
  • OPTCOMPIND
  • STACKSIZE
  • STMT_CACHE
  • STMT_CACHE_HITS
  • STMT_CACHE_NOLIMIT
  • STMT_CACHE_NUMPOOL
  • STMT_CACHE_SIZE
  • USEOSTIME
• ondblog utility
• oninit utility
• Online help
• ONLINE keyword
  • in CREATE INDEX statement
  • in DROP INDEX statement
• Online manuals
• Online notes (1), (2)
• Online transaction processing
• ONLY keyword
  • in DECLARE statement
  • in DELETE statement (1), (2)
  • in SAVE EXTERNAL DIRECTIVES statement
  • in SELECT statement (1), (2)
  • in SET TRANSACTION statement
  • in TRUNCATE (XPS) statement
  • in UPDATE statement (1), (2)
  • in UPDATE STATISTICS statement (1), (2)
• onmode utility
• onspaces utility (1), (2), (3), (4)
• onstat utility (1), (2)
• onutil check utility
• onutil utility (1), (2)
• Opaque data types
  • alignment of
  • as argument
  • associating with a column
  • creating
  • DESCRIBE with
  • dropping
  • extended identifier (1), (2)
  • GET DESCRIPTOR with
  • in DELETE
  • in DROP TABLE
  • in dynamic SQL
  • in INSERT
  • in LOAD
  • in UPDATE
  • loading (1), (2)
  • modifiers
  • name of (1), (2)
  • naming
  • owner name (1), (2)
  • support functions
  • unloading
  • with SET DESCRIPTOR
• Open-Fetch-Close Optimization
• OPEN statement
• OPERATIONAL keyword
  • in ALTER TABLE statement
  • in CREATE TABLE
  • in CREATE TABLE statement
  • in SELECT statement
  • in SET Default Table Type statement
• Operator class
  • btree_ops
  • creating
  • default (1), (2)
  • default for B-Tree
  • defined (1), (2)
  • dropping with DROP OPCLASS
  • rtree_ops
  • specifying with CREATE INDEX (1), (2)
• Operator function
  • divide()
  • equal()
  • greaterthan()
  • greaterthanorequal()
  • lessthan()
  • lessthanorequal()
  • like()
  • matches()
  • minus()
  • negate()
  • notequal()
  • plus()
  • positive()
  • times()
• OPT_GOAL configuration parameter
• OPT_GOAL environment variable
• OPTCOMPIND configuration parameter
• OPTCOMPIND environment variable (1), (2)
• OPTCOMPIND keyword, in SET ENVIRONMENT statement
• Optical Subsystem
  • list of statements
• Optimization
  • specifying a high or low level
• OPTIMIZATION keyword
  • in SET OPTIMIZATION statement
• Optimizer
  • and SAVE EXTERNAL DIRECTIVES statement
  • and SET OPTIMIZATION statement (1), (2)
  • Optimizer Directives segment
  • strategy functions
  • with UPDATE STATISTICS
• Optimizer directives
  • AVOID_FULL
  • AVOID_INDEX
  • comment symbols
  • external
  • FULL
  • INDEX
  • INDEX_ALL
  • inline
  • join-order
  • NESTED
  • not followed
  • ORDERED
  • restrictions (1), (2)
  • segment
• Optimizing
  • a database server
  • a query (1), (2)
  • across a network
• OPTION keyword
  • in CREATE TRIGGER statement
  • in CREATE VIEW statement
  • in GRANT FRAGMENT statement
  • in GRANT statement
• OR keyword
  • defined
  • in Condition segment
• ORDER BY clause
  • no table expressions
• ORDER BY keywords
  • in SELECT statement
  • restricted in INSERT
• ORDER keyword
  • in ALTER SEQUENCE statement
  • in CREATE SEQUENCE statement
• ORDERED keyword, in Optimizer Directives segment
• OUT keyword
  • Routine Parameter List segment
• OUT parameter (1), (2)
  • user-defined function
  • with a statement-local variable (1), (2), (3)
• Outer join.
  • See Join, outer.
• OUTPUT statement
• Output support function
• Overflow bin
• Overloaded routine (1), (2)
• Owner
  • ANSI-compliant database
  • case-sensitivity (1), (2), (3), (4), (5)
  • Database Object Name segment (1), (2)
  • in ANSI-compliant database (1), (2), (3), (4)
  • in CREATE SYNONYM
  • in DROP SEQUENCE
  • in RENAME TABLE statement
  • in system catalog table
  • Owner Name segment
• Owner Name segment
• Owner-privileged UDR

• Packed decimal (1), (2)
• PACKED keyword
  • in CREATE EXTERNAL TABLE statement
• PAGE keyword
  • in ALTER TABLE statement
  • in CREATE TABLE statement
  • in CREATE Temporary TABLE statement
• Page-level locking, in CREATE TABLE
• Page number
• Parallel distributed queries
  • SET PDQPRIORITY statement
• Parallelizable data query
• PARALLELIZABLE keyword, in Routine Modifier segment (1), (2), (3)
• Parameter
  • BYTE or TEXT in SPL
  • dynamic
  • in CALL statement
  • Java method
  • UDRs
• PARAMETER keyword
  • External Routine Reference segment
• Parameterizing
  • prepared statements
• Parameterizing a statement, with SQL identifiers
• Parent-child relationship
• Parent table
• PARTITION keyword
  • in ALTER FRAGMENT statement (1), (2), (3), (4), (5), (6)
• Partitions (1), (2)
• PASSEDBYVALUE keyword, in CREATE OPAQUE TYPE statement
• passwd file
• PASSWORD keyword
  • in SET ENCRYPTION PASSWORD statement
• PDQ
  • SET ENVIRONMENT statement
  • SET PDQPRIORITY statement
• PDQ thread safe functions
• PDQPRIORITY environment variable (1), (2), (3), (4)
• PDQPRIORITY keyword
  • in SET PDQPRIORITY statement
• PERCALL_COST keyword, Routine Modifier segment (1), (2)
• Percent (%) sign
  • as wildcard
• Period (.)
  • dot notation
• Period symbol (.)
  • DATETIME separator
  • DECIMAL values
  • INTERVAL separator
  • MONEY values
• Permission.
  • See Privilege.
• Phantom row (1), (2)
• Pipe character ( | ) (1), (2), (3), (4), (5)
• PIPE keyword
  • in CREATE EXTERNAL TABLE statement
  • in OUTPUT statement
• PLOAD keyword
  • in SET PLOAD FILE statement
• Plus (+) sign
  • arithmetic operator
• plus() operator function
• Plus operator (+)
  • unary (1), (2)
• Plus sign (+)
  • optimizer directives
  • unary operator (1), (2)
• POINTER data type
• Polar coordinates
• positive() operator function
• POW function (1), (2)
• Precedence, dot notation
• PRECISION field
  • in GET DESCRIPTOR statement
  • in SET DESCRIPTOR statement
  • with DESCRIBE INPUT statement
  • with DESCRIBE statement
• PRECISION keyword.
  • See PRECISION field.
• PREPARE statement
  • deferring
  • for collection variables
  • increasing efficiency
  • multistatement text (1), (2)
  • parameterizing a statement
  • parameterizing for SQL identifiers
  • question (?) mark as placeholder
  • releasing resources with FREE
  • restrictions with SELECT
  • statement identifier
  • statement identifier use
  • syntax
  • valid statement text
  • with external routines
  • with SPL routines
• Prepared statement
  • comment symbols in
  • DESCRIBE statement with
  • executing
  • parameterizing
  • prepared object limit (1), (2)
  • setting PDQ priority
  • valid statement text
  • with DESCRIBE INPUT statement
• Preserving newline characters in quoted strings
• PREVIOUS keyword, in FETCH statement
• Primary key column, no NULL default
• Primary key constraint
  • moving
• Primary-key constraint
  • data type conversion
  • defining column as
  • dropping
  • requirements for (1), (2)
  • rules of use
  • using
• PRIMARY KEY keywords
  • in ALTER TABLE statement (1), (2), (3)
  • in CREATE TABLE statement (1), (2), (3)
  • in CREATE Temporary TABLE statement (1), (2)
• PRIMARY keyword
  • in CREATE ACCESS_METHOD statement
• Printed manuals
• PRIOR keyword, in FETCH statement
• PRIVATE keyword
  • in CREATE SYNONYM statement
• Privilege
  • Alter
  • chaining grantors
  • column-specific
  • Connect
  • database-level (1), (2)
  • DBA (1), (2)
  • effect of NODEFDAC
  • Execute (1), (2)
  • for triggered action
  • fragment-level
    • revoking
  • granting
  • in system calls
  • needed, to create a cast
  • on a synonym
  • on a view
  • on languages (1), (2)
  • on named row type
  • on remote objects
  • on sequences (1), (2)
  • on table fragments
  • Resource
  • table-level
    • ANSI-compliant
    • column-specific
    • effect on view
  • Usage
• PRIVILEGES keyword
  • in GRANT statement
  • in INFO statement
  • in MOVE TABLE statement
  • in REVOKE statement
• Procedural language
• Procedure
  • altering with ALTER PROCEDURE
  • creating from file
  • dropping with DROP PROCEDURE
  • dropping with DROP ROUTINE
  • modifying path to executable file
  • modifying routine modifiers
  • privileges
  • specific name
  • stored.
    • See SPL Routine.
  • system catalog tables for
  • user-defined, definition
• Procedure cursor
  • opening
• PROCEDURE keyword
  • DEFINE statement
  • in ALTER PROCEDURE statement
  • in CREATE PROCEDURE statement
  • in DROP PROCEDURE statement
  • in EXECUTE PROCEDURE statement
  • in GRANT statement
  • in REVOKE statement
  • in TRACE statement
  • in UPDATE STATISTICS statement
• Procedure Name.
  • See Database Object Name.
• Projection
  • column with dot notation
  • field projection
• Projection clause
• Projection list
  • See also Select list.
• Promotable lock
• Pseudo-table
• Pseudo-users
• PUBLIC keyword
  • in CREATE SYNONYM statement
  • in GRANT FRAGMENT statement
  • in GRANT statement
  • in REVOKE FRAGMENT statement
  • in REVOKE statement
• Purpose
  • defined
• Purpose flags
  • adding and deleting
  • list
• Purpose functions
  • adding, changing, and dropping
  • for access methods (1), (2)
  • for XA data source types
  • parallel-execution indicator
• Purpose options, valid settings
• Purpose values
  • adding, changing, and dropping
• PUT keyword
  • in ALTER TABLE statement
  • in CREATE TABLE statement
• PUT statement
  • FLUSH with
  • source of row values
  • syntax
  • use in transactions

• Qualifier, field
  • for DATETIME
  • for INTERVAL (1), (2)
• Qualifier field
  • for DATETIME
• Qualifying rows
• Query
  • distributed (1), (2), (3), (4), (5)
  • external databases
  • external directives
  • operator overflow
  • optimizing
    • Optimizer Directives
  • optimizing prepared statements
  • optimizing with SAVE EXTERNAL DIRECTIVES
  • optimizing with SET OPTIMIZATION
  • piping results to another program
  • priority level
  • qualifying rows
  • remote databases
  • result set
  • scheduling level for
  • sending results to an operating-system file
  • sending results to another program
• Query optimizer
  • recalculating distributions
• Question mark (?)
  • as placeholder in PREPARE
  • as wildcard
  • dynamic parameters
  • generating unique large-object filename
  • naming variables in PUT
• Question Mark (?)
  • placeholder in PREPARE
• Quotation marks
  • delimited identifier
  • double
  • effects of DELIMIDENT environment variable
  • literal in a quoted string
  • literal nested collection
  • owner name
  • quoted string delimiter (1), (2)
  • single
• Quoted Pathname segment
• Quoted string
  • as constant expression
  • DATETIME values as strings
  • effects of DELIMIDENT environment variable
  • in INSERT (1), (2)
  • INTERVAL values as strings
  • maximum length
  • newline characters
  • newline characters in
  • segment
  • wildcards
  • with LIKE keywords

• R-tree index
  • creating (1), (2)
  • default operator class
  • detached
  • dropping
  • rtree_ops operator class
  • uses
• R-tree secondary-access method (1), (2)
• Radicand
• Radix-64 encryption format
• RAISE EXCEPTION statement
• Range fragmentation
• RANGE function (1), (2)
• RANGE keyword, in CREATE TABLE statement
• RAW keyword
  • in ALTER TABLE statement
  • in CREATE TABLE
  • in CREATE TABLE statement
  • in SELECT statement
  • in SET Default Table Type statement
• READ COMMITTED keywords
  • in SET TRANSACTION statement
• READ keyword, in SET ISOLATION statement
• READ ONLY keywords
  • in DECLARE statement
  • in SELECT statement
  • in SET TRANSACTION statement
• READ UNCOMMITTED keywords
  • in SET TRANSACTION statement
• READ WRITE keywords
  • in SET TRANSACTION statement
• REAL data type
• Real numbers
• Receive support function
• RECORDEND environment variable (1), (2)
• RECORDEND keyword
  • in CREATE EXTERNAL TABLE statement
  • in SELECT statement
• REFERENCES keyword
  • in ALTER TABLE statement
  • in CREATE TABLE statement
  • in DEFINE statement
  • in GRANT statement
  • in INFO statement
  • in Return Clause segment
  • in REVOKE statement
• References privilege
  • defined
  • displaying
  • revoking
• REFERENCING keyword
  • in CREATE TRIGGER statement
    • Delete triggers
    • Insert triggers
    • INSTEAD OF triggers
    • SELECT triggers
    • Update triggers
    • view column values
• Referential constraint
  • B-tree index
  • Dataskip feature
  • defining
  • delete triggers
  • dropping
  • locking
• Referential integrity
• REJECTFILE keyword
  • in CREATE EXTERNAL TABLE statement (1), (2)
• Relational operators
  • IN
  • segment
  • with WHERE keyword in SELECT
• RELATIVE keyword, in FETCH statement
• Release Notes
• REMAINDER IN keywords
  • in ALTER FRAGMENT statement (1), (2), (3), (4)
  • in CREATE INDEX statement
  • in CREATE TABLE statement (1), (2), (3)
• Remote query
• RENAME COLUMN statement
• RENAME DATABASE statement
• RENAME INDEX statement
• RENAME keyword
  • in MOVE TABLE statement
• RENAME SEQUENCE statement
• RENAME TABLE statement
• REOPTIMIZATION keyword
  • in OPEN statement
• Reoptimizing query plans
• Repeatable Read isolation level (1), (2), (3), (4)
• Repeatable Read isolation level, emulating during update
• REPEATABLE READ keywords
  • in SET ISOLATION statement
  • in SET TRANSACTION statement
• REPLACE function
• REPLICATION keyword
  • in BEGIN WORK statement
• Reserved words
  • delimited identifiers
  • identifiers
  • SQL (1), (2)
  • using in triggered action
• RESOLUTION keyword, in UPDATE STATISTICS statement
• Resource Grant Manager (1), (2)
• RESOURCE keyword
  • in GRANT statement
  • in REVOKE statement
• Resource privilege (1), (2)
  • with CREATE ACCESS_METHOD statement
• Resource usage policy
• RESTART keyword, in ALTER SEQUENCE statement
• RESTRICT keyword
  • in DROP ACCESS_METHOD statement
  • in DROP OPCLASS statement
  • in DROP ROW TYPE statement
  • in DROP TABLE statement
  • in DROP TYPE statement
  • in DROP VIEW statement
  • in DROP XADATASOURCE statement
  • in DROP XADATASOURCE TYPE statement
  • in MOVE TABLE statement
  • in REVOKE statement
• RESTRICTED mode of UDRs
• Result sets (1), (2)
• RESUME keyword
  • in ON EXCEPTION statement
  • in RETURN statement
• RETAIN UPDATE LOCKS keywords
  • in SET ISOLATION statement
• RETURN statement
• Return value
  • declaring in CREATE FUNCTION
• RETURNED_SQLSTATE field (1), (2)
• RETURNED_SQLSTATE keyword, in GET DIAGNOSTICS statement
• RETURNING keyword
  • example (1), (2)
  • in CALL statement
  • Return Clause Segment
• RETURNS keyword
  • Return Clause segment
  • Shared-Object-Filename segment
• REUSE keyword
  • in TRUNCATE statement
• REVOKE FRAGMENT statement
• REVOKE statement
• RGM
  • See also Resource Grant Manager
• RIGHT keyword
  • in ANSI Joined Tables segment
  • in SELECT statement
• Right outer joins
• Role
  • activating with SET ROLE
  • built-in (1), (2), (3)
  • case-sensitivity
  • creating with CREATE ROLE
  • currently enabled
  • default (1), (2), (3), (4)
  • default roles
  • definition
  • dropping with DROP ROLE statement
  • enabling with SET ROLE
  • establishing with CREATE, GRANT, SET
  • EXTEND (1), (2)
  • granting privileges with GRANT
  • granting role with GRANT
  • revoking privileges
  • scope of
• ROLE keyword
  • in CREATE ROLE statement
  • in DROP ROLE statement
  • in SET ROLE statement
  • REVOKE statement
• ROLES keyword
  • in MOVE TABLE statement
• ROLLBACK WORK statement (1), (2)
  • with WHENEVER
• ROOT function (1), (2)
• ROUND function (1), (2)
• ROUND ROBIN keywords
  • in ALTER FRAGMENT statement
  • in CREATE TABLE statement
• Rounding error
• ROUTINE keyword
  • in ALTER ROUTINE statement
  • in DROP ROUTINE statement
  • in GRANT statement
  • in REVOKE statement
  • in UPDATE STATISTICS statement
• Routine manager
• Routine modifier
  • CLASS
  • COSTFUNC
  • HANDLESNULLS
  • INTERNAL
  • ITERATOR
  • NEGATOR
  • NOT VARIANT
  • PARALLELIZABLE
  • PERCALL_COST
  • SELCONST
  • SELFUNC
  • STACK
  • VARIANT
• Routine signature
• Routines
  • altering with ALTER ROUTINE
  • checking references
  • creating with CREATE ROUTINE FROM
  • dropping with DROP ROUTINE
  • modifying
    • path to executable file (1), (2)
    • routine modifiers
  • privileges
  • restrictions in triggered action
  • specific name
• Row-column level encryption
• ROW constructor, in Expression segment
• ROW_COUNT keyword, in GET DIAGNOSTICS statement
• ROW data types
  • collection-derived tables
  • constructor syntax
  • dot notation with
  • loading field values (1), (2)
  • nested
  • privileges
  • selecting fields (1), (2)
  • selecting from
  • unloading (1), (2)
  • updating (1), (2)
• ROW keyword
  • in ALLOCATE ROW statement
  • in ALTER TABLE statement
  • in CREATE ROW TYPE statement
  • in CREATE TABLE statement
  • in CREATE Temporary TABLE statement
  • in CREATE TRIGGER statement (1), (2)
  • in DROP ROW TYPE statement
  • in Expression segment
  • in Literal Row segment
• Row-level locking, in CREATE TABLE
• Row-type columns, generating values for
• Row variable
  • accessing
  • allocating memory
  • deallocating memory for
  • inserting
  • inserting into
  • selecting from
  • updating
• ROWID
  • adding column with INIT clause
  • adding with ALTER TABLE
  • dropping from fragmented tables
  • specifying support
  • use in a column expression
  • use in fragmented tables
  • used as column name (1), (2)
• rowid column (1), (2), (3)
• ROWID keyword, in Expression segment
• ROWIDS keyword
  • in ALTER FRAGMENT statement
• ROWIDS keyword, in CREATE TABLE statement
• Rows
  • deleting
  • finding location
  • inserting
    • through a view
    • with a cursor
  • order of qualifying rows
  • phantom row
  • retrieving with FETCH
  • rowid defined
  • uncommitted row
  • updating through a view
  • waiting for a locked row
  • writing buffered rows with FLUSH
• ROWS keyword, in START VIOLATIONS TABLE statement
• RPAD function (1), (2)
• RSAM access method
• RTNPARAMTYPES data type