Master Index
Home Index Key

[ A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Symbols ]

I

-I preprocessor option, esqlc, 1-63, 1-53, 1-57
I18n abbreviation, gls_api, 1-4
Informix Guide to SQL: Syntax, organization of, sqls, 1-7
IBM CCSID code set,
437, gls, A-16, 1-43
819, gls, A-16, A-19, A-13
definition of, gls, 1-43
-icheck preprocessor option, esqlc, 1-63, 1-52, 1-43, 1-57
Icon conventions, dbdkug, Intro-7
Icons,
comment, sqlr, Intro-9, sqls, Intro-10, esqlc, Intro-8, sqlt, Intro-10, gls_api, Intro-7, dapi, Intro-7, gls, Intro-7, extend, Intro-7, udr, Intro-7
compliance, sqlr, Intro-10, sqls, Intro-12, extend, Intro-8, udr, Intro-8
feature, sqlr, Intro-10, sqls, Intro-11, esqlc, Intro-9, sqlt, Intro-10, gls_api, Intro-8, dapi, Intro-8, gls, Intro-8, extend, Intro-8, udr, Intro-7
platform, esqlc, Intro-9, gls_api, Intro-8, dapi, Intro-8, gls, Intro-8
product, sqls, Intro-11, extend, Intro-8, udr, Intro-7
syntax diagram, sqls, Intro-14
icons, dbdkug, Intro-7
.icp file extension, esqlc, 1-50
IDATA descriptor field, esqlc, 16-36, 15-8
IDATA field,
in X/Open programs, sqls, 1-709
syntax,
ILENGTH field, sqls, 1-433
with SET DESCRIPTOR, sqls, 1-709
Identifier, sqlr, Glossary-10, sqls, 1-967 to , gls, 3-10, 1-31
DELIMIDENT environment variable, sqls, 1-972
delimited, sqls, 1-969
example, sqls, 1-972
keywords as, sqls, 1-974
multibyte characters in, sqls, 1-972, 1-969
non-ASCII characters in, sqls, 1-972, 1-969
See also Delimited identifiers; SQL identifier.,
IDispatch interface, dbdkug, 7-6, 7-8
IDL (interface definitions language) files, dbdkug, B-2
.idx file extension, gls, 6-3
.iem file extension, gls, 2-17
IF statement,
syntax, sqls, 2-34
syntax and use, sqls, 2-34
with null values, sqls, 2-36
ifdef preprocessor directive, esqlc, 1-16, 1-12
ifndef preprocessor directive, esqlc, 1-16, 1-12
IFX_AUTOFREE environment variable, sqls, 1-682, 1-683, 1-678, esqlc, 14-25
client only, esqlc, 14-37
ifx_cl_card() library function, esqlc, 9-45
ifx_dececvt() library function, esqlc, 13-31, 13-25
ifx_decfcvt() library function, esqlc, 13-31, 13-25
IFX_DEFERRED_PREPARE environment variable, sqlr, 3-55, sqls, 1-700, esqlc, 14-32
client only, esqlc, 14-37
ifx_getcur_conn_name() library function, esqlc, 12-48
ifx_getenv() library function, esqlc, 1-103
ifx_getserial8() library function, esqlc, 5-10
ifx_getversion utility, esqlc, 13-13
IFX_GL_CASE_CONV_DST_BYTES macro, gls_api, 2-17, 4-186, 4-189
ifx_gl_case_conv_outbuflen() function, gls_api, 2-16, 2-40, 4-11
IFX_GL_CASE_CONV_SRC_BYTES macro, gls_api, 2-17, 4-186, 4-189
ifx_gl_conv_needed() function, gls_api, 2-21, 4-13, 2-24
ifx_gl_convert_date() function, gls_api, 3-10, 3-11, 4-15
ifx_gl_convert_datetime() function, gls_api, 3-10, 3-11, 4-24
ifx_gl_convert_money() function, gls_api, 3-10, 3-11, 4-35
ifx_gl_convert_number() function, gls_api, 4-40, 3-10, 3-11
ifx_gl_cv_mconv() function, gls_api, 4-45, 2-22, 2-24, 2-25
ifx_gl_cv_outbuflen() function, gls_api, 2-40, 2-22, 2-23, 2-24, 4-49
ifx_gl_cv_sb2sb_table() function, gls_api, 2-28, 4-51, 2-24
IFX_GL_EINVAL constant, gls_api, A-3, 2-43, 2-44
ifx_gl_format_date() function, gls_api, 4-53, 3-10, 3-12
ifx_gl_format_datetime() function, gls_api, 4-61, 3-10, 3-12
ifx_gl_format_money() function, gls_api, 4-71, 3-10, 3-12
ifx_gl_format_number() function, gls_api, 4-77, 3-10, 3-12
ifx_gl_getmb() function, gls_api, 4-83, 1-22
ifx_gl_init() function, gls_api, 1-18, 4-86, 1-21
ifx_gl_ismalnum() function, gls_api, 4-88, 2-13
ifx_gl_ismalpha() function, gls_api, 4-90, 2-13
ifx_gl_ismblank() function, gls_api, 4-93, 2-13
ifx_gl_ismcntrl() function, gls_api, 4-95, 2-13
ifx_gl_ismdigit() function, gls_api, 4-97, 2-13
ifx_gl_ismgraph() function, gls_api, 4-99, 2-13
ifx_gl_ismlower() function, gls_api, 4-101, 2-13
ifx_gl_ismprint() function, gls_api, 4-103, 2-13
ifx_gl_ismpunct() function, gls_api, 4-105, 2-13
ifx_gl_ismspace() function, gls_api, 4-107, 2-13
ifx_gl_ismupper() function, gls_api, 4-109, 2-13
ifx_gl_ismxdigit() function, gls_api, 4-111, 2-13
ifx_gl_iswalnum() function, gls_api, 4-113, 2-13
ifx_gl_iswalpha() function, gls_api, 4-115, 2-13
ifx_gl_iswblank() function, gls_api, 4-117, 2-13
ifx_gl_iswcntrl() function, gls_api, 4-119, 2-13
ifx_gl_iswdigit() function, gls_api, 4-121, 2-13
ifx_gl_iswgraph() function, gls_api, 4-123, 2-13
ifx_gl_iswlower() function, gls_api, 4-125, 2-13
ifx_gl_iswprint() function, gls_api, 4-127, 2-13
ifx_gl_iswpunct() function, gls_api, 4-129, 2-13
ifx_gl_iswspace() function, gls_api, 4-131, 2-13
ifx_gl_iswupper() function, gls_api, 4-133, 2-13
ifx_gl_iswxdigit() function, gls_api, 4-135, 2-13
ifx_gl_lc_errno() function, gls_api, A-1, 4-137, 1-20, 1-21, 2-14
See also Error messages.,
ifx_gl_mb_loc_max() function, gls_api, 2-16, 4-84, 2-40, 4-225, 4-139
IFX_GL_MB_MAX macro, gls_api, 2-16, 4-84, 2-40, 4-225, 2-23
ifx_gl_mblen() function, gls_api, 4-140, 2-29
ifx_gl_mbscat() function, gls_api, 4-142, 2-31
ifx_gl_mbschr() function, gls_api, 4-145, 2-33
ifx_gl_mbscoll() function, gls_api, 4-147, 2-35
ifx_gl_mbscpy() function, gls_api, 4-150, 2-32
ifx_gl_mbscspn() function, gls_api, 4-152, 2-33
ifx_gl_mbslen() function, gls_api, 4-155, 2-32
ifx_gl_mbsmbs() function, gls_api, 4-157, 2-33
ifx_gl_mbsncat() function, gls_api, 4-159, 2-31
ifx_gl_mbsncpy() function, gls_api, 4-162, 2-32
ifx_gl_mbsnext() function, gls_api, 4-140, 2-29, 4-164
ifx_gl_mbsntsbytes() function, gls_api, 4-166, 2-32
ifx_gl_mbsntslen() function, gls_api, 4-168, 2-32
ifx_gl_mbspbrk() function, gls_api, 2-33, 4-170
ifx_gl_mbsprev() function, gls_api, 4-172, 2-29
ifx_gl_mbsrchr() function, gls_api, 4-174, 2-33
ifx_gl_mbsspn() function, gls_api, 4-176, 2-33
ifx_gl_mbstowcs() function, gls_api, 4-179, 2-9, 1-24
ifx_gl_mbtowc() function, gls_api, 2-9, 4-181
IFX_GL_NO_LIMIT constant, gls_api, 2-38
IFX_GL_NULL constant, gls_api, 2-38
IFX_GL_PROC_CS macro, gls_api, 4-50, 4-51, 2-21, 4-46, 4-13, 2-22, 2-24
ifx_gl_putmb() function, gls_api, 4-183, 1-22
ifx_gl_tomlower() function, gls_api, 4-185, 2-15
ifx_gl_tomupper() function, gls_api, 4-188, 2-15
ifx_gl_towlower() function, gls_api, 4-191, 2-15
ifx_gl_towupper() function, gls_api, 4-193, 2-15
ifx_gl_wcscat() function, gls_api, 4-195, 2-31
ifx_gl_wcschr() function, gls_api, 4-197, 2-33
ifx_gl_wcscoll() function, gls_api, 4-199, 2-35
ifx_gl_wcscpy() function, gls_api, 4-201, 2-32
ifx_gl_wcscspn() function, gls_api, 4-203, 2-33
ifx_gl_wcslen() function, gls_api, 2-30, 2-32, 4-206
ifx_gl_wcsncat() function, gls_api, 2-31, 4-208
ifx_gl_wcsncpy() function, gls_api, 4-210, 2-32
ifx_gl_wcsntslen() function, gls_api, 4-212, 2-32
ifx_gl_wcspbrk() function, gls_api, 4-214, 2-33
ifx_gl_wcsrchr() function, gls_api, 4-216, 2-33
ifx_gl_wcsspn() function, gls_api, 2-33, 4-218
ifx_gl_wcstombs() function, gls_api, 4-221, 2-9, 1-24
ifx_gl_wcswcs() function, gls_api, 4-223, 2-33
ifx_gl_wctomb() function, gls_api, 4-225, 2-9
ifx_int8_t structure. See int8 data type.,
ifx_int8add() library function, esqlc, 5-12, 5-8
ifx_int8cmp() library function, esqlc, 5-13, 5-8
ifx_int8copy() library function, esqlc, 5-14, 5-8
ifx_int8cvasc() library function, esqlc, 5-15, 5-8
ifx_int8cvdbl() library function, esqlc, 5-8, 5-17
ifx_int8cvdec() library function, esqlc, 5-8, 5-18
ifx_int8cvflt() library function, esqlc, 5-8
ifx_int8cvint() library function, esqlc, 5-19, 5-8
ifx_int8cvlong() library function, esqlc, 5-20, 5-8
ifx_int8div() library function, esqlc, 5-21, 5-8
ifx_int8mul() library function, esqlc, 5-22, 5-8
ifx_int8sub() library function, esqlc, 5-23, 5-8
ifx_int8toasc() library function, esqlc, 5-24, 5-8
ifx_int8todbl() library function, esqlc, 5-26, 5-8
ifx_int8todec() library function, esqlc, 5-8, 5-27
ifx_int8toflt() library function, esqlc, 5-8
ifx_int8toint() library function, esqlc, 5-8, 5-28
ifx_int8tolong() library function, esqlc, 5-8, 5-29
ifx_lo_alter() library function, esqlc, 7-36
lightweight I/O, esqlc, 7-26
ifx_lo_close() library function, esqlc, 7-38, 7-29
lightweight I/O, esqlc, 7-26
ifx_lo_col_info() library function, esqlc, 7-14, 7-39
ifx_lo_copy_to_file() library function, esqlc, 7-50, 7-41, 9-45
ifx_lo_copy_to_lo() library function, esqlc, 7-44
ifx_lo_create() library function, esqlc, 7-46, 7-24, 7-14, 7-16
duration of open, esqlc, 7-27
lightweight I/O, esqlc, 7-25
locks on smart large objects, esqlc, 7-27
ifx_lo_create_spec_t structure. See LO-specification structure.,
ifx_lo_def_create_spec() library function, esqlc, 7-14, 7-49, 7-7
ifx_lo_filename() library function, esqlc, 7-50
ifx_lo_from_buffer() library function, esqlc, 7-52, 7-33, 7-19
ifx_lo_open() library function, esqlc, 7-52, 7-53, 7-24
duration of open, esqlc, 7-27
lightweight I/O, esqlc, 7-25
locks on smart large objects, esqlc, 7-27
ifx_lo_read() library function, esqlc, 7-55, 7-28
ifx_lo_readwithseek() library function, esqlc, 7-57, 7-28
ifx_lo_release, esqlc, 7-52
ifx_lo_release() library function, esqlc, 7-34, 7-59, 7-19
ifx_lo_seek() library function, esqlc, 7-61, 7-28, 7-29
ifx_lo_spec_free() library function, esqlc, 7-63, 7-16
ifx_lo_specget_estbytes() library function, esqlc, 7-64, 7-9
ifx_lo_specget_extsz() library function, esqlc, 7-66, 7-9
ifx_lo_specget_flags() library function, esqlc, 7-11, 7-67
ifx_lo_specget_maxbytes() library function, esqlc, 7-69, 7-9
ifx_lo_specget_sbspace() library function, esqlc, 7-71, 7-9
ifx_lo_specset_estbytes() library function, esqlc, 7-73, 7-9
ifx_lo_specset_extsz() library function, esqlc, 7-75, 7-9
ifx_lo_specset_flags() library function, esqlc, 7-77, 7-11
ifx_lo_specset_maxbytes() library function, esqlc, 7-79, 7-9
ifx_lo_specset_sbspace() library function, esqlc, 7-80, 7-9
ifx_lo_stat() library function, esqlc, 7-81, 7-30
ifx_lo_stat_atime() library function, esqlc, 7-83, 7-31
ifx_lo_stat_cspec() library function, esqlc, 7-84, 7-31
ifx_lo_stat_ctime() library function, esqlc, 7-86, 7-31
ifx_lo_stat_free() library function, esqlc, 7-87, 7-32
ifx_lo_stat_mtime_sec() library function, esqlc, 7-31, 7-88
ifx_lo_stat_refcnt() library function, esqlc, 7-31, 7-89
ifx_lo_stat_size() library function, esqlc, 7-31, 7-91
ifx_lo_stat_t structure. See LO-status structure.,
ifx_lo_t data type,
corresponding SQL data type, esqlc, 2-5, 2-11, 2-13
declaration, esqlc, 7-7
definition of, esqlc, 7-6
fetching into, esqlc, 7-22
inserting from, esqlc, 7-17
See also BLOB data type; CLOB data type.,
use of fixed binary data type, esqlc, 7-7, 10-48
ifx_lo_t structure. See LO-pointer structure.,
ifx_lo_tell() library function, esqlc, 7-92, 7-28, 7-29
ifx_lo_to_buffer() function, esqlc, 7-35
ifx_lo_to_buffer() library function, esqlc, 7-93, 7-19
ifx_lo_truncate() library function, esqlc, 7-95
ifx_lo_write() library function, esqlc, 7-96, 7-29
ifx_lo_writewithseek() library function, esqlc, 7-98, 7-29
ifx_putenv() function, esqlc, 12-43, 14-37
ifx_putenv() library function, esqlc, 1-101
ifx_release() library function, esqlc, 7-34
IFX_RELOAD_MODULE function, sqls, 1-923
IFX_REPLACE_MODULE function, sqls, 1-924
ifx_var_alloc() function, esqlc, 10-33
ifx_var_dealloc() function, esqlc, 10-35
ifx_var_flag() function, esqlc, 10-37
ifx_var_getdata() function, esqlc, 10-39
ifx_var_getlen() function, esqlc, 10-40
ifx_var_isnull() function, esqlc, 10-41, 10-31
ifx_var_setdata() function, esqlc, 10-42
ifx_var_setlen() function, esqlc, 10-44
ifx_var_setnull() function, esqlc, 10-29, 10-46
ifx_varlena_t structure, esqlc, 10-25
See also var binary data type.,
ifxcexp.h header file, definition of, esqlc, 1-25
ifxgls.h header file, gls_api, 1-15, 1-17, 2-6, 2-8, 1-13, 1-14
ifxgls.h header file, definition of, esqlc, 1-24
IID information, dbdkug, 7-4, 6-25
ILENGTH descriptor field, esqlc, 16-36, 15-8
ILENGTH field,
in X/Open programs, sqls, 1-709
with SET DESCRIPTOR, sqls, 1-709
Illustra large-object interface, dapi, 3-17, 2-6
Illustrations,
collection data type, of, overview, 1-19
Informix Dynamic Server architecture, of, overview, 1-8
Informix TimeSeries DataBlade module architecture, overview, B-7
Informix Web DataBlade Module architecture, overview, B-11
opaque data type, of, overview, 1-16
row data type, overview, 1-21
ILOGIN sample program, esqlc, 1-112
ILogin sample program, esqlc, 1-6
IMPEXP data type,
casting from, extend, 5-17
casting to, extend, 5-17
description of, extend, 6-15
parameter in import function, extend, 5-16
return value in export function, extend, 5-16
IMPEXPBIN data type,
casting from, extend, 5-17
casting to, extend, 5-17
description of, extend, 6-17
parameter in importbinary function, extend, 5-16
return value in exportbinary function, extend, 5-16
Implementing ActiveX value objects, dbdkug, 6-14 to
Implicit cast, sqlr, 2-29, Glossary-10, overview, 1-25, extend, 3-6
Implicit casts, dbdkug, 3-18
Implicit connection, sqlr, Glossary-10
default, esqlc, 12-26
definition of, esqlc, 12-19
starting, esqlc, 12-20, 12-68
terminating, esqlc, 12-41
with sqlexit(), esqlc, 12-65
Implicit select list, sqlr, Glossary-10
Implicit temporary table, sqls, 1-218
Import library, esqlc, 1-96
import support function, dapi, 12-267
Import support function, sqls, 1-518, 1-172
as casting function, extend, 5-17
description of, extend, 5-6, 6-16
for smart large objects, extend, 6-22
parameter type, extend, 5-16
return type, extend, 5-16
summary of, extend, 6-4
ImportBinary routine, dbdkug, 6-18
Importbinary support function, sqls, 1-518, 1-172
as casting function, extend, 5-17
description of, extend, 5-6, 6-18
for smart large objects, extend, 6-22
parameter type, extend, 5-16
return type, extend, 5-16
summary of, extend, 6-4
Imported files,
documentation of, overview, A-7
for DataBlade modules, overview, 1-26
Importing,
interfaces, dbdkug, 3-11
SQL statements, dbdkug, 3-46
ImportText routine, dbdkug, 6-17
IN conditions, gls, 3-27
IN operator, extend, 5-23
IN relational operator, sqlt, 3-30
include directives, ESQL/C,
preprocessing of, esqlc, 1-9
Include file. See Header file.,
Include files,
header files as, esqlc, 1-22
preprocessor directive for, esqlc, 1-13
search path, esqlc, 1-64
specifying search path, esqlc, 1-63
syntax for, esqlc, 1-26, 1-14
Include files, setting in Visual C++, dbdkug, 5-40, 6-21
include preprocessor directive, esqlc, 1-26, 1-12, 1-13
#include preprocessor statement, esqlc, 1-26
incvasc() library function, esqlc, 6-65, 6-37
incvfmtasc() library function, esqlc, 6-68, 6-37
Index, sqlr, Glossary-10, gls, 3-6, 6-4, extend, 4-4
attached, sqlr, Glossary-2
bidirectional traversal, sqls, 1-146
cleaner list. See Btree cleaner list.,
clustered,
altering, sqls, 1-52
clustering,
with ALTER INDEX...TO CLUSTER, sqls, 1-53
with CREATE INDEX...CLUSTER, sqls, 1-139
constraints, effect on, sqls, 1-139
converting during upgrade, sqls, 1-806
creating fragments, sqls, 1-158
creating with CREATE INDEX, sqls, 1-137
detached, sqls, 1-157
disabled, sqls, 1-166
disabled mode, sqlt, 4-26
DROP INDEX with, sqls, 1-358
duplicate, sqls, 1-139, 1-84
object mode, sqls, 1-655
enabled mode, sqlt, 4-26
expansion with, sqls, 1-156
FILLFACTOR clause with, sqls, 1-156
filtering mode, sqlt, 4-26
fragmentation with, sqls, 1-157, 1-42, 1-160, 1-36, sqlt, 9-45
INFO statement with, sqls, 1-491
name, sqls, 1-985
number on same columns, sqls, 1-154
object mode (sysobjstate), sqlr, 1-40
on routines, sqlr, 1-48
ORDER BY with, sqls, 1-147, 1-639
privilege for creating (Index privilege) See Privilege, table-level.,
See also Generic B-tree; R-tree index; Secondary access method.,
sharing with constraints, sqls, 1-228
side-effect, sqls, 1-178
sysindices information, sqlr, 1-37
table locks, sqlt, 7-8
temporary table, sqls, 1-644
threads for, sqlr, 3-62
unique,
adding with object modes, sqls, 1-663 to
duplicate values, resolving, sqls, 1-164
Index access method. SeeAccess method, secondary.,
Index fragment, sqlr, Glossary-10
Index Name segment, sqls, 1-985
IndexKey structure,
fields in, sqlr, 1-38, 1-39
INDICATOR descriptor field, esqlc, 16-30, 15-31, 16-36, 15-8
INDICATOR field,
GET DESCRIPTOR with, sqls, 1-438
SET DESCRIPTOR with, sqls, 1-710
syntax, sqls, 1-433
INDICATOR keyword, esqlc, 14-44, 1-45, 1-46
Indicator variable, gls, 1-6, 8-5, 7-6
checking for missing indicator, esqlc, 1-63
declaring, esqlc, 1-44
definition of, esqlc, 1-42, sqlt, 5-16
determining null data, esqlc, 1-43, 1-44, 1-36
in dynamic SQL, sqls, 1-710, 1-438
in GLS environment, esqlc, 1-45
in INTO clause of EXECUTE, esqlc, 14-44
indicating truncation, esqlc, 3-17, 15-31, 6-35, 3-11, 3-13, 1-44, 3-15
inserting null values, esqlc, 1-43
main variable, esqlc, 1-42
See also Null value; Truncated value.,
specifying in SQL statement, esqlc, 1-45
valid data types, esqlc, 1-44
with opaque data type, esqlc, 15-31
with sqlda structure, esqlc, 17-8, 17-30, 17-10, 17-33, 15-13
with system-descriptor area, esqlc, 16-30, 16-36, 15-8
Industry standards, compliance with, sqlr, Intro-16, sqls, Intro-21, esqlc, Intro-15, sqlt, Intro-13, gls_api, Intro-15, dapi, Intro-10, gls, Intro-18, extend, Intro-11, udr, Intro-10
InetLogin structure,
application example, esqlc, 1-111, 12-12
AskPassAtConnect field, esqlc, 1-108, 12-14, 12-15
CC8BitLevel field, esqlc, 1-108
Client_Loc field, esqlc, 1-106
CollChar field, esqlc, 1-106
connection information in, esqlc, 12-8
ConRetry field, esqlc, 1-107
ConTime field, esqlc, 1-107
DB_Loc field, esqlc, 1-106
DbAlsBc field, esqlc, 1-108
DbAnsiWarn field, esqlc, 1-106
DbApiCode field, esqlc, 1-108
DbAsciiBc field, esqlc, 1-109
DbCentury field, esqlc, 1-109
DbCodeset field, esqlc, 1-109
DbConnect field, esqlc, 1-109
DbCsConv field, esqlc, 1-109
DbCsOverride field, esqlc, 1-109
DbCsWidth field, esqlc, 1-109
DbDate field, esqlc, 1-105
DbFltMsk field, esqlc, 1-109
DbLang field, esqlc, 1-106
DbMoney field, esqlc, 1-105
DbMoneyScale field, esqlc, 1-110
DbNls field, esqlc, 1-106
DbPath field, esqlc, 1-105
DbSS2 field, esqlc, 1-110
DbSS3 field, esqlc, 1-110
DbTemp field, esqlc, 1-105
DbTime field, esqlc, 1-105
DelimIdent field, esqlc, 1-107
description of, esqlc, 1-104
determining default database server, esqlc, 1-105
EsqlMF field, esqlc, 1-108
FetBuffSize field, esqlc, 1-108
fields of, esqlc, 1-105
GlDate field, esqlc, 1-108
GlDateTime field, esqlc, 1-108
Host field, esqlc, 1-107, 12-14
InformixDir field, esqlc, 1-106
InformixSqlHosts field, esqlc, 1-108
InfxServer field, esqlc, 12-95, 1-105, 12-11, 12-14
Lang field, esqlc, 1-106
Lc_Collate field, esqlc, 1-106
Lc_CType field, esqlc, 1-107
Lc_Monetary field, esqlc, 1-107
Lc_Numeric field, esqlc, 1-107
Lc_Time field, esqlc, 1-107
Options field, esqlc, 1-108, 12-15
Pass field, esqlc, 1-107, 12-14
precedence, esqlc, 1-112
Protocol field, esqlc, 1-108, 12-15
Service field, esqlc, 1-108, 12-15
setting fields, esqlc, 1-110
User field, esqlc, 1-107, 12-14
with HostInfoStruct, esqlc, 12-14
INF_ROLE_SEP environment variable, sqlr, 3-53
info command, bldmg_ug, 3-16
INFO statement, sqls, 1-489 to
COLUMNS FOR, sqls, 1-491
FRAGMENT keyword, sqls, 1-492
INDEXES FOR, sqls, 1-491
PRIVILEGES FOR, sqls, 1-493
REFERENCES FOR, sqls, 1-493
STATUS FOR, sqls, 1-494
TABLES, sqls, 1-490
Information Schema views,
accessing, sqlr, 1-67
columns view, sqlr, 1-68
description of, sqlr, 1-65 to
generating, sqlr, 1-66
server_info view, sqlr, 1-70
sql_languages view, sqlr, 1-70
tables view, sqlr, 1-67
Informix Code-Set Name-Mapping file. See registry file.,
Informix code-set-conversion file. See Code-set-conversion file.,
Informix DataBlade Developers Program, dbdkug, Intro-11
Informix Developer Network, described, overview, 2-10
Informix Dynamic Server,
architecture, dbdkug, 4-3 to
architecture of, overview, A-8, 1-8
configuring, bldmg_ug, 2-4, 3-4
connecting to a different from the command line, bldmg_ug, 3-8
connecting to as a different user from the command line, bldmg_ug, 3-8
connecting to from the command line, bldmg_ug, 3-7
connection handle, dbdkug, 5-9
default, bldmg_ug, 3-8
dynamic link library, replacing, dbdkug, 9-5
extended by DataBlade modules, overview, 1-3
listing from the command line, bldmg_ug, 3-8
loading a dynamic link library, dbdkug, 9-10
loading a shared object file, dbdkug, 8-15
memory allocation for DataBlade modules in, overview, 1-10
operating system signals, dbdkug, 4-13
preparing the environment, dbdkug, 8-4
process ID, dbdkug, 8-16
query processing, dbdkug, 2-14 to
shared object files, dbdkug, 8-5
shutting down on UNIX, dbdkug, 8-15
starting on UNIX, dbdkug, 8-15
starting on Windows NT, dbdkug, 9-9, 9-7
stopping with the debugger on Windows NT, dbdkug, 9-11
thread safety, dbdkug, 4-13
tracing, enabling for a session, dbdkug, 5-16
virtual processors, dbdkug, 4-4
virtual processors in, overview, 1-9
Informix extension checking, specifying with DBANSIWARN, sqlr, 3-17
INFORMIX FIND ERROR utility, esqlc, 1-6
Informix general library,
actual name, esqlc, 13-7, 13-8
API version, esqlc, 13-14
choosing version of, esqlc, 13-5
compatibility issues, esqlc, 13-12
default version, esqlc, 13-9
description of, esqlc, 13-3
libasf, esqlc, 13-5, 13-13, 1-88
libgen, esqlc, 13-5, 13-13, 1-88
libgls, esqlc, 13-5, 13-13, 1-88
libos, esqlc, 13-5, 13-13, 1-88
libsql, esqlc, 13-5, 13-13, 1-88
libtgen, esqlc, 13-13
libtos, esqlc, 13-13
libtsql, esqlc, 13-13
linking, esqlc, 13-7, 13-26, 13-9
location of, esqlc, 13-6
naming, esqlc, 13-7, 13-8
obtaining version of, esqlc, 13-13
shared, esqlc, 13-10, 13-3, 13-8
static, esqlc, 13-3, 13-7
symbolic name, esqlc, 13-8
thread-safe, esqlc, 13-3
thread-safe shared, esqlc, 13-28
thread-safe static, esqlc, 13-28
Informix Geodetic DataBlade module, overview, B-1
Informix GLS API, extend, 6-24
Informix library. See Informix general library.,
INFORMIX Registry subkey,
connection information in, esqlc, 1-112
Informix Server Information dialog box (Setnet32 utility), esqlc, 12-95
Informix SQL data types. See SQL data types.,
Informix TimeSeries DataBlade module, overview, B-6
informix user,
owner of shared object files, dbdkug, 8-5
Informix user ID, sqlr, Glossary-10
CONNECT...USER statement with, sqls, 1-110
host variable for, sqls, 1-110
Informix user password, sqlr, Glossary-10
Informix Video Foundation DataBlade module, overview, B-8
Informix Web DataBlade module, overview, B-10
Informix, environment configuration file, sqlr, 3-6
INFORMIX-4GL,
detecting null value, sqlt, 5-17
indicator variable not used, sqlt, 5-17
program variable, sqlt, 5-6
STATUS variable, sqlt, 5-9
terminates on errors, sqlt, 6-14, 5-37
using SQLCODE with, sqlt, 5-9
WHENEVER ERROR statement, sqlt, 5-36
Informix-Admin group, dbdkug, 6-21, 9-6, 5-39, bldmg_ug, 1-5
INFORMIX-ESQL/C, overview, 1-12
INFORMIX-GLS, overview, 1-11
INFORMIX-GLS library,
allocating memory for, gls_api, 1-22
character processing, gls_api, 2-3
compatibility, gls_api, 1-7
data formatting, gls_api, 3-3
error number, gls_api, 4-137
gl_mchar_t data type, gls_api, 2-6
gl_wchar_t data type, gls_api, 2-8
handling exceptions of, gls_api, 4-137, 1-20
initializing, gls_api, 1-18
optimization of, gls_api, 1-23
required directories, gls_api, 1-14
single-byte characters, gls_api, 2-5
stream I/O, gls_api, 1-22
string-processing functions, gls_api, 2-31
INFORMIX-OnLine Dynamic Server, esqlc, 11-23, 11-15
checking filenames, gls, 5-7
chunk name, gls, 5-4
code-set conversion, gls, 1-44
diagnostic files, gls, 5-3
identifiers, gls, 1-31
log filename, gls, 5-4
message log file, gls, 5-3
multibyte characters, gls, 5-8
multibyte filenames, gls, 5-4, 2-25
NCHAR sizing restrictions, gls, 3-12
non-ASCII filenames, gls, 5-4, 2-25
operating-system files, gls, 5-3
pathnames, gls, 5-4
sample connection, gls, 1-22
See also Database server.,
support for locales, gls, 1-5
uses of server locale, gls, 5-3
using GLS8BITFSYS, gls, 5-5, 2-25
utilities, gls, 5-8
with TRIM function, gls, 8-17, 8-18
INFORMIX-SE database server,
compatibility issues, gls, 6-6
data file, gls, 6-3
data portability, gls, 6-6
identifiers, gls, 1-31
index file, gls, 6-3
log file, gls, 6-3
multibyte characters, gls, 6-6, 6-8
multibyte filenames, gls, 2-25
naming a database, gls, 6-7
NCHAR sizing restrictions, gls, 3-12
non-ASCII filenames, gls, 6-4, 2-25
operating-system files, gls, 6-3
See also Database server.,
support for locales, gls, 1-5
uses of server locale, gls, 6-3
using GLS8BITFSYS, gls, 6-4, 2-25
utilities, gls, 6-8
with TRIM function, gls, 8-17
Informix-specific status code. See SQLCODE variable.,
INFORMIX-SQL,
creating database with, sqlt, 9-42, 5-34
UNLOAD statement, sqlt, 9-43
INFORMIX-Universal Server,
characteristics of, sqlt, 1-9
checking filenames, gls, 4-7
checking for secondary mode, esqlc, 11-30, 11-23, 11-15, 12-28
chunk name, gls, 4-4
DATASKIP feature, esqlc, 11-31, 11-23, 1-43, 11-15
determining type, esqlc, 11-23, 11-15
diagnostic files, gls, 4-3
interrupting, esqlc, 12-54, 12-37
log filename, gls, 4-4
message log file, gls, 4-3
multibyte characters, gls, 4-8
multibyte filenames, gls, 4-4
non-ASCII filenames, gls, 4-4
pathnames, gls, 4-4
uses of server locale, gls, 4-3
using GLS8BITFSYS, gls, 4-5
utilities, gls, 4-8
informix.rc file, sqlr, 3-6
INFORMIXC environment variable, sqlr, 3-44, esqlc, 1-78
INFORMIXCONCSMCFG environment variable, sqlr, 3-45
INFORMIXCONRETRY environment variable, sqlr, 3-45, esqlc, 1-107
INFORMIXCONTIME environment variable, sqlr, 3-46, esqlc, 1-107
INFORMIXDIR,
location of demonstration programs, esqlc, 1-6
value of in a Windows environment, esqlc, 1-6
INFORMIXDIR environment variable, sqlr, 3-47, esqlc, 1-48, B-2, 13-13, 13-6, 1-64, gls_api, 1-10, 2-24, 1-12, 1-14, dbdkug, 8-4, 6-19
in InetLogin structure, esqlc, 1-106
location of code-set files, gls, A-26, A-18
location of code-set-conversion files, gls, A-25, A-15
location of DLLs, esqlc, 1-89
location of esqlauth.c file, esqlc, 12-16
location of executables, esqlc, 1-6
location of function libraries, esqlc, 1-6
location of import library, esqlc, 1-84
location of include files, esqlc, 1-84
location of locale files, gls, A-9, 1-21, A-22
location of message files, gls, 2-16, 2-15
location of operating-system locales, gls, A-11
location of registry file, gls, A-19
required, esqlc, 1-10
with glfiles, gls, A-22
INFORMIXDIR/bin directory, sqlr, Intro-6, sqls, Intro-6, esqlc, B-2, sqlt, Intro-7, extend, Intro-5, udr, Intro-5
$INFORMIXDIR/etc/sqlhosts. See sqlhosts file.,
INFORMIXKEYTAB environment variable, sqlr, 3-48
INFORMIXOPCACHE environment variable, sqlr, 3-48
INFORMIXSERVER,
default value of, dapi, 5-9
description, dapi, 5-9
INFORMIXSERVER environment variable, sqlr, 3-49, esqlc, 16-51, B-2, 12-50, 1-119, 12-7, 12-68, dbdkug, 8-4
and GetConnect(), esqlc, 12-95
in HostInfoStruct structure, esqlc, 12-14
in InetLogin structure, esqlc, 1-105
INFORMIXSHMBASE environment variable, sqlr, 3-50
INFORMIXSQLHOSTS environment variable, esqlc, B-2, 1-108, 12-7, 12-13
INFORMIXSTACKSIZE environment variable, sqlr, 3-51
INFORMIXTERM environment variable, sqlr, 3-52
Inheritance, sqlt, 10-20 to
definition of, sqlr, Glossary-10
documentation of, overview, A-7
row data type, for, overview, 1-21
single, sqlt, 10-20
type hierarchy, sqlt, 10-20
type substitutability, sqlt, 10-25
Inheritance, row data type, dbdkug, 3-42
initialization, dapi, 5-3
DataBlade API, dapi, 12-443
Initialization functions, gls_api, 4-6
Initialization of an aggregate, dbdkug, 3-15
Input parameter, sqlr, Glossary-10
definition of, esqlc, 14-51, 14-7
in singleton SELECT, esqlc, 14-44
not known at compile time, esqlc, 15-24
specifying value in a system-descriptor area, esqlc, 16-10
specifying value in an sqlda structure, esqlc, 17-14
specifying values for EXECUTE FUNCTION statements, esqlc, 14-52, 14-54, 15-26
specifying values for non-SELECT statements, esqlc, 14-52, 15-26
specifying values for SELECT statements, esqlc, 14-52, 14-54, 15-26
specifying values for user-defined routines, esqlc, 14-45
with DESCRIBE, esqlc, 16-6
Input support function, sqlr, 2-53, sqls, 1-171
as casting function, extend, 3-10, 3-12, 5-17
description of, extend, 5-5, 6-6
locale-sensitive data, extend, 6-24
parameter type, extend, 5-16
return type, extend, 5-16
summary of, extend, 6-3
Insert buffer, esqlc, 14-20, 14-18
counting inserted rows, sqls, 1-566, 1-428
cursor with, sqls, 1-498
filling with constant values, sqls, 1-558
storing rows with PUT, sqls, 1-557
triggering flushing, sqls, 1-565
Insert cursor, sqls, 1-498, 1-315, esqlc, 17-14, sqlt, 6-9
benefits, sqls, 1-316
closing, sqls, 1-94
constants with, sqlt, 6-12
definition of, esqlc, 14-18, sqlt, 6-9
description of, esqlc, 14-20
executing with sqlda structure, esqlc, 17-31
executing with system-descriptor area, esqlc, 16-35
for collection variable, esqlc, 9-21
input parameters in VALUES clause, esqlc, 16-11
insert buffer, esqlc, 14-20
opening, sqls, 1-532
reopening, sqls, 1-532
required for, esqlc, 14-18
restrictions, sqls, 1-532
sqlca state on closing, sqls, 1-94
statements that manage, esqlc, 14-18
transaction with, sqls, 1-96
values passed to program, sqls, 1-559
with system-descriptor area, esqlc, 16-11
Insert privilege, sqlt, 11-8
INSERT statement, sqls, 1-495 to , sqlt, 4-7
and NOT FOUND condition, esqlc, 11-21, 11-36
associated with a cursor, esqlc, 14-18
AT clause, sqls, 1-512
character values, sqls, 1-502
collection column values, sqls, 1-504
collection columns, esqlc, 9-40
Collection Derived Table clause, esqlc, 9-64, 9-18
collection derived table with, sqls, 1-833, 1-514, 1-509
collection variable elements, sqls, 1-509
collection variables with, sqls, 1-833
collection with,
Collection variable, cursor for, sqls, 1-563
constant data with, sqlt, 6-12
count of rows inserted, sqls, 1-450, 1-915, sqlt, 6-11
cursor with, sqls, 1-498
defined statement constant, esqlc, 15-17
DESCRIBE with, sqls, 1-341
determining estimated cost of, esqlc, 11-30
determining number of rows inserted, esqlc, 11-30, 11-8
determining rowid, esqlc, 11-30
duplicate values in, sqlt, 4-8
dynamic, sqls, 1-508, esqlc, 14-40, 14-52, 15-25, 14-18
embedded, sqlt, 6-9 to
embedded SELECT, gls, 3-50
end-user formats, gls, 1-13
era-based dates, gls, 3-50
ESQL/C, sqls, 1-504, 1-506
examples with object modes, sqls, 1-659 to
executing with sqlda structure, esqlc, 17-31
executing with system-descriptor area, esqlc, 16-30
failing to access rows, esqlc, 11-29
GLS considerations, gls, 3-49
insert cursor compared with, sqls, 1-316
inserting CHAR data, esqlc, 3-18, 3-12
inserting collection data, esqlc, 9-41, 9-38, 9-18
inserting NCHAR data, esqlc, 3-12
inserting NVARCHAR data, esqlc, 3-15
inserting opaque-type data, esqlc, 10-28, 10-22, 15-29, 10-13
inserting row-type data, esqlc, 9-74, 9-64
inserting smart large-object data, esqlc, 7-17
inserting VARCHAR data, esqlc, 3-14
interrupting, esqlc, 12-52, 12-34
known at compile time, esqlc, 14-40, 14-52
LOAD with, sqls, 1-517
multiple rows, sqlt, 4-10
not known at compile time, esqlc, 15-24
null values in, sqlt, 4-8
number of rows, sqlt, 5-10
object modes with, sqls, 1-657
obtaining generated SERIAL value, esqlc, 11-29
opaque variables, sqls, 1-503
parameterized, esqlc, 14-52
privilege for, sqlt, 11-5, 11-8
privilege for See Privilege, table-level.,
PUT with, sqls, 1-557
putting values into program variables, sqls, 1-559
row type field values, sqls, 1-505
row variables, sqls, 1-514
row-type columns, esqlc, 9-71
SELECT statement with, sqls, 1-507, sqlt, 4-10
SERIAL and SERIAL8 columns, sqls, 1-503
SERIAL and SERIAL8 columns with, sqls, 1-914
smart large object, dapi, 3-18, 3-55
smart large objects with, sqls, 1-890
specifying quoted strings, gls, 3-33
TEXT and BYTE columns, sqls, 1-502
transaction and, sqls, 1-499
VALUES clause, sqls, 1-499, esqlc, 1-38, 14-52, sqlt, 4-7, gls, 3-50
expressions with, sqls, 1-506
NULL keyword with, sqls, 1-507
view with, sqls, 1-497, sqlt, 11-30
with DESCRIBE, esqlc, 17-8, 15-16, 16-6, 17-7
with null values, esqlc, 1-43
Inserting,
CHAR values, esqlc, 3-12
character data, esqlc, 3-18, 3-11
data conversion, esqlc, 2-15
DATETIME values, esqlc, 2-18, 6-33
from char host variable, esqlc, 3-17, 3-12, 3-14
from datetime host variable, esqlc, 6-33
from fixchar host variable, esqlc, 3-17, 3-12, 3-14
from fixed binary host variable, esqlc, 10-21
from fixed-size lvarchar, esqlc, 10-12
from ifx_lo_t host variable, esqlc, 7-17
from interval host variable, esqlc, 6-34
from string host variable, esqlc, 3-17, 3-12, 3-14
from var binary host variable, esqlc, 10-28
from varchar host variable, esqlc, 3-17, 3-12, 3-14
INTERVAL values, esqlc, 2-18, 6-34
into collection column, esqlc, 9-40, 9-41, 9-38
into collection variable, esqlc, 9-18
into row variable, esqlc, 9-64
into row-type column, esqlc, 9-74, 9-71
opaque-type values, esqlc, 15-29
smart large object, dapi, 3-18, 3-55
smart large-object data, esqlc, 7-17
VARCHAR values, esqlc, 2-19, 3-14
Installation, sqlr, Glossary-10
ActiveX value objects, dbdkug, 7-4
customizing screen display text, dbdkug, 10-22
directory, dbdkug, 10-5
package files, dbdkug, 7-4, 6-25, 3-55
package, building with BladePack, dbdkug, 6-24, 10-10
Installation directory, specifying with INFORMIXDIR, sqlr, 3-48
Installation files for DataBlade modules, overview, 2-4
Installation files, INFORMIXDIR environment variable, sqlr, 3-47
installation script for DataBlade modules on UNIX, bldmg_ug, 1-4
Installing,
BladeManager, bldmg_ug, 2-4, 3-4
client files from the command line, bldmg_ug, 3-12
client files with the GUI, bldmg_ug, 2-11
DataBlade modules on UNIX, bldmg_ug, 1-4
DataBlade modules on Windows NT, bldmg_ug, 1-5
Installing a DataBlade module,
about, overview, 2-7
documentation of, overview, A-7
Instance, sqlt, 1-13
example, sqlt, 10-8
Instantiating ActiveX value objects, dbdkug, 7-5
int data type, esqlc, 2-10
converting from decimal, esqlc, 4-47
converting from int8, esqlc, 5-28
converting to decimal, esqlc, 4-21
See also short int data type; long int data type.,
INT data type, sqlr, 2-47
INT data type. See INTEGER data type.,
INT8 data type, sqlr, 2-47, sqls, 1-866, sqlt, 9-9
casts for, sqlr, 2-27, 2-28
corresponding ESQL/C data type, esqlc, 2-5, 5-4, 5-5, 2-13
data conversion, esqlc, 5-8
declaring host variable for, esqlc, 5-7
defined constant, esqlc, 2-9
ifx_getserial8(), esqlc, 5-10
ifx_int8add(), esqlc, 5-12
ifx_int8cmp(), esqlc, 5-13
ifx_int8copy(), esqlc, 5-14
ifx_int8cvasc(), esqlc, 5-15
ifx_int8cvdbl(), esqlc, 5-17
ifx_int8cvdec(), esqlc, 5-18
ifx_int8cvint(), esqlc, 5-19
ifx_int8cvlong(), esqlc, 5-20
ifx_int8div(), esqlc, 5-21
ifx_int8mul(), esqlc, 5-22
ifx_int8sub(), esqlc, 5-23
ifx_int8toasc(), esqlc, 5-24
ifx_int8todbl(), esqlc, 5-26
ifx_int8todec(), esqlc, 5-27
ifx_int8toint(), esqlc, 5-28
ifx_int8tolong(), esqlc, 5-29
int8 structure shown, esqlc, 5-7
See also int8 data type.,
See Numeric data.,
syscolumns coltype code for, sqlr, 1-24
unloading, sqls, 1-771
int8 data type,
addition, esqlc, 5-12
arithmetic operations, esqlc, 5-8
comparing, esqlc, 5-13
converting from decimal, esqlc, 5-18
converting from double, esqlc, 5-17
converting from integer, esqlc, 5-19
converting from long int, esqlc, 5-20
converting from text, esqlc, 5-15
converting to decimal, esqlc, 5-27
converting to double, esqlc, 5-26
converting to int, esqlc, 5-28
converting to long int, esqlc, 5-29
converting to text, esqlc, 5-24
copying, esqlc, 5-14
corresponding SQL data type, esqlc, 2-5
data conversion, esqlc, 5-8
declaration, esqlc, 5-7
defined constant, esqlc, 2-10
division, esqlc, 5-21
getting SERIAL8 values, esqlc, 5-10
multiplication, esqlc, 5-22
See also INT8 data type; SERIAL8 data type.,
subtraction, esqlc, 5-23
int8.h header file, esqlc, 5-7, 2-13, dapi, 1-6
int8.h header file, definition of, esqlc, 1-24
INTEGER data type, sqlr, 2-48, sqls, 1-866, sqlt, 9-9, gls, A-7, 1-14
casts for, sqlr, 2-27, 2-28
corresponding ESQL/C data type, esqlc, 2-4, 5-4, 2-12
data conversion, esqlc, 2-19, 2-20, 2-21
defined constant, esqlc, 15-21, 2-8, 2-9
length (syscolumns), sqlr, 1-27
See also int data type.,
See Numeric data.,
syscolumns coltype code for, sqlr, 1-24
unloading, sqls, 1-771
integer values,
copying, dapi, 12-184, 12-399
Integrity. See Data integrity.,
Intel MMX technology support, dbdkug, 3-50, 5-20, 3-53
Intensity attributes, setting INFORMIXTERM for, sqlr, 3-52
Inter method/routine, dbdkug, 6-18, 7-9
Interfaces, dbdkug, 2-22
defining in BladeSmith, dbdkug, 3-21
documentation of, overview, A-7
IDispatch, dbdkug, 7-6
importing from other DataBlade modules, dbdkug, 3-11
IRawObjectAccess, dbdkug, 7-5
ITDkValue, dbdkug, 7-6
properties of, dbdkug, 3-22
to DataBlade modules, overview, 1-25
Interfaces for DataBlade modules, bldmg_ug, 2-7, 3-10
INTERNAL routine modifier, sqls, 1-1031
Internal routines, dbdkug, 3-24
Internal structure of opaque data types, dbdkug, 6-10, 3-36
International monetary format, gls_api, 4-73, 3-6, 4-37
Internationalization, overview, A-7
character processing, gls_api, 2-3
data formatting, gls_api, 3-3
definition of, gls_api, 1-4
INFORMIX-GLS library and, gls_api, 1-6
internationalization,
of error messages, dapi, 12-73
Internationalization, error messages, dbdkug, 3-21
Interoperability, dbdkug, 2-21 to
Interquery parallelization, sqlr, Glossary-11
Interrupted modifications, sqlt, 4-27
INTERVAL data type, sqlr, 2-48, sqls, 1-871, sqlt, 9-17
ANSI-standard qualifiers, esqlc, 6-36
classes of, esqlc, 6-34, 6-36
corresponding ESQL/C data type, esqlc, 2-4, 2-12
data conversion, esqlc, 2-18, 6-33, 6-35, 6-37
DATE, DATETIME with, sqlr, 2-10, 2-15 to
declaring host variables for, esqlc, 6-30
defined constant, esqlc, 2-8
dynamically allocating structures for, esqlc, 17-12
expressions with, sqlr, 2-10
EXTEND function with, sqlr, 2-13
fetching, esqlc, 2-18, 6-34
field delimiters, sqlr, 2-50
format, sqlt, 9-18
greater than condition, sqls, 1-1020
incvasc(), esqlc, 6-65
incvfmtasc(), esqlc, 6-68
inserting, esqlc, 2-18, 6-34
intoasc(), esqlc, 6-71
intofmtasc(), esqlc, 6-74
invdivdbl(), esqlc, 6-77
invdivinv(), esqlc, 6-80
invextend(), esqlc, 6-82
invmuldbl(), esqlc, 6-85
length (syscolumns), sqlr, 1-28
loading, sqls, 1-518
macros, esqlc, 6-31
precision of underlying decimal value, esqlc, 6-29
qualifiers, esqlc, 6-30, 6-36
role of datetime.h, esqlc, 2-12, 1-22
See also interval data type.,
syscolumns coltype code for, sqlr, 1-24
with SET DESCRIPTOR, sqls, 1-710
interval data type,
arithmetic operations, esqlc, 6-36
corresponding SQL data type, esqlc, 2-4
data conversion, esqlc, 6-37
declaration, esqlc, 6-30
defined constant, esqlc, 2-10
definition of, esqlc, 6-28
fetching into, esqlc, 6-34
inserting from, esqlc, 6-34
role of datetime.h, esqlc, 2-12
See also INTERVAL data type; intrvl_t typedef.,
INTERVAL Field Qualifier segment, sqls, 1-987
INTO DESCRIPTOR keywords, sqls, 1-387
in EXECUTE, sqls, 1-391
INTO keyword,
restrictions in prepared statement, sqlt, 5-30
retrieving single rows, sqlt, 5-14
INTO SQL DESCRIPTOR keywords, sqls, 1-387
in EXECUTE...INTO, sqls, 1-390
INTO TEMP keywords,
description of, sqlt, 2-76
intoasc() library function, esqlc, 6-71, 6-37
intofmtasc() library function, esqlc, 16-62, 6-74, 6-37
Intraquery parallelization, sqlr, Glossary-11
intrvl structure, esqlc, 6-30
intrvl_t typedef,
defined constant, esqlc, 2-10
definition of, esqlc, 6-30, 6-34
setting qualifier for INTERVAL, esqlc, 17-12
invdivdbl() library function, esqlc, 6-77, 6-36
invdivinv() library function, esqlc, 6-80, 6-36
invextend() library function, esqlc, 6-82, 6-34
invmuldbl() library function, esqlc, 6-85, 6-36
IRawObjectAccess custom interface, dbdkug, 7-5
ISAM error code, sqls, 2-49, 2-43, sqlt, 5-10
and sqlerrd, esqlc, 11-29
and sqlerrd[1], esqlc, 11-38
retrieving message text, esqlc, 11-51, 11-10, 11-48
See also SQLCODE variable.,
IsDirty method, dbdkug, 6-26
ISDISTINCTBOOLEAN distinct-bit macro, esqlc, 15-32
ISDISTINCTLVARCHAR distinct-bit macro, esqlc, 15-32
ISDISTINCTTYPE distinct-bit macro, esqlc, 15-32
IsNull method, dbdkug, 7-7, 7-9, 6-19
ISO 8859-1 code set, sqlr, Intro-5, sqls, Intro-6, esqlc, Intro-4, sqlt, Intro-6, 2-24, dapi, Intro-5, extend, Intro-4, udr, Intro-4
ISO standards. See ANSI SQL standards.,
ISO8859-1 code set, gls_api, 2-10, gls, 1-19, 1-21
Isolation, sqlr, Glossary-11
Isolation level,
ANSI Read Committed, sqls, 1-745, sqlt, 7-14
ANSI Read Uncommitted, sqls, 1-745, sqlt, 7-13
ANSI Repeatable Read, sqls, 1-745, sqlt, 7-16
ANSI Serializable, sqls, 1-745, sqlt, 7-16
default, sqls, 1-746, 1-725
default in ANSI-compliant database, sqls, 1-745
definitions, sqls, 1-745, 1-724
description of, sqlt, 7-11
FETCH statement with, sqls, 1-421
in external tables, sqls, 1-742, 1-726
Informix Committed Read, sqls, 1-724, sqlt, 7-14
Informix Cursor Stability, sqls, 1-724, sqlt, 7-14
Informix Dirty Read, sqls, 1-724, sqlt, 7-13
Informix Repeatable Read, sqls, 1-724, sqlt, 7-16
scroll cursor with, sqls, 1-317
setting, sqlt, 7-11
IsUpdated method, dbdkug, 7-7
ITDkValue custom interface, dbdkug, 7-6
Item descriptor,
DATA field. See DATA descriptor field.,
definition of, esqlc, 15-5
EXTYPEID field, esqlc, 15-9
EXTYPELENGTH field, esqlc, 15-9
EXTYPENAME field, esqlc, 15-9
EXTYPEOWNERLENGTH field, esqlc, 15-9
EXTYPEOWNERNAME field, esqlc, 15-9
getting field values, esqlc, 16-10
IDATA field, esqlc, 16-36, 15-8
ILENGTH field, esqlc, 16-36, 15-8
INDICATOR field, esqlc, 16-30, 15-31, 16-36, 15-8
ITYPE field, esqlc, 16-36, 15-8
LENGTH field. See LENGTH descriptor field.,
NAME field, esqlc, 16-21, 16-6, 15-8
NULLABLE field, esqlc, 16-21, 16-6, 15-8
PRECISION field, esqlc, 16-6, 15-8
SCALE field, esqlc, 16-6, 15-8
See also individual field names.,
setting fields, esqlc, 16-9
setting maximum number, esqlc, 16-5
SOURCEID field, esqlc, 15-32, 15-9
SOURCETYPE field, esqlc, 15-32, 15-9
TYPE field. See TYPE descriptor field.,
items table in stores7 database, columns in, sqlr, A-4
Iteration, aggregate, dbdkug, 3-13, 3-16
iterator function, sqlr, Glossary-11
Iterator function, esqlc, 14-50, 17-29, 16-29
ITERATOR routine modifier, sqls, 1-1032
Iterator routines, dbdkug, 5-35, 3-24
ITMVDesc structure, dbdkug, 7-6
ITValue interface, dbdkug, 7-6
ITYPE descriptor field, esqlc, 16-9, 16-36, 15-8
ITYPE field,
in X/Open programs, sqls, 1-709
syntax, sqls, 1-433
with SET DESCRIPTOR, sqls, 1-710


Copyright © 1997, Informix Software, Inc. All rights reserved.