Index
A
- abs() built-in function 2-8
- acos() built-in function 2-8
- Aggregate function
- definition of 1-9, 2-10
- for an opaque type 5-8, 5-22
- ALTER TABLE statement 5-28
- ANSI compliance
- icon Intro-8
- level Intro-11
- Arithmetic operator
- description of 2-5
- for an opaque type 5-20
- asin() built-in function 2-8
- assign() support function
- description of 5-6, 6-19
- for smart large objects 6-22
- summary of 6-4
- atan2() built-in function 2-8
- atan() built-in function 2-8
B
- B-tree. See Generic B-tree.
- Built-in data type 1-13
- description of 1-5
- Built-in function
- definition of 1-9, 2-8
- for an opaque type 5-7, 5-21
C
- Cast
- by a support function 5-29
- by support functions 5-17
- CAST AS keywords 3-6, 3-7
- casting function 3-9
- definition of 1-10, 3-3
- dropping 3-13
- explicit. See Explicit cast.
- extending for existing data types 1-12
- extending for new data types 1-17
- implicit. See Implicit cast.
- operator 3-6, 3-7
- straight 3-8
- system-defined 3-3, 3-8, 3-13
- types of 3-3
- user-defined. See User-defined cast.
- See also User-defined cast.
- CAST AS keywords 3-6, 3-7
- Cast (::) operator 3-6, 3-7
- Casting function 3-9, 5-8
- character_length() built-in function 2-8
- char_length() built-in function 2-8
- CLIENT_LOCALE environment variable 6-24
- Comment icons Intro-7
- compare() support function 5-22, 6-22
- description of 5-6
- summary of 6-5
- uses of 5-24
- Complex data type 1-7
- Compliance
- icons Intro-8
- with industry standards Intro-11
- concat() function 2-6
- cos() built-in function 2-8
- CREATE CAST statement 5-17, 5-18, 5-25
- EXPLICIT keyword 3-7
- IMPLICIT keyword 3-6
- WITH clause 3-9
- CREATE DISTINCT TYPE statement 1-15
- CREATE FUNCTION statement 1-11, 1-16, 2-10, 5-15, 5-19, 5-25
- CREATE INDEX statement
- built-in secondary access method 4-5
- default operator class 4-8, 4-10
- user-defined secondary access method 4-6
- USING clause 4-6, 4-8, 4-10
- CREATE OPAQUE TYPE statement 1-14
- ALIGNMENT modifier 5-12
- CANNOTHASH modifier 5-23
- INTERNALLENGTH keyword 5-10
- MAXLEN modifier 5-11, 5-13
- registering the opaque type 5-14
- CREATE PROCEDURE statement 1-11, 1-16, 2-10, 5-25
- CREATE TABLE statement 5-18
- current() built-in function 2-9
D
- Data type
- built-in 1-5
- complex 1-7
- creating 1-12
- DataBlade-module 1-16
- definition 1-4
- extended 1-12
- extending existing 1-11
- fundamental 1-13
- named row type 1-15
- opaque. See Opaque data type.
- user-defined 1-12
- DataBlade API data type
- mi_float 5-9
- mi_impexp 6-15
- mi_impexpbin 6-17
- mi_integer 5-9
- mi_lvarchar 6-6
- mi_real 5-13
- mi_sendrecv 6-11
- mi_unsigned_integer 5-12
- mi_unsigned_smallint 5-12
- DataBlade-module data types 1-16
- dbaccessdemo7 script Intro-5
- dbservername() built-in function 2-9
- DB_LOCALE environment variable 6-24
- Default locale Intro-4
- Demonstration database Intro-5
- destroy() support function
- description of 5-6, 6-20
- for smart large objects 6-22
- summary of 6-4
- Distinct data type
- casts for 3-4, 3-8
- definition of 1-14
- divide() function 2-5
- Documentation conventions
- icon Intro-7
- typographical Intro-6
- Documentation notes Intro-10
- Documentation, types of
- documentation notes Intro-10
- error message files Intro-10
- machine notes Intro-10
- on-line manuals Intro-9
- printed manuals Intro-9
- release notes Intro-10
- DROP CAST statement 3-13, 5-29
- DROP FUNCTION statement 5-29
- DROP OPCLASS statement 4-27
- DROP ROUTINE function 5-29
- DROP TYPE statement 5-29
E
- End-user routine
- definition of 1-9, 2-10
- end-user function 2-10
- end-user procedure 2-10
- for an opaque data type 5-8, 5-25
- privileges on 2-10, 2-11, 5-25
- en_us.8859-1 locale Intro-4
- equal() function 2-6, 4-8, 5-23
- equal() support function 5-22
- Error message files Intro-10
- Explicit cast 3-7
- Export support function
- as casting function 5-17
- description of 5-6, 6-16
- for smart large objects 6-22
- parameter type 5-16
- return type 5-16
- summary of 6-4
- Exportbinary support function
- as casting function 5-17
- description of 5-6, 6-18
- for smart large objects 6-22
- parameter type 5-16
- return type 5-16
- summary of 6-4
- exp() built-in function 2-8
- Extended data type 1-12, 5-15
- Extended identifier 5-15
- extend() built-in function 2-9
F
- Feature icons Intro-8
- Features, product Intro-5
- Functional index 4-4
- Fundamental data type 1-13
G
- Generic B-tree
- default operator class 4-7, 4-12
- description of 4-4
- extending 4-12, 4-20
- new operator class 4-20
- strategy functions 4-8
- support functions 4-8
- Global Language Support (GLS) Intro-4
- GRANT statement
- Execute privilege 2-10, 2-11, 5-19
- Resource privilege 4-19, 5-15
- Usage privilege 5-18
- greaterthanorequal() function 2-6, 4-8
- greaterthan() function 2-6, 4-8
H
- hex() built-in function 2-8
I
- Icons
- comment Intro-7
- compliance Intro-8
- feature Intro-8
- product Intro-8
- IMPEXP data type
- casting from 5-17
- casting to 5-17
- description of 6-15
- parameter in import function 5-16
- return value in export function 5-16
- IMPEXPBIN data type
- casting from 5-17
- casting to 5-17
- description of 6-17
- parameter in importbinary function 5-16
- return value in exportbinary function 5-16
- Implicit cast 3-6
- Import support function
- as casting function 5-17
- description of 5-6, 6-16
- for smart large objects 6-22
- parameter type 5-16
- return type 5-16
- summary of 6-4
- Importbinary support function
- as casting function 5-17
- description of 5-6, 6-18
- for smart large objects 6-22
- parameter type 5-16
- return type 5-16
- summary of 6-4
- IN operator 5-23
- Index 4-4
- See also Generic B-tree; R-tree index; Secondary access method.
- Industry standards, compliance with Intro-11
- Informix GLS API 6-24
- INFORMIXDIR/bin directory Intro-5
- Input support function
- as casting function 3-10, 3-12, 5-17
- description of 5-5, 6-6
- locale-sensitive data 6-24
- parameter type 5-16
- return type 5-16
- summary of 6-3
- ISO 8859-1 code set Intro-4
L
- length() built-in function 2-8
- lessthanorequal() function 2-6, 4-8
- lessthan() function 2-6, 4-8
- like() function 2-6
- Locale Intro-4
- logn() built-in function 2-8
- log() built-in function 2-8
- lohandles() support function
- description of 5-6
- summary of 6-5
- LVARCHAR data type
- casting from 5-17
- casting to 5-17
- definition of 6-6
- locale-sensitive data 6-24
- parameter to input function 5-16
- return value of output function 5-16
M
- Machine notes Intro-10
- Major features Intro-5
- matches() function 2-6
- minus() function 2-5
- mi_impexp data type
- definition of 6-15
- mi_impexpbin data type
- definition of 6-17
- mi_lvarchar data type
- definition of 6-6
- locale-sensitive data 6-24
- mi_real data type 5-13
- mi_sendrecv data type
- definition of 6-11
- locale-sensitive data 6-25
- mi_unsigned_integer data type 5-12
- mi_unsigned_smallint data type 5-12
- mod() built-in function 2-8
N
- Named row type 1-8, 1-15, 3-4
- negate() function 2-5
- notequal() function 2-6
O
- octet_length() built-in function 2-8
- On-line manuals Intro-9
- Opaque data type
- as parameter 5-13
- bit-hashable 5-23, 5-24, 6-23
- casts for 3-4
- comparing 5-22, 6-22
- constraints on 5-23
- definition of 1-13, 5-3
- dropping 5-28
- extended identifier 5-15
- fixed-length 5-4, 5-10
- in sysxtdtypeauth table 5-19
- indexes on 5-25
- internal structure 5-4
- locale-specific data 6-23
- memory alignment of 5-11
- pass by reference 6-7, 6-9
- pass by value 6-7, 6-9
- privileges 5-18, 5-28
- registering 5-14
- structure size 5-10
- system catalog table 5-19
- varying-length 5-11
- Operation
- aggregate function 2-10
- built-in function 2-8
- casting function. See Cast.
- definition of 1-9, 2-4
- end-user routine 2-10
- extending for existing data types 1-11, 2-11
- extending for new data types 1-16
- operator 2-4
- operator function 2-4
- Operator
- arithmetic 2-5
- definition of 1-9, 2-4
- relational 2-6
- text 2-6
- Operator binding 2-4
- Operator class
- definition of 1-9, 4-3, 4-6
- dropping 4-27
- extending for existing data types 1-11
- extending for new data types 1-17
- privileges on 4-19
- Operator function
- arithmetic 5-20
- definition of 1-9, 2-4
- for an opaque data type 5-20
- for an opaque type 5-7
- relational 2-6, 5-23
- text 2-6, 5-20
- Output support function
- as casting function 3-10, 3-12, 5-17
- description of 5-5, 6-8
- locale-sensitive data 6-24
- parameter type 5-16
- return type 5-16
- summary of 6-3
P
- plus() function 2-5
- positive() function 2-5
- pow() built-in function 2-8
- Printed manuals Intro-9
- Privilege
- on a support function 5-19, 5-29
- on an end-user routine 2-10, 2-11, 5-25
- on an opaque type 5-15, 5-18, 5-28
- on an operator class 4-19
- routine-level 5-19
- type-level 5-19
- Product icons Intro-8
R
- Receive support function
- as casting function 5-17
- description of 5-5, 6-11
- locale-sensitive data 6-25
- parameter type 5-16
- return type 5-16
- summary of 6-4
- Relational operator
- description of 2-6
- for an opaque type 5-23
- Release notes Intro-10
- REVOKE statement
- Execute privilege 5-29
- Usage privilege 5-28
- root() built-in function 2-8
- round() built-in function 2-8
- Routine identifier 5-16
- Routine overloading 2-3, 2-11, 4-11
- Routine resolution 2-3, 2-11, 4-11
- R-tree index 4-5
- default operator class 4-9, 4-18
- extending 4-18, 4-24
- strategy functions 4-10
- support functions 4-10
S
- Secondary access method
- defined by server 4-4
- defining new operator classes 4-24
- definition of 4-4
- user-defined 4-6
- SELECT statement
- DISTINCT keyword 5-24, 6-22
- GROUP BY clause 5-23
- ORDER BY clause 5-24, 6-22
- UNION keyword 5-24, 6-22
- UNIQUE keyword 5-24, 6-22
- Send support function
- as casting function 5-17
- description of 5-6, 6-13
- locale-sensitive data 6-25
- parameter type 5-16
- return type 5-16
- summary of 6-4
- SENDRECV data type
- casting from 5-17
- casting to 5-17
- definition of 6-11
- locale-sensitive data 6-25
- parameter in receive function 5-16
- return value in send function 5-16
- SERVER_LOCALE environment variable 6-24
- sin() built-in function 2-8
- sitename() built-in function 2-9
- Smart large object
- in opaque type 5-5, 6-15
- Software dependencies Intro-4
- SQL data type
- IMPEXP 6-15
- IMPEXPBIN 6-17
- LVARCHAR 6-6
- SENDRECV 6-11
- SQL-invoked function
- aggregate functions 2-10
- built-in functions 2-8
- casting functions 3-9
- definition of 1-16, 2-3
- end-user routines 2-10
- opaque data types 5-19
- operator functions 2-4
- sqrt() built-in function 2-8
- stores7 database Intro-5
- Strategy function
- description for secondary access method 4-7
- description of 4-7
- Support function
- as casts 5-17
- assign() 5-6, 6-4
- compare() 5-6, 6-5
- description for secondary access method 4-7
- description of 4-7, 5-13
- destroy() 5-6, 6-4
- dropping 5-29
- export 5-6, 6-4
- exportbinary 5-6, 6-4
- import 5-6, 6-4
- importbinary 5-6, 6-4
- Informix GLS API 6-24
- input 5-5, 6-3
- lohandles() 5-6, 6-5
- output 5-5, 6-3
- privileges 5-19, 5-29
- receive 5-5, 6-4
- registering 5-15
- routine identifier 5-16
- send 5-6, 6-4
- that support bulk copy 6-14
- sysams system catalog table 4-24
- syscasts system catalog table 3-5, 3-13, 5-18, 5-29
- sysopclasses system catalog table 4-27
- sysprocauth system catalog table 5-19, 5-29
- sysprocedure system catalog table 5-29
- sysprocedures system catalog table 5-16
- System catalog
- sysams 4-24
- syscasts 3-5, 5-18
- sysprocauth 5-19
- sysprocedures 5-16
- sysxtdtypeauth 1-12, 5-19
- sysxtdtypes 1-12, 5-15
- System-defined cast 3-3, 3-8, 3-13
- sysxtdtypeauth system catalog table 1-12, 5-19, 5-28
- sysxtdtypes system catalog table 1-12, 5-15, 5-29
T
- tan() built-in function 2-8
- Text operator
- description of 2-6
- for an opaque type 5-20
- times() function 2-5
- today() built-in function 2-9
- trunc() built-in function 2-8
U
- User-defined cast
- casting function 3-9
- creating 3-5
- definition of 3-3
- dropping 3-13
- explicit. See Explicit cast.
- implicit. See Implicit cast.
- kinds of 3-6
- straight 3-8
- See also Cast.
- User-defined data type 1-12
- user() built-in function 2-8
X
- X/Open compliance
- level Intro-11
|
