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

Informix Guide to SQL: Syntax, organization of, sqls, 1-7

Icons,

comment, sqlr, Intro-9, sqls, Intro-10, sqlt, Intro-10

compliance, sqlr, Intro-10, sqls, Intro-12

feature, sqlr, Intro-10, sqls, Intro-11, sqlt, Intro-10

Important, vis_ug, Intro-7

product, sqls, Intro-11

See also Data symbols.,

syntax diagram, sqls, Intro-14

Tip, vis_ug, Intro-7

Warning, vis_ug, Intro-7

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

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

IDN. See Informix Developer Network.,

.iem file extension, instll32, 27

IF statement,

syntax, sqls, 2-34

syntax and use, sqls, 2-34

with null values, sqls, 2-36

IFX_AUTOFREE environment variable, sqls, 1-682, 1-683, 1-678

IFX_DEFERRED_PREPARE environment variable, sqlr, 3-55, sqls, 1-700

IFX_RELOAD_MODULE function, sqls, 1-923

IFX_REPLACE_MODULE function, sqls, 1-924

ifxbuiltins DataBlade module, vis_ug, Intro-5

ILENGTH field,

in X/Open programs, sqls, 1-709

with SET DESCRIPTOR, sqls, 1-709

Images,

mapping to Picture objects, vis_ug, 5-17

See also Stock images.,

ImageSource property, vis_ug, 11-7

Implicit cast, sqlr, 2-29, Glossary-10

Implicit connection, sqlr, Glossary-10

Implicit select list, sqlr, Glossary-10

Implicit temporary table, sqls, 1-218

Import support function, sqls, 1-518, 1-172

Importbinary support function, sqls, 1-518, 1-172

IN relational operator, sqlt, 3-30

Index, sqlr, Glossary-10

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.,

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 field,

GET DESCRIPTOR with, sqls, 1-438

SET DESCRIPTOR with, sqls, 1-710

syntax, sqls, 1-433

Indicator variable,

definition of, sqlt, 5-16

in dynamic SQL, sqls, 1-710, 1-438

Industry standards, compliance with, sqlr, Intro-16, sqls, Intro-21, sqlt, Intro-13

INF_ROLE_SEP environment variable, sqlr, 3-53

Info objects,

in pie charts, vis_ug, 5-20

properties of, vis_ug, A-36

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 Client Software Developer's Kit, vis_ug, Intro-5

Informix Developer Network (IDN), vis_ug, Intro-8

Informix extension checking, specifying with DBANSIWARN, sqlr, 3-17

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, 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-SQL,

creating database with, sqlt, 9-42, 5-34

UNLOAD statement, sqlt, 9-43

INFORMIX-Universal Server,

characteristics of, sqlt, 1-9

informix.rc file, sqlr, 3-6

INFORMIXC environment variable, sqlr, 3-44

INFORMIXCONCSMCFG environment variable, sqlr, 3-45

INFORMIXCONRETRY environment variable, instll32, 25, sqlr, 3-45

INFORMIXCONTIME environment variable, instll32, 25, sqlr, 3-46

INFORMIXDIR,

environment variable, instll32, 29

INFORMIXDIR environment variable, sqlr, 3-47

INFORMIXDIR/bin directory, sqlr, Intro-6, sqls, Intro-6, sqlt, Intro-7

$INFORMIXDIR/etc/sqlhosts. See sqlhosts file.,

INFORMIXKEYTAB environment variable, sqlr, 3-48

INFORMIXOPCACHE environment variable, sqlr, 3-48

INFORMIXSERVER environment variable, instll32, 29, sqlr, 3-49

INFORMIXSHMBASE environment variable, sqlr, 3-50

INFORMIXSQLHOSTS environment variable, instll32, 29

INFORMIXSTACKSIZE environment variable, sqlr, 3-51

INFORMIXTERM environment variable, sqlr, 3-52

InfoShelf, vis_ug, Intro-10, Intro-5, Intro-8

Inheritance, sqlt, 10-20 to

definition of, sqlr, Glossary-10

single, sqlt, 10-20

type hierarchy, sqlt, 10-20

type substitutability, sqlt, 10-25

Input parameter, sqlr, Glossary-10

Input support function, sqlr, 2-53, sqls, 1-171

Insert buffer,

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, sqlt, 6-9

benefits, sqls, 1-316

closing, sqls, 1-94

constants with, sqlt, 6-12

definition of, sqlt, 6-9

opening, sqls, 1-532

reopening, sqls, 1-532

restrictions, sqls, 1-532

