Index

• !=, not equal, relational operator
• =, equals, relational operator (1), (2)
• ?, question mark
  • as placeholder in PREPARE
• >=, greater than or equal to, relational operator

• 10.0 features, overview

• Access modes, description of
• Accessibility
  • dotted decimal format of syntax diagrams
  • syntax diagrams, reading in a screen reader
• Active set
  • definition of (1), (2)
  • of a cursor
• Aggregate functions
  • and GROUP BY clause
  • AVG
  • COUNT
  • description of (1), (2)
  • finding NULL values
  • in ESQL
  • in expressions
  • in SPL routine
  • in subquery
  • MAX
  • MIN
  • null value signalled
  • RANGE
  • standard deviation
  • STDEV
  • SUM
  • VARIANCE
• Alias
  • for table name
  • to assign column names in temporary table
  • using
    • as a query shortcut
    • with a supertable
  • with self-join
• ALL keyword
  • beginning a subquery
  • in subquery
• ALTER INDEX statement, locking table
• AND logical operator
• ANSI
  • isolation levels
  • SQL version
• ANSI-compliant database
  • FOR UPDATE not required in
  • signalled in SQLWARN
• ANSI standard
  • as extension to Informix syntax
• ANY keyword, in SELECT statement
• Application
  • handling errors
  • isolation level
  • update cursor
• Archiving
  • database server methods
  • description of
  • transaction log
• Arithmetic expressions
• Arithmetic operator, in expression
• Ascending order in SELECT
• Asterisk, wildcard character in SELECT
• Asterisk notation, in a SELECT statement
• AVG function, as aggregate function

• BEGIN WORK statement
• BETWEEN keyword
  • using in WHERE clause
  • using to specify a range of rows
• Boldface type
• Boolean expression
• Braces ( { } ) comment delimiters
• Built-in type variable
• BYTE data type
  • restrictions with GROUP BY
  • using LENGTH function on
  • with relational expression

• CALL statement, in SPL function
• Cardinality function
  • description of
• CARDINALITY function
• Cartesian product
  • basis of any join
  • description of
• Cascading deletes
  • child tables
  • definition of
  • locking associated with
  • logging (1), (2)
  • referential integrity
  • restriction
• Case conversion
  • with INITCAP function
  • with LOWER function
  • with UPPER function
• CASE expression
  • description of
  • in UPDATE statement
  • using
• CHAR data type
  • converting to a DATE value
  • converting to a DATETIME value
  • in relational expressions
  • substrings of
  • truncation signalled
• Character string
  • converting to a DATE value
  • converting to a DATETIME value
• Check constraint, definition of
• Class libraries, shared
• CLOSE DATABASE statement, effect on database locks
• Code, sample, conventions for
• Collation order and GLS
• Collection data types
  • accessing (1), (2)
  • counting elements in (1), (2)
  • description of
  • element, searching for with IN
  • simple
  • updating (1), (2)
  • using the CARDINALITY function
• Collection-derived table
  • accessing elements in a collection
  • description of (1), (2)
  • restrictions on
  • using in SPL
• Collection subquery
  • description of
  • ITEM keyword (1), (2)
  • using ITEM keyword in
• Collection types
  • in an SPL routine
  • in DELETE statement
• Collection values, inserting into columns
• Collection variable
  • defining, restrictions on
  • nested (1), (2)
  • selecting
• Collections, with INSERT statement
• Column number, using
• Columns
  • definition of
  • descending order
  • description of
  • in relational model
  • label on
  • ordering the selection of
  • row-type, definition of
• Command-line conventions
  • how to read
  • sample diagram
• COMMIT WORK statement
  • closing cursors
  • releasing locks (1), (2)
  • setting SQLCODE
• Committed Read isolation level (Informix)
• commutator function
  • definition
• Comparison condition, description of
• Compliance
  • with industry standards
• Compound query
• Concurrency
  • access modes
  • active set
  • ANSI isolation levels
  • Cursor Stability isolation (Informix)
  • database lock
  • deadlock
  • description of (1), (2)
  • Informix isolation levels
  • isolation level
  • kinds of locks
  • lock duration
  • lock scope
  • multiple programs
  • table lock
