Index

• Accessibility
  • dotted decimal format of syntax diagrams
  • syntax diagrams, reading in a screen reader
• Active set
• Aggregate function
  • built-in (1), (2)
  • definition
  • dropping
  • extending built-in functions
  • for an opaque type
  • implicit execution
  • overloading
  • overloading operators
  • setup argument
• Allocating memory, iterator function
• ALTER FUNCTION statement (1), (2), (3)
• ALTER PROCEDURE statement (1), (2), (3)
• ALTER ROUTINE statement (1), (2), (3)
• ALTER TABLE statement
• ANSI compliance
  • routine signature
  • user-defined types
• Argument.
  • See also Routine argument.
• Arithmetic operator
  • description
  • for an opaque type
• assign() support function (1), (2)
  • description of

• B-tree.
  • See also Generic B-tree.
• BETWEEN operator, with compare()
• Boldface type
• Built-in aggregate (1), (2)
• Built-in cast (1), (2), (3)
• Built-in data type
  • defined
  • routine resolution with
• Built-in function
  • defined (1), (2)
  • for an opaque type (1), (2)
  • overloadable
  • that you can overload
  • that you cannot overload
• Bulk copies

• C iterator function example
• CALL statement (1), (2)
• CallableStatement interface
• Cast
  • See also User-defined cast.
  • built-in (1), (2), (3)
  • by a support function (1), (2)
  • CAST AS keywords (1), (2)
  • definition
  • dropping
  • explicit
  • function, end-user routines
  • function, user-defined
  • implicit
  • not allowed
  • operator (1), (2)
  • routine resolution with
  • straight
• Cast (::) operator (1), (2)
• CAST AS keywords (1), (2)
• CLASS routine modifier (1), (2), (3), (4), (5), (6), (7)
  • See also Virtual processor classes., VPCLASS configuration parameter.
• CLIENT_LOCALE environment variable
• Code, sample, conventions for
• Code set, ISO 8859-1
• Coding standards
• Collation order
• Collection data type
  • aggregates
  • casts
  • definition
  • in type hierarchy
  • routine resolution (1), (2)
• Columns, virtual
• Command-line conventions
  • how to read
  • sample diagram
• compare() function
• compare() support function
  • description of
  • sorting data
  • uses
  • with BETWEEN operator
• Complex data type
• Compliance
  • with industry standards
• concat() function
• Configuration parameter
  • STACKSIZE
  • VPCLASS (1), (2)
• Constraint, on opaque data type
• Contact information
• Conventions
  • command-line
  • documentation
  • sample-code
  • syntax diagrams
  • syntax notation
  • typographical
• Copying data
• Cost function
• COSTFUNC routine modifier
• CPU virtual processor (CPU VP)
  • adding
  • definition
  • dropping
• CREATE CAST statement
  • EXPLICIT keyword
  • IMPLICIT keyword
  • privileges
  • using
  • WITH clause
• CREATE DISTINCT TYPE statement
• CREATE FUNCTION statement
  • assigning specific name
  • choosing a user-defined VP
  • creating routine signature
  • DBA keyword (1), (2), (3)
  • privileges
  • privileges required
  • registering a function (1), (2), (3), (4)
  • registering an external function (1), (2)
  • registering an iterator function
  • registering an SPL function
  • registering arguments
  • registering return value
  • RETURNING clause
  • SPECIFIC keyword
  • specifying stack size
  • using
  • WITH clause (1), (2)
• CREATE INDEX statement
  • built-in secondary-access method
  • compare() function
  • default operator class
  • USING clause
• CREATE OPAQUE TYPE statement
  • ALIGNMENT modifier
  • CANNOTHASH modifier
  • INTERNALLENGTH keyword
  • MAXLEN modifier (1), (2)
  • registering the opaque type
• CREATE OPCLASS statement
• CREATE PROCEDURE statement
  • assigning specific name
  • choosing a user-defined VP
  • creating routine signature
  • DBA keyword (1), (2), (3)
  • privileges required
  • registering a procedure
  • registering a user-defined procedure (1), (2)
  • registering arguments
  • registering return value
  • SPECIFIC keyword
  • specifying stack size
  • WITH clause (1), (2)