sqlca state on closing, sqls, 1-94

transaction with, sqls, 1-96

values passed to program, sqls, 1-559

Insert privilege, sqlt, 11-8

INSERT statement, sqls, 1-495 to , sqlt, 4-7

AT clause, sqls, 1-512

character values, sqls, 1-502

collection column values, sqls, 1-504

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

DESCRIBE with, sqls, 1-341

duplicate values in, sqlt, 4-8

dynamic, sqls, 1-508

embedded, sqlt, 6-9 to

ESQL/C, sqls, 1-504, 1-506

examples with object modes, sqls, 1-659 to

insert cursor compared with, sqls, 1-316

LOAD with, sqls, 1-517

multiple rows, sqlt, 4-10

null values in, sqlt, 4-8

number of rows, sqlt, 5-10

object modes with, sqls, 1-657

opaque variables, sqls, 1-503

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

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 objects with, sqls, 1-890

TEXT and BYTE columns, sqls, 1-502

transaction and, sqls, 1-499

VALUES clause, sqls, 1-499, sqlt, 4-7

expressions with, sqls, 1-506

NULL keyword with, sqls, 1-507

view with, sqls, 1-497, sqlt, 11-30

Inserting,

ActiveX controls, vis_ug, 10-4

alignment panels, vis_ug, 6-10, 6-9

child objects into layers, vis_ug, 5-27

connectors, vis_ug, 6-7

data sources, vis_ug, 3-8

data symbols, vis_ug, 5-22, 6-6

data-bound objects, vis_ug, 5-35

event actions, vis_ug, 9-4

expressions in data sources, vis_ug, 3-9

global parameters, vis_ug, 11-8

layouts, vis_ug, 5-9

levels of detail into a scene, vis_ug, 8-8

levels of detail into data elements, vis_ug, 5-31

parameterized wormholes, vis_ug, 8-12

pictures, vis_ug, 5-17

primitives, vis_ug, 6-5

resources, vis_ug, 11-5

scene parameters, vis_ug, 4-6

scenes, vis_ug, 4-5

simple wormholes, vis_ug, 8-11

static objects, vis_ug, 6-4

stock images, vis_ug, 11-5

viewpoints, vis_ug, 8-5

Installation, sqlr, Glossary-10

options, instll32, 9

order, instll32, 7

using Setup, instll32, 13

Installation directory, specifying with INFORMIXDIR, sqlr, 3-48

Installation files, INFORMIXDIR environment variable, sqlr, 3-47

Installation preparation, instll32, 3

Installation program, instll32, 3

Instance, sqlt, 1-13

example, sqlt, 10-8

INT data type, sqlr, 2-47

INT8 data type, sqlr, 2-47, sqls, 1-866, sqlt, 9-9

casts for, sqlr, 2-27, 2-28

syscolumns coltype code for, sqlr, 1-24

unloading, sqls, 1-771

INTEGER data type, sqlr, 2-48, sqls, 1-866, sqlt, 9-9

casts for, sqlr, 2-27, 2-28

length (syscolumns), sqlr, 1-27

syscolumns coltype code for, sqlr, 1-24

unloading, sqls, 1-771

Integrity. See Data integrity.,

Intensity attributes, setting INFORMIXTERM for, sqlr, 3-52

INTERNAL routine modifier, sqls, 1-1031

Interquery parallelization, sqlr, Glossary-11

Interrupted modifications, sqlt, 4-27

INTERVAL data type, sqlr, 2-48, sqls, 1-871, sqlt, 9-17

DATE, DATETIME with, sqlr, 2-10, 2-15 to

expressions with, sqlr, 2-10

EXTEND function with, sqlr, 2-13

field delimiters, sqlr, 2-50

format, sqlt, 9-18

greater than condition, sqls, 1-1020

length (syscolumns), sqlr, 1-28

loading, sqls, 1-518

syscolumns coltype code for, sqlr, 1-24

with SET DESCRIPTOR, sqls, 1-710

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

Intraquery parallelization, sqlr, Glossary-11

ISAM error code, sqls, 2-49, 2-43, sqlt, 5-10

ISO 8859-1 code set, sqlr, Intro-5, sqls, Intro-6, sqlt, Intro-6, 2-24

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

items table in stores7 database, columns in, sqlr, A-4

iterator function, sqlr, Glossary-11

ITERATOR routine modifier, sqls, 1-1032

ITYPE field,

in X/Open programs, sqls, 1-709

syntax, sqls, 1-433

with SET DESCRIPTOR, sqls, 1-710