• Configuration parameter
  • ISOLATION_LOCKS
• Constraint, entity integrity
• Contact information
• Conventions
  • command-line
  • documentation
  • sample-code
  • syntax diagrams
  • syntax notation
  • typographical
• Conversion function, description of
• Coordinated deletes
• Correlated subquery
  • definition of
  • restriction with cascading deletes
• COUNT function
  • and GROUP BY
  • as aggregate function
  • count rows to delete
  • use in a subquery
  • with DISTINCT
• CREATE DATABASE statement
  • setting shared lock
  • SQLWARN after
• CREATE FUNCTION, return clause
• CREATE FUNCTION FROM statement, in embedded languages
• CREATE FUNCTION statement
  • inside CREATE FUNCTION FROM statement
  • using
  • WITH LISTING IN clause
• CREATE INDEX statement, locking table
• CREATE PROCEDURE FROM statement, in embedded languages
• CREATE PROCEDURE statement
  • inside CREATE PROCEDURE FROM
  • using
  • WITH LISTING IN clause
• CREATE TABLE statement
  • cascading deletes
  • collection types
  • hierarchy
  • LOCK MODE clause
  • multiset columns
  • ON DELETE CASCADE clause
  • primary keys
  • row type columns
  • setting the lock mode
  • smart large object columns
  • typed table
• CREATE TRIGGER statement
• Cross join
• CURRENT function
  • comparing column values
  • using
• Cursor
  • active set of
  • closing
  • declaring
  • definition of
  • end of transaction
  • for insert
  • for update (1), (2)
  • opening (1), (2)
  • retrieving values with FETCH
  • scroll
  • sequence of program operations
  • sequential (1), (2)
• Cursor Stability isolation level (Informix)
• Cyclic query

• Data definition statements
• Data encryption functions
• Data integrity
  • failures
• Data loading
• Data model, description of
• Data replication
• Data type
  • automatic conversions
  • collection, accessing (1), (2)
  • conversion (1), (2)
• Database
  • ANSI-compliant
  • compared to file
  • concurrent use
  • control of
  • definition of
  • external
  • locking
  • management of
  • modifying contents of
  • object-relational, description of
  • relational, description of
  • remote
  • server
• Database object
  • constraints as a
  • index as a
  • object modes
  • trigger as a
  • violation detection
• Database object mode
  • examples
• Database server
  • archiving
  • identifying host computer name
  • identifying version number
  • locking tables
  • signalled in SQLWARN
  • statement caching
• DATABASE statement
  • locking
  • SQLWARN after
• DataBlade modules
• DATE data type
  • converting to a character string
  • functions returning
  • in ORDER BY sequence
  • in relational expressions
• DATE function, as conversion function
• DATETIME data type
  • converting to a character string
  • displaying format
  • functions returning
  • in ORDER BY sequence
  • in relational expressions
• DATETIME values, formatting
• DAY function
• DB-Access
  • creating database with
• DBDATE environment variable
• DBINFO function, in SELECT statement
• DBSERVERALIAS, TCP/IP connection in
• DBSERVERNAME, TCP/IP connection in
• DBSERVERNAME function, in SELECT statement
• dbspace, name returned by DBINFO function
• Deadlock detection
• DECIMAL data type, signalled in SQLWARN
• DECLARE CURSOR statement
• DECLARE statement
  • description of
  • FOR INSERT clause
  • FOR UPDATE
  • SCROLL keyword
  • WITH HOLD clause
• DECODE function
• DECRYPT_BINARY function
• DECRYPT_CHAR function
• DEF_TABLES_LOCKMODE configuration parameter
• Default locale
• Default values
  • in column
  • using