• CREATE TABLE statement (1), (2)
• Cursor function

• Data type
  • built-in (1), (2)
  • collection.
    • See also Collection data type.
  • complex
  • DataBlade module
  • definition
  • extended
  • named row type.
    • See also Named row type.
  • opaque.
    • See also Opaque data type.
• Database-level privilege
• DataBlade API data type
  • mi_float
  • mi_integer
  • mi_lvarchar
  • mi_real
  • mi_unsigned_integer
  • mi_unsigned_smallint
• DataBlade API memory management
• DataBlade module data types
• DB_LOCALE environment variable
• DBA privilege (1), (2)
• deepcopy() support function (1), (2)
• Default locale
• defined
• Demonstration databases
• destroy() support function (1), (2), (3)
  • smart large objects
• Disabilities, visual
  • reading syntax diagrams
• Distinct data type
  • casts for (1), (2)
  • description of (1), (2)
  • routine resolution with
• divide() function
• Documentation, types of
  • machine notes
  • online manuals
  • printed manuals
• Documentation conventions
• Documentation Notes
• Documentation set of all manuals
• Dotted decimal format of syntax diagrams
• DROP AGGREGATE statement
• DROP CAST statement (1), (2)
• DROP FUNCTION statement (1), (2), (3), (4), (5)
• DROP OPCLASS statement
• DROP PROCEDURE statement (1), (2), (3)
• DROP ROUTINE statement (1), (2), (3), (4), (5), (6)
• DROP TYPE statement

• en_us.8859-1 locale
• End-user routine
  • definition of
  • for an opaque data type
• Environment variable, NODEFDAC
• Environment variables
• equal() function (1), (2), (3), (4), (5), (6)
• Error messages
• EVP.
  • See also User-defined virtual processor.
• Example, using CLASS
• EXECUTE FUNCTION statement
  • invoking a function
  • OUT parameters with
  • SPL statements
• Execute privilege
  • DBA keyword
  • granting
  • on a routine
• EXECUTE PROCEDURE statement
  • invoking a user-defined procedure
  • SPL statements
• Execution plan (1), (2), (3)
• EXP VP.
  • See also User-defined virtual processor.
• Explicit cast
• Export support function
  • as cast function
  • description of (1), (2)
  • example
  • for smart large objects
  • lotofile()
  • parameter type
  • return type
  • summary of
• Exportbinary support function
  • as cast function
  • description of (1), (2)
  • example
  • for smart large objects
  • parameter type
  • return type
  • summary of
• expression return name
• Extended data type
• Extended identifier
• Extension virtual processor.
  • See also User-defined virtual processor.
• External files
• External routine
  • definition of
  • description of
  • designing
  • executing
  • registering
  • return values
  • routine modifiers
  • stack usage

• filetoblob() function
• filetoclob() function
• Fixed and Known Defects File
• FROM clause, iterator function
• Functional index
  • not on smart large object

• Generic B-tree
  • default operator class (1), (2)
  • extending (1), (2)
  • new operator class
  • strategy functions
• Global Language Support (GLS)
  • API
  • description of
• GRANT statement
  • example using signature (1), (2)
  • example using specific name
  • Execute privilege (1), (2), (3)
  • Resource privilege (1), (2)
  • Usage privilege
  • when granting privileges to register UDRs
• greaterthan() function (1), (2), (3)
• greaterthanorequal() function (1), (2), (3), (4)

• HANDLESNULLS modifier
  • C routine
    • description
  • Java routine
  • statcollect() function
• Help
• High-Availability Data Replication (HDR) (1), (2), (3), (4)

• IBM Informix Developers Zone
• IBM Informix GLS API
• IMPEXP data type
  • casting from
  • casting to
  • description of
  • return value
• IMPEXPBIN data type
  • casting
  • description of
  • return value