• DELETE statement
  • all rows of table
  • collection types
  • coordinated deletes
  • count of rows
  • description of
  • developing
  • duplicate rows
  • embedded (1), (2)
  • lock mode
  • number of rows
  • preparing
  • remove all rows (1), (2)
  • row types
  • selected rows
  • specific rows
  • transactions with
  • using
  • using join in XPS
  • using subquery
  • WHERE clause restriction
  • with cursor
  • with supertables
• Delete using TRUNCATE TABLE
• Dependencies, software
• Descending order in SELECT
• Diagnostics table
  • description of
  • example of privileges
  • examples of starting
• Difference set operation
• Dirty Read isolation level (Informix)
• Disabilities, visual
  • reading syntax diagrams
• Display label
  • in ORDER BY clause
  • with SELECT
• Display labels
• DISTINCT keyword
  • relation to GROUP BY
  • using in SELECT
  • using with COUNT function
• Distinct-type variable
• DOCUMENT clause, use in SPL routine
• Documentation, types of
  • machine notes
  • online manuals
  • printed manuals
• Documentation conventions
• Documentation Notes
• Documentation set of all manuals
• Domain of column
• Dot notation
• Dotted decimal format of syntax diagrams
• double hyphen (--) comment indicator
• DROP INDEX statement, locking table
• Duplicate values, finding
• Dynamic routine-name specification
  • for SPL function
  • for SPL routine
  • rules for
• Dynamic Server, object-relational databases
• Dynamic SQL
  • description of (1), (2)
  • freeing prepared statements

• Embedded SQL
  • definition of
  • languages available
• en_us.8859-1 locale
• ENCRYPT_AES function
• ENCRYPT_TDES function
• End of data
  • signal in SQLCODE (1), (2)
  • signal only for SELECT
  • SQLCODE
  • when opening cursor
• Entity integrity
• Environment variables
• Equals (=) relational operator (1), (2)
• Equi-join (1), (2)
• Error checking
  • simulating errors
  • SPL routine (1), (2)
• Error message files
• Error messages
  • applying fixed
  • for trigger failure
  • generating a variable
  • generating in a trigger
  • retrieving trigger text in a program (1), (2)
• Errors
  • after DELETE
  • codes for
  • dealing with
  • detected on opening cursor
  • during updates
  • inserting with a cursor
  • ISAM error code
• ESCAPE keyword, using in WHERE clause (1), (2)
• ESQL
  • cursor use (1), (2)
  • DELETE statement in
  • delimiting host variables
  • dynamic embedding (1), (2)
  • error handling
  • fetching rows from cursor
  • host variable (1), (2)
  • indicator variable
  • INSERT in
  • overview (1), (2), (3)
  • preprocessor
  • scroll cursor
  • selecting single rows
  • SQL Communications Area (SQLCA)
  • SQLCODE
  • SQLERRD fields
  • static embedding
  • UPDATE in
• EXCLUSIVE keyword
  • in DATABASE statement
• Exclusive lock
• EXECUTE FUNCTION statement
  • with SPL
• EXECUTE IMMEDIATE statement, description of
• Execute privilege
  • DBA keyword, effect of
  • objects referenced by a routine
• EXECUTE PROCEDURE statement
  • with SPL
• EXISTS keyword
  • in a WHERE clause
  • in SELECT statement
• Expression
  • CASE
  • date-oriented
  • description of
  • display label for
  • in SPL routine
• EXTEND function
  • using in expression
  • with DATE, DATETIME, and INTERVAL
• Extensibility, description of
• External database
• External tables

• Features in 10.0
• FETCH statement
  • ABSOLUTE keyword
  • description of
  • sequential
  • with sequential cursor
• Field, definition of
• Field projection
• File, compared to database
• Filtering mode
• FIRST clause
  • description of
  • in a union query
  • using
  • with ORDER BY clause
• Fixed and Known Defects File
• FLUSH statement
  • count of rows inserted
  • rollback
  • writing rows to buffer
• FOR UPDATE keywords
  • conflicts with ORDER BY
  • not needed in ANSI-compliant database
  • specific columns
• FOREACH statement
• Foreign key
• FREE statement, freeing prepared statements
• FROM keyword, alias names
• Function
  • aggregate
  • applying to expressions
  • conversion
  • DATE
  • date-oriented
  • DBINFO
  • DECODE
  • in SELECT statements
  • INITCAP
  • LOWER
  • LPAD
  • name confusion in SPL routine
  • NVL
  • REPLACE
  • RPAD
  • smart large object
  • string manipulation
  • SUBSTR
  • SUBSTRING
  • time
  • TO_CHAR
  • TO_DATE
  • UPPER
• Functions, data encryption

• GET DIAGNOSTICS statement
• GETHINT function
• Global Language Support (GLS)
  • and MATCHES keyword
  • and ORDER BY keywords
  • default locale
  • sort order
• Global variable
  • declaring
  • description of
• GLS.
  • See also Global Language Support.
• GRANT statement, in embedded SQL (1), (2)
• Granularity, of locks
• Greater than or equal to (>=) relational operator
• GROUP BY clause
  • description of
• GROUP BY keywords
  • column number with
  • description of

• HAVING clause, description of
• HAVING keyword
• Help
• HEX function, using in expression
• Hierarchy
  • table and row
• Hold cursor, definition of
• Host variable
  • delimiter for
  • description of
  • fetching data into
  • in DELETE statement
  • in INSERT statement
  • in UPDATE statement
  • in WHERE clause
  • INTO keyword sets
  • null indicator
  • restrictions in prepared statement
  • truncation signalled

• IF statement, in SPL
• IFX_DEF_TABLE_LOCKMODE environment variable
• IN keyword
  • to form an intersection
  • using in WHERE clause
• IN relational operator
• Indicator variable, definition of
• Industry standards, compliance with
• Informix Dynamic Server documentation set
• INFORMIXDIR/bin directory
• INITCAP function, as string manipulation function
• Insert cursor
  • definition of
  • using
• INSERT statement
  • and end of data
  • collection columns
  • constant data with
  • count of rows inserted
  • description
  • embedded
  • inserting
    • collections
    • into supertables
    • multiple rows
  • lock mode
  • named row type
  • null values in collection
  • number of rows
  • SELECT restrictions
  • SELECT statement in
  • selected columns
  • serial values
  • smart large objects in
  • unnamed row type
  • VALUES clause
  • with row-type columns
  • with SELECT statement
• Inserting rows of constant data
• Installation Guides
• INSTEAD OF trigger
• Intent lock
• Intersection
  • definition of
  • set operation
• INTERVAL data type
  • in relational expressions
• INTO clause
• INTO keyword
  • choice of location
  • in FETCH statement
  • mismatch signalled in SQLWARN
  • restrictions in INSERT
  • restrictions in prepared statement
  • retrieving multiple rows
  • retrieving single rows
• INTO TEMP keywords, description of
• IS NOT NULL keywords
• IS NULL keywords
• ISAM error code
• ISO 8859-1 code set (1), (2)
• Isolation level
  • ANSI (1), (2)
  • Cursor Stability (Informix)
  • description of
  • dirty read
  • Informix
  • read uncommitted
  • repeatable read
• ISOLATION_LOCKS configuration parameter
• ITEM keyword, collection subquery (1), (2)

• Join
  • ANSI outer-join syntax
  • associative
  • composite
  • condition
  • creating
  • cross
  • definition of (1), (2)
  • delete join
  • equi-join
  • in an UPDATE statement
  • Informix outer join syntax
  • left outer
  • multiple-table join
  • natural
  • nested simple
  • outer
  • right outer
  • self-join
  • simple

• Keywords
  • in a subquery
  • in a WHERE clause
  • in syntax diagrams

• Label (1), (2)
• Left outer join
• LENGTH function
  • on TEXT or BYTE strings
  • on VARCHAR
  • use in expression