• Implicit cast
• Import function
  • filetoclob(), filetoblob()
• Import support function
  • as cast function
  • description of (1), (2)
  • for smart large objects
  • parameter type
  • return type
  • summary of
• Importbinary support function
  • as cast function
  • description of (1), (2)
  • for smart large objects
  • parameter type
  • return type
  • summary of
• IN operator
• IN parameters
• Index (1), (2), (3)
  • See also Generic B-tree., R-tree index., Secondary-access method.
  • description of
• Industry standards, compliance with
• Informix Dynamic Server documentation set
• informix user
• informix user account
• INFORMIXDIR/bin directory
• INOUT parameter (1), (2), (3)
• Input support function
  • as cast function (1), (2), (3)
  • description of
  • example
  • locale-sensitive data
  • parameter type
  • return type
  • summary of
  • tasks
• Installation Guides
• INTERNAL routine modifier
• ISO 8859-1 code set
• Iterator function
  • active set
  • creating (1), (2)
  • definition of
  • invoking (1), (2)
  • registering (1), (2)
  • writing
• Iterator functions
  • restrictions
• ITERATOR routine modifier (1), (2), (3), (4)

• Java iterator function example
• JDBC CallableStatement interface

• Keywords
  • in syntax diagrams

• Language
  • external (1), (2)
  • SPL
• lessthan() function (1), (2), (3)
• lessthanorequal() function (1), (2), (3)
• like() function
• Locale
  • default
  • en_us.8859-1
• lohandles() function
  • summary of
• lotofile() function
• LVARCHAR data type
  • casting
  • locale-sensitive data
  • parameter to input function

• Machine notes
• Mapping
  • between SQL and Java
  • creating
• matches() function
• Memory
  • iterator function
• Memory allocation
  • functions
• Memory objects
• mi_fp_request() routine
• mi_fp_setisdone() routine (1), (2)
• mi_lvarchar data type
  • defined
  • locale-sensitive data
• mi_real data type
• mi_sendrecv data type
  • locale-sensitive data
• mi_system( ) function (1), (2)
• mi_unsigned_integer data type
• mi_unsigned_smallint data type
• minus() function
• Modal routines
• Monitoring
  • stack size
• Multirepresentational data
  • defined
  • not hashable

• Name space
  • DataBlade-module objects
• Named parameters
• Named row data type
  • defined
  • routine-resolution precedence
  • type hierarchy (1), (2)
• Named row type
  • user-defined cast
• Naming
  • return parameters
• negate() operator function
• Negator function (1), (2)
• NEGATOR keyword routine modifier (1), (2)
• NODEFDAC environment variable
• Noncursor function
• Nonvariant function
• NOT VARIANT routine modifier
• notequal() function
• Null value
  • See also HANDLESNULL modifier.
  • aggregate initialization
  • as wildcard argument
  • in statcollect() function
  • in support functions

• Online help
• Online manuals
• Online notes (1), (2)
• onmode utility
• onstat utility (1), (2), (3)
• Opaque data type
  • as parameter
  • casts for
  • comparing
  • constraints on
  • defined (1), (2), (3)
  • dropping
  • extended identifier
  • external representation
  • fixed-length (1), (2)
  • in sysxtdtypeauth table (1), (2)
  • indexes on
  • internal structure
  • locale-specific data
  • memory alignment of
  • pass by value
  • privileges
  • registering
  • structure size
  • system catalog table (1), (2)
  • varying-length
• Operating system
• Operation
  • built-in function
  • cast function.
    • See also Cast.
  • operator function
• Operator
  • arithmetic
  • binding (1), (2), (3)
  • defined (1), (2)
  • relational
  • text
• Operator class
  • creating
  • defined (1), (2), (3), (4)
  • dropping
  • privileges on
  • use for
• Operator function
  • defined (1), (2)
  • opaque data type (1), (2)
  • relational (1), (2)
  • text
• Optimization
  • functions