• Less than or equal to (
• LET statement (1), (2)
• LIKE clause
  • in SPL function
• LIKE keyword
  • description of
  • using in WHERE clause
• Local variable, description of
• Locale
• Lock mode, TABLE
• LOCK TABLE statement, locking a table explicitly
• Locking
  • and concurrency
  • behavior of different lock types
  • deadlock
  • description of
  • end of transaction
  • integrity
  • intent locks
  • lock duration
  • number of rows to lock
  • row and key locks
  • scope of lock
  • setting lock mode
  • time limit
  • types of locks
    • coarse index lock
    • database lock
    • exclusive
    • page lock (1), (2)
    • promotable
    • promotable lock
    • row and key locks
    • shared
    • smart-large-object locks
    • table lock
  • update cursor
  • update lock
  • WAIT keyword
  • with DELETE
• Logical log
  • and backups
  • description of
• Logical operator
  • = (equals)
  • AND
  • NOT
  • OR
• Logslice, description of
• Loop, exiting with RAISE exception
• LOWER function, as string manipulation function
• LPAD function, as string manipulation function

• Machine notes
• MATCHES keyword
  • using GLS
  • using in WHERE clause
• MATCHES relational operator
  • how locale affects
  • in WHERE clause
• MAX function, as aggregate function
• MDY function, as time function
• MIN function, as aggregate function
• MODE ANSI keywords, specifying transactions
• MONEY data type
  • in INSERT statement
• MONTH function
  • using, TIME function
    • MONTH
• MONTH function, as time function
• Multiple-table join
• Multiple-Table SELECTs
• MULTISET keyword
  • collection subquery
• Multithreaded application, definition of

• Named row type, in VALUES clause
• Natural join
• NCHAR data type, querying on
• Nested ordering, in SELECT
• NODEFDAC environment variable, effect on privileges granted to public
• Nonlogging tables
• NOT BETWEEN keywords in WHERE clause
• Not equal (!=) relational operator
• NOT EXISTS keywords
• NOT IN keywords
• NOT logical operator
• Null value
  • detecting in ESQL
  • testing for
  • with logical operator
• NVARCHAR data type, querying on
• NVL function

• Object modes
  • description of (1), (2), (3)
  • disabled
  • enabled (1), (2)
  • filtering
• Object-relational database, description of
• ON DELETE CASCADE option
• ON EXCEPTION statement
  • scope of control
  • trapping errors
  • user-generated errors
• Online help
• Online manuals
• Online notes (1), (2)
• onload utility
• onunload utility
• Opaque-type variable
• OPEN statement
• Opening a cursor
• OR logical operator
• OR relational operator
• ORDER BY keywords
  • and GLS
  • ascending order
  • DESC keyword (1), (2)
  • display label with
  • multiple columns
  • relation to GROUP BY
  • restrictions in INSERT
  • restrictions with FOR UPDATE
  • select columns by number
  • sorting rows
• Outer-join syntax
  • ANSI
  • Informix

• Page locking
• Parts explosion
• Performance
  • effect of concurrency
  • increasing with stored routines
• PREPARE statement
  • description of
  • error return in SQLERRD
  • multiple SQL statements
• Primary key, definition of
• Primary key constraint, definition of
• Printed manuals
• Privileges
  • database-level
  • displaying (1), (2)
  • needed to modify data
  • on a database
  • overview
  • table-level
• Procedure-type variables
• Program variables
  • SPL
• Project, description of
• Projection, definition of
• Promotable lock (1), (2)
• PUT statement
  • constant data with
  • count of rows inserted
  • insert data (1), (2)
  • sends returned data to buffer
  • status code

• Qualifier, existential
• Query
  • audit
  • compound
  • cyclic
  • self-referencing
  • stated in terms of data model

• RAISE EXCEPTION statement
• RANGE function, as aggregate function
• Re-entrant trigger, description of
• Read Committed isolation level (ANSI)
• Read Uncommitted isolation level (ANSI)
• Recursive relationship, example of
• REFERENCES keyword, in SPL function
• Referential constraint, definition of
• Referential integrity, definition of
• Relational database, description of
• Relational model
  • join
  • projection
  • selection
• Relational operation
• Relational operator
  • BETWEEN
  • EXISTS
  • IN
  • in a WHERE clause
  • LIKE
  • MATCHES
  • NULL
  • OR
• Release Notes
• Remote database
• Repeatable read isolation level
• REPLACE function, as string manipulation function
• Replication
  • of data
  • transparency
• Return types, in SPL function
• REVOKE statement, in embedded SQL (1), (2)
• Right outer join
• roles
  • default
  • definition
• ROLLBACK WORK statement
  • closes cursors
  • releases locks (1), (2)
  • setting SQLCODE
• Row
  • checking rows processed in SPL routines
  • definition of (1), (2)
  • finding number of rows processed
  • in relational model
  • inserting
  • locking
  • number of rows returned
  • removing
  • updating
• Row type
  • dot notation with
  • field, definition of
  • field projection
  • field projections in SELECT
  • in DELETE statement
  • selecting columns from
  • selecting data from
  • updating
  • using asterisk notation with SELECT
• Row-type column
  • definition of
  • null values
• Row-type data, selecting columns of
• Row-type variables, delcaring
• Rowid, using to locate internal row numbers
• RPAD function, as string manipulation function

• Sample-code conventions
• Screen reader
  • reading syntax diagrams
• Screens, example
• Scroll cursor
  • active set
  • definition of
• SCROLL keyword, using in DECLARE
• Select, description of
• Select cursor
  • opening
  • using
• Select list
  • display label
  • expressions in
  • functions in (1), (2)
  • labels in
  • selecting all columns
  • selecting specific columns
  • specifying a substring in
• SELECT statements
  • accessing collections (1), (2)
  • active set (1), (2)
  • advanced
  • aggregate functions in (1), (2)
  • alias names
  • ALL keyword
  • and end-of-data return code
  • ANY keyword
  • basic concepts
  • collection-derived table
  • collection expressions
  • collection subquery
  • compound query
  • cursor for (1), (2)
  • date-oriented functions in
  • description of
  • display label
  • DISTINCT keyword
  • embedded (1), (2)
  • executing triggered actions
  • EXISTS keyword (1), (2)
  • FIRST clause
  • for joined tables
  • for single tables (1), (2)
  • forms of
  • functions (1), (2)
  • GROUP BY clause
  • HAVING clause
  • in UPDATE statement (1), (2)
  • INTO clause with ESQL
  • INTO TEMP clause
  • isolation level
  • join
  • multiple-table
  • natural join
  • ORDER BY clause
  • outer join
  • select list
  • selecting a row type
  • selecting a substring
  • selecting expressions
  • selection list
  • self-join
  • set operations
  • simple
  • single-table
  • singleton (1), (2)
  • smart-large-object functions in
  • stand-alone
  • subquery
  • UNION operator
  • using
    • for join
    • for projection
    • for selection
  • using functions
• Select trigger, description of
• Selection, description of
• Self-join
  • assigning column names with INTO TEMP
  • description of
• Self-referencing query (1), (2)
• Semantic integrity
• Sequence
  • definition of
• Sequential cursor, definition of
• SERIAL data type
  • finding last SERIAL value inserted
  • generated number in SQLERRD
  • inserting a starting value
• Servers, database, communicating with other servers
• Session ID, returned by DBINFO function
• SET clause, in UPDATE statement
• SET COLLATION
• Set intersection
• SET ISOLATION statement
  • and SET TRANSACTION (1), (2)
  • use of
• SET keyword, in UPDATE statement
• SET LOCK MODE statement, description of
• Set operation
  • difference
  • intersection
  • union
  • use of
• SET TRANSACTION statement
  • and SET ISOLATION
  • use of
• Shared class libraries
• Shared lock
• Simple large object, SPL variable
• Singleton SELECT statement (1), (2)
• SITENAME function, in SELECT statement
• Smart large object
  • functions for copying
  • importing and exporting (1), (2)
  • in an UPDATE statement
  • SPL variables
  • using SQL functions
    • in a SELECT statement
    • in an INSERT statement
• Software dependencies
• SOME keyword, beginning a subquery
• Sorting
  • as affected by a locale
  • effects of GLS
  • nested
  • with ORDER BY
• Special character, protecting
• Specific name, for SPL routine
• SPL
  • assigning values to variables (1), (2), (3)
  • FOREACH loop
  • LET statement
  • parameter list
  • program variable
  • relation to SQL (1), (2)
  • return clause
  • statement block
  • tracing triggered actions
  • using cursors
  • WITH LISTING IN clause
• SPL function
  • CALL statement
  • collection query
  • definition of
  • dynamic routine-name specification
  • large object variables
  • variant vs. not variant
  • WITH clause
• SPL routine
  • adding comments to
  • as triggered action
  • collection data types
  • comments
  • compiler messages
  • CONTINUE statement
  • debugging
  • definition of
  • dot notation
  • dropping
  • dynamic routine-name specification
  • example of
  • exceptions (1), (2)
  • EXECUTE PROCEDURE
  • executing
  • EXIT statement
  • exiting a loop
  • finding errors
  • FOR loop
  • IF..ELIF..ELSE structure
  • in an embedded language
  • in SELECT statements
  • in XPS
  • introduction to
  • name confusion with SQL functions
  • passing data
  • privileges
  • return types
  • returning values
  • row-type data
  • specific name
  • SQL expressions
  • syntax error
  • SYSPROCPLAN
  • system catalog entries
  • text of
  • TRACE statement
  • updating nontriggering columns
  • uses
  • variables, scope of
  • WHILE loop
  • writing
• SQL
  • application languages
  • Application Programming Interfaces
  • compliance of statements with ANSI standard
  • cursor
  • description of
  • difference between Informix syntax and ANSI standard
  • dynamic statements
  • error handling
  • history
  • Informix SQL and ANSI SQL
  • interactive use
  • standardization
  • static embedding
• SQL code
• SQL Communications Area (SQLCA)
  • altered by end of transaction
  • description of
  • inserting rows
• SQL statement cache
• SQLCODE
  • end of data
  • negative values
• SQLCODE field
  • after opening cursor
  • and FLUSH operation
  • description of
  • end of data on SELECT only
  • end of data signalled
  • set by DELETE statement
  • set by PUT statement
• SQLERRD array
  • count of deleted rows
  • count of inserted rows
  • count of rows
  • description of
  • syntax of naming
• SQLERRM character string
• SQLSTATE, problem values
• SQLSTATE values
• SQLSTATE variable
  • in non-ANSI-compliant databases
  • using with a cursor
• SQLWARN array
  • description of
  • syntax of naming
  • with PREPARE
• Standard deviation, aggregate function
• START VIOLATIONS TABLE
• Statement block
• Statement cache, SQL
• Static SQL
• STDEV function, as aggregate function
• Stored procedure language.
  • See also SPL.
• Stored routine, general programming
• stores_demo database
• Subquery
  • ALL keyword
  • ANY keyword
  • correlated (1), (2), (3)
  • in DELETE statement (1), (2)
  • in select list
  • in SELECT statement
  • in UPDATE statement
    • with SET clause
  • in WHERE clause
  • single-valued
• Subscripting
  • in a WHERE clause
  • SPL variables
• SUBSTR function, as string manipulation function
• Substring (1), (2)
• SUBSTRING function, as string manipulation function
• SUM function, as aggregate function
• superstores_demo database
• Supertable
  • deleting from
  • in a table hierarchy
  • inserting into
  • selecting from
  • using an alias
• Syntax diagrams
  • conventions for
  • keywords in
  • reading in a screen reader
  • variables in
• Syntax segment
• sysprocbody, system catalog table
• SYSPROCPLAN
  • SPL routine
• System catalog
  • privileges in
  • querying
  • sysprocbody
  • systabauth
• System descriptor area
• System requirements
  • database
  • software

• Table
  • description of
  • hierarchy
  • in relational model
  • loading data
    • with external tables
    • with onload utility
  • lock
  • logging
  • nonlogging
  • not in the current database
  • operations on a
• Table hierarchy
  • triggers in
  • UPDATE statement
• TABLE keyword, in lock mode
• Temporary table
  • and active set of cursor
  • assigning column names
  • example
• TEXT data type
  • restrictions
    • with GROUP BY
  • using LENGTH function on
  • with relational expressions
• Time function
  • description of
  • use in SELECT
• TIME function
  • DAY and CURRENT
  • WEEKDAY
  • YEAR
• TO_CHAR function, as conversion function
• TO_DATE function, as conversion function
• TOC Notes
• TODAY function, in constant expression (1), (2)
• TRACE statement
  • debugging an SPL routine
  • output
• Transaction
  • description of
  • end of
  • example with DELETE
  • locks held to end of
  • locks released at end of
  • logging
  • use signalled in SQLWARN
• Transaction logging
  • contents of log
  • description of
  • XPS
• Trigger
  • creating
  • definition of
  • in a table hierarchy
  • INSTEAD OF
  • name assigning
  • re-entrant
  • select
    • defining on a table hierarchy
    • description of
    • restrictions on execution
  • when to use
• Trigger action
  • definition of
  • REFERENCING clause
• Trigger event
  • definition of
  • example of
• Triggered action
  • BEFORE and AFTER
  • FOR EACH ROW
  • generating an error message
  • in relation to triggering statement
  • SELECT statements
  • statements
  • tracing
  • using
  • using SPL routines
  • WHEN condition
• TRUNCATE TABLE statement
• Truncation, signalled in SQLWARN
• Typed table
  • definition of
  • inserting rows
  • selecting from
• Typographical conventions

• UNION keyword, in set operations
• UNION operator, display labels with
• Union set operation
• UNIQUE keyword, in SELECT statement
• Unnamed row type, in VALUES clause
• untyped
• Update cursor
• Update cursor, definition of
• UPDATE keyword
• Update locks, retaining
• UPDATE statement
  • and end of data
  • collection data types
  • description of (1), (2)
  • embedded
  • failures
  • lock mode
  • number of rows
  • preparing
  • restrictions on subqueries
  • SET clause
  • smart large objects
  • using a join to update a column
  • WHERE clause
  • with a supertable
  • with row data types
  • with uniform values
• UPPER function, as string manipulation function
• USER function, in expression
• Users, types of
• Using the GROUP BY and HAVING Clauses
• Utility program
  • onload
  • onunload

• VALUES clause
  • in INSERT statement
  • legal values
  • NULL values
  • restrictions
  • selected columns
• VARCHAR data type, using LENGTH function on
• Variable
  • defining and using in SPL routine
  • scope in SPL routine
  • with same name as a keyword
• Variables, in syntax diagrams
• VARIANCE function, as aggregate function
• variant SPL function
• Version number, returned by DBINFO function
• View
  • definition of
  • deleting in a
  • inserting into a
  • INSTEAD OF trigger on a
  • updating in a
• Violation detection (1), (2)
• Violations table
  • assigning a name
  • description of (1), (2)
  • example of privileges
  • examples
  • examples of starting
  • starting
• Visual disabilities
  • reading syntax diagrams

• Warning, with SPL routine at compile time
• WEEKDAY function
  • as time function (1), (2)
  • using
• WHERE clause
  • Boolean expression in
  • comparison condition
  • date-oriented functions in
  • description of
  • equal sign relational operator
  • host variables in
  • in DELETE
  • in UPDATE statement
  • less-than relational operator
  • not-equal relational operator
  • relational operators
  • selecting a range of characters
  • subqueries in (1), (2)
  • wildcard comparisons
  • with NOT keyword
  • with OR keyword
• WHERE CURRENT OF clause
  • in DELETE statement
  • in UPDATE statement
• WHERE keyword
  • null data tests
  • range of values
• Wildcard, using single character
• Wildcard character
  • asterisk
  • protecting
• Wildcard comparison in WHERE clause
• WITH clause, in SPL function
• WITH HOLD keywords, declaring a hold cursor
• WITH LISTING IN clause, use in SPL routine

• YEAR function
  • as time function
  • using