• Optimization level
• OUT parameter (1), (2)
• Output support function
  • as cast function (1), (2), (3)
  • defined
  • example
  • locale-sensitive data
  • parameter type
  • return type
  • summary of
  • tasks
• Owner
  • See also Routine owner.

• P-code (1), (2)
  • See also SPL p-code.
  • defined
  • size of
  • SPL routine
• Parallel database query (1), (2)
• Parallel UDRs
  • defined
  • enabling
  • execution of
  • GROUP BY
  • INSERT
  • iterator functions
  • joins
  • scans (1), (2)
  • SELECT list (1), (2)
  • sorts
  • when use
• PARALLELIZABLE routine modifier
• Parameter
  • INOUT (1), (2), (3)
  • OUT
  • return
• Parameter.
  • See also Routine parameter.
• PERCALL_COST routine modifier
• Persistent external files
• Persistent memory objects
• Platform portability
• plus() function
• POINTER data type
• Polymorphism (1), (2)
• positive() function
• Pound (#) sign
  • SLV indicator
• Primary key
  • using opaque UDT
• Printed manuals
• Privilege
  • database-level
  • DBA (1), (2)
  • Execute (1), (2)
  • on a support function
  • opaque type (1), (2)
  • operator class
  • Resource
  • routine-level (1), (2), (3)
  • support function
  • type-level
  • user-defined routine

• Query optimizer (1), (2), (3)
• Query parser (1), (2)
• Query plan (1), (2), (3)

• R-tree index
  • default operator class
  • uses of
• Receive support function
  • cast function
  • defined
  • example
  • locale-sensitive data
  • parameter type
  • return type
• Registering a user-defined routine
  • privileges
  • steps
• Relational operator
  • defined
  • opaque type
• Release Notes
• Resource privilege
• Restrictions
  • iterator function
• Result set
  • iterator function
• Return parameters
  • naming
• Return value
  • See also Routine return value.
• RETURN WITH RESUME statement
• REVOKE statement
  • Execute privilege (1), (2)
  • Usage privilege (1), (2)
  • using specific name
  • when granting privileges to register UDRs
• Routine
• Routine argument
  • defined
  • distinct data type
  • in routine resolution
  • in routine-state space
  • modal
  • named row type as
  • not matching parameter data type
  • registering
  • wildcard
• Routine identifier
  • defined
• Routine-level privilege (1), (2)
• Routine manager
  • creating a routine sequence
  • loading a shared-object file
  • managing routine execution
  • role of
  • stack space and
• Routine modifier
  • CLASS (1), (2), (3), (4), (5)
  • COSTFUNC
  • external routine
  • HANDLESNULLS (1), (2)
  • INTERNAL
  • ITERATOR (1), (2), (3), (4)
  • NEGATOR (1), (2)
  • NOT VARIANT
  • PARALLELIZABLE
  • PERCALL_COST
  • SELCONST
  • SELFUNC
  • specifying
  • STACK (1), (2)
  • VARIANT (1), (2)
• Routine name
  • ANSI-compliance
  • candidate routines
  • choosing
  • component of routine signature
  • overloaded (1), (2)
  • registering
  • specific.
    • See also Specific routine name.
• Routine overloading
  • aggregate functions
  • assigning specific routine name
  • built-in functions
  • built-in SQL functions
  • dedfined
  • defined (1), (2)
  • in operator binding
  • invoking overloaded routine
  • optical functions
  • status functions
  • using (1), (2)
• Routine owner
  • ANSI-compliant database
  • component of routine signature
  • database not ANSI compliant
  • in specific routine name
  • registering
• Routine parameter
  • component of signature
  • overloaded
  • registering
• Routine resolution
  • candidate list (1), (2)
  • defined (1), (2)
  • effect of inheritance
  • effect of null value argument
  • order of arguments
  • precedence (1), (2)
  • purpose
  • type hierarchy
  • understanding
• Routine return value
  • in routine-state space
  • nonvariant
  • using
• Routine sequence
• Routine signature
  • ANSI-compliance
  • defined
  • in routine resolution (1), (2)
  • registering
  • uniqueness
• Routine-state space
• Routine type (1), (2)
• Row type
  • named
    • See also Named row type.
• Runtime
  • setting collation order

• Sample-code conventions
• Scans
  • parallel
• Screen reader
  • reading syntax diagrams
• Secondary-access method
  • defined
  • defined by database server
  • defining new operator classes
  • user-defined
• SELCONST routine modifier
• SELECT statement
  • BETWEEN operator
  • DISTINCT keyword (1), (2)
  • GROUP BY clause
  • ORDER BY clause (1), (2)
  • UNION keyword (1), (2)
  • UNIQUE keyword (1), (2)
• SELECT statement, iterator function
• Selectivity function
• SELFUNC routine modifier
• Send support function
  • as cast function
  • defined
  • example
  • locale-sensitive data
  • parameter type
  • return type
  • summary of
• SENDRECV data type
  • casting from
  • casting to
  • locale-sensitive data
  • return value in send function
• SERVER_LOCALE environment variable
• SET COLLATION statement
• SET EXPLAIN
  • parallel scans
  • serial scans
• SET OPTIMIZATION statement
• setUDTExtName
• Setup argument, aggregates
• Shared library
  • See also Shared-object file.
• Shared object file
  • loading
  • reloading
  • unloading (1), (2)
• Signature
  • See also Routine signature.
• SIGUSR1 signal
• SLV.
  • See also Statement-local variable.
• Smart large object (1), (2)
  • aggregates
  • not in functional index
• SPECIFIC keyword
• Specific routine name
  • assigning
  • defined
  • registering
• SPL iterator function example
• SPL procedure
• SPL routine
  • caching sysprocedures
  • default virtual-processor class
  • defined (1), (2)
  • dependency list (1), (2)
  • designing
  • executing
  • execution plan
  • FOREACH loop
  • invoking a UDR
  • optimization level
  • optimizing
  • p-code (1), (2)
  • registering
  • SPL cache
  • updating statistics
• SPL UDR, return parameters
• SQL code
• SQL data type
  • built-in
  • IMPEXP
  • IMPEXPBIN
  • in registration
  • POINTER
• SQL Explain output, iterator function
• SQL-invoked function
  • built-in functions
  • cast functions
  • definition of
  • opaque data types
  • operator functions
• SQL statement
  • execution plan (1), (2)
  • invoking a UDR
  • optimizing (1), (2), (3), (4)
  • parsing (1), (2)
  • query optimizer
  • query parser
  • query plan
  • specific name
  • statement-local variable
  • where invalid
• Stack
  • monitoring stack size
• STACK routine modifier (1), (2)
• Stack space
• STACKSIZE configuration parameter
• Statement-local variable
  • declaring
  • defined
  • OUT parameters and
  • referencing in function
  • scope of
• Statement-local variables
  • iterator functions
• Statistics function
• stores_demo database
• Strategy function
  • defined
  • for generic B-tree
• streamread() support function
  • as cast function
• streamwrite() support function
  • as cast function
• Structured Query Language
  • See also SQL statement.
• Subtype.
  • See also Named row type.
• superstores_demo database
• Supertype
  • See also Named row type.
• Support function
  • as casts
  • bulk copy
  • defined
  • dropping
  • export
  • exportbinary
  • for generic B-tree
  • IBM Informix GLS API
  • import
  • importbinary
  • input
  • lohandles()
  • naming
  • output
  • privileges
  • registering
  • routine identifier
  • send
  • summary
• Syntax diagrams
  • conventions for
  • keywords in
  • reading in a screen reader
  • variables in
• Syntax segment
• sysams system catalog table
• syscasts system catalog table (1), (2), (3), (4)
• syscolumns system catalog table
• sysindices system catalog table
• syslangauth system catalog table
• sysopclasses system catalog table
• sysprocauth system catalog table (1), (2), (3), (4), (5), (6)
• sysprocbody system catalog table (1), (2), (3), (4), (5)
• sysprocedures system catalog table
  • cached in memory
  • candidate routines
  • columns of
  • contents of
  • defined (1), (2)
  • I/O considerations
  • path column (1), (2)
  • UDR information
• sysprocplan system catalog table (1), (2), (3), (4), (5)
• sysroutinelangs system catalog table
• systables system catalog table
• System catalog table
  • isolating
  • sysams
  • syscasts (1), (2)
  • syscolumns
  • sysindices
  • syslangauth
  • sysprocauth (1), (2), (3), (4), (5)
  • sysprocbody (1), (2), (3), (4)
  • sysprocedures (1), (2), (3)
  • sysprocplan (1), (2), (3), (4), (5)
  • sysroutinelangs
  • systables
  • systrigbody
  • systriggers
  • sysxtdtypeauth (1), (2)
  • sysxtdtypes (1), (2)
• systrigbody system catalog table
• systriggers system catalog table
• sysxtdtypeauth system catalog table (1), (2), (3)
• sysxtdtypes system catalog table (1), (2), (3), (4)

• Text operator
  • defined
  • for an opaque type
• Thread
  • defined
  • insert (1), (2)
  • join
  • primary
  • scan (1), (2), (3), (4)
  • secondary
  • sort
  • sqlexec
• Thread-safe UDRs (1), (2)
• times() function
• TOC Notes
• Transport functions
• Triggered action statement
• Type hierarchy (1), (2), (3)
• Type inheritance
• Typographical conventions

• UDR
  • See also User-defined routine.
• UDREnv interface
• UDREnv.setSetIterationIsDone() method
• UNIX operating system
  • default locale
• Unnamed row type
  • aggregates
• update() support function (1), (2), (3)
• UPDATE STATISTICS statement (1), (2)
• User-defined aggregate
  • defined (1), (2)
  • dropping
  • parallel execution (1), (2)
• User-defined cast
  • See also Cast.
  • cast function
  • creating
  • definition of
  • dropping
  • implicit (1), (2)
  • kinds of
  • straight
• User-defined function
  • See also User-defined routine.
  • cursor
  • defined
  • invoking in an expression
  • invoking with CALL
  • iterator
  • negator
  • noncursor
  • nonvariant
  • variant
• User-defined procedure (1), (2)
  • See also User-defined routine.
  • invoking with CALL
  • registering
• User-defined procedure.
• User-defined routine
  • See also User-defined function
  • altering
  • argument.
    • See also Routine argument.
  • assigning privileges to
  • choosing a VP class
  • coding standards for
  • database-level privileges
  • DBA tasks on
  • default VP class
  • defined
  • designing
  • dropping (1), (2)
  • enabling parallel execution
  • executing (1), (2), (3), (4), (5)
  • executing across databases
  • HDR
  • invoking
  • loading
  • location of
  • managing
  • memory considerations
  • modal
  • naming
  • nonmodal
  • optimizing
  • overloaded.
    • See also Routine overloading.
  • parallelizable (1), (2)
  • performance considerations
  • privileges
  • registering
  • registration privileges
  • reloading
  • return value.
    • See also Routine return value.
  • returning a value
  • routine-level privileges
  • routine resolution
  • routine sequence for
  • routine-state space (1), (2)
  • signature.
    • See also Routine signature.
  • size maximum
  • tasks
  • unloading (1), (2)
  • updating statistics
  • user state
  • well-behaved (1), (2)
  • wildcard argument
• User-defined virtual processor
  • adding
  • dropping
• User state
  • SPL routine
• Users, types of

• Variables, in syntax diagrams
• Variant function
• VARIANT routine modifier (1), (2)
• Virtual processor
  • choosing for UDR
  • classes (1), (2)
  • CPU
  • defined
  • monitoring
  • setting number of
  • user-defined
  • using
  • VP classes
• Virtual table
  • iterator function
• Visual disabilities
  • reading syntax diagrams
• VP.
  • See also Virtual processor.
• VPCLASS configuration parameter (1), (2)

• Wildcard, argument for a routine
• Windows, default locale for