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 ]

E

Editor, specifying with DBEDIT, sqlr, 3-26

Editors,

Data Element, vis_ug, 1-16, 1-7, 5-9

manipulating objects in, vis_ug, 12-7

printing from, vis_ug, 12-5

Query, vis_ug, 1-7, 1-14

Scene, vis_ug, 1-15, 1-7, 5-9

World Structure, vis_ug, 1-17, 1-7

Elbow connectors,

illustration of, vis_ug, 5-23

properties of, vis_ug, A-23

Element, sqlr, Glossary-7, sqlt, 10-14

Element locator properties, vis_ug, A-25

Element type, sqlr, Glossary-7, sqlt, 10-14

Ellipse properties, vis_ug, A-26

Embedded SQL,

defined, sqlt, 5-4

languages available, sqlt, 5-4

Empty layouts, vis_ug, 5-10, 5-16

en_us.8859-1 locale, sqlr, Intro-5, sqls, Intro-6, sqlt, Intro-6

Enabled object mode, sqls, 1-657

benefits of, sqls, 1-671

defined, sqlr, Glossary-7, sqlt, 4-25

End of data,

signal in SQLCODE, sqlt, 5-9, 5-18

when opening cursor, sqlt, 5-21

with WHENEVER, sqls, 1-823

End-user routine, sqlr, Glossary-7

Enterprise Client Software Developer's Kit,

component descriptions, instll32, 9

documentation for, instll32, 2

Entity,

attributes associated with, sqlt, 8-17

business rules, sqlt, 8-5

criteria for choosing, sqlt, 8-8

defined, sqlt, 8-5

important qualities of, sqlt, 8-6

in telephone-directory example, sqlt, 8-9

naming, sqlt, 8-5

occurrence of, sqlt, 8-18

Entity integrity, sqlt, 4-19

Entity-relationship diagram,

connectivity, sqlt, 8-20

discussed, sqlt, 8-19

meaning of symbols, sqlt, 8-19

reading, sqlt, 8-20

Enumerated types, vis_ug, B-5

ENVIGNORE environment variable, sqlr, 3-43

chkenv utility with, sqlr, 3-11

Environment configuration, instll32, 19

Environment configuration file, sqlr, 3-6

chkenv utility for, sqlr, 3-10

common ($INFORMIXDIR/etc/informix.rc), sqlr, 3-11

debugging with chkenv, sqlr, 3-11

ignoring errors in (ENVIGNORE), sqlr, 3-11

locations, sqlr, 3-11

private (.informix/informix.rc), sqlr, 3-11

Environment variable, sqlr, 3-5 to

ARC_DEFAULT, sqlr, 3-16

ARC_KEYPAD, sqlr, 3-16

CC8BITLEVEL, instll32, 25

checking with chkenv utility, sqlr, 3-10

CLIENT_LOCALE, instll32, 25, sqlt, 2-24

COLLCHAR, instll32, 25

configuration file with, sqlr, 3-6

DB_LOCALE, instll32, 25, sqlt, 2-24

DBALSBC, instll32, 25

DBANSIWARN, instll32, 25, sqlr, 3-17

DBAPICODE, instll32, 26

DBASCIIBC, instll32, 26

DBBLOBBUF, sqlr, 3-19

DBCENTURY, instll32, 26, sqlr, 3-20

DBCODESET, instll32, 26

DBCONNECT, instll32, 26

DBCSCONV, instll32, 26

DBCSOVERRIDE, instll32, 26

DBCSWIDTH, instll32, 27

DBDATE, instll32, 27, sqlr, 3-23

DBDELIMITER, sqlr, 3-26

DBEDIT, sqlr, 3-26

DBFLTMASK, instll32, 27, sqlr, 3-27

DBLANG, instll32, 27, sqlr, 3-28

DBMONEY, instll32, 27, sqlr, 3-29

DBMONEYSCALE, instll32, 27

DBNLS, instll32, 28

DBONPLOAD, sqlr, 3-31

DBPATH, instll32, 28, sqlr, 3-31

DBPRINT, sqlr, 3-34

DBREMOTECMD, sqlr, 3-35

DBSPACETEMP, sqlr, 3-36

DBSS2, instll32, 28

DBSS3, instll32, 28

DBTEMP, instll32, 28

DBTIME, instll32, 28, sqlr, 3-38

DBUPSPACE, sqlr, 3-41

DELIMIDENT, instll32, 28, sqlr, 3-42

ENVIGNORE, sqlr, 3-43

ESQLMF, instll32, 28

FET_BUF_SIZE, instll32, 29, sqlr, 3-43

GL_DATE, instll32, 29

GL_DATETIME, instll32, 29

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

IFX_DEFERRED_PREPARE, sqls, 1-700

INF_ROLE_SEP, sqlr, 3-53

INFORMIXC, sqlr, 3-44

INFORMIXCONRETRY, instll32, 25, sqlr, 3-45

INFORMIXCONTIME, instll32, 25, sqlr, 3-46

INFORMIXDIR, instll32, 29, sqlr, 3-47

INFORMIXOPCACHE, sqlr, 3-48

INFORMIXSERVER, instll32, 29, sqlr, 3-49

INFORMIXSHMBASE, sqlr, 3-50

INFORMIXSQLHOSTS, instll32, 29, sqlr, 3-51

INFORMIXSTACKSIZE, sqlr, 3-51

INFORMIXTERM, sqlr, 3-52

LANG, instll32, 29

LC_COLLATE, instll32, 29

LC_CTYPE, instll32, 30

LC_MONETARY, instll32, 30

LC_NUMERIC, instll32, 30

LC_TIME, instll32, 30

listed, by topic, sqlr, 3-65

modifying, sqlr, 3-9

NODEFDAC, sqlr, 3-56, sqls, 1-129, 1-185

ONCONFIG, sqlr, 3-56

OPTCOMPIND, sqlr, 3-57

overriding a setting (ENVIGNORE), sqlr, 3-43

PATH, sqlr, 3-58

PDQPRIORITY, sqlr, 3-58

PLCONFIG, sqlr, 3-60

PSORT_DBTEMP, sqlr, 3-60

PSORT_NPROCS, sqlr, 3-61

rules of precedence, sqlr, 3-11

setting, sqlr, 3-6

setting shell, sqlr, 3-8

setting,

with SYSTEM statement, sqls, 2-55

TERM, sqlr, 3-63

TERMCAP, sqlr, 3-63

TERMINFO, sqlr, 3-64

THREADLIB, sqlr, 3-65

types of, sqlr, 3-5

view current setting, sqlr, 3-9

WIN32ASKPASSATCONNECT, instll32, 31

WIN32HOST, instll32, 30

WIN32PASS, instll32, 30

WIN32PROTOCOL, instll32, 31

WIN32SERVICE, instll32, 31

WIN32USER, instll32, 30

Environment variables, vis_ug, Intro-6

Environment variables, setting, instll32, 19

Equal sign. See=, equals operator.,

equal() operator function, sqls, 1-1020

Equi-join, sqlt, 2-68

Error checking,

continuing after procedure error, sqls, 2-47

error status with ON EXCEPTION, sqls, 2-44

simulating errors, sqlt, 14-87

SPL routine, sqlt, 14-84 to

with SYSTEM, sqls, 2-55

Error message files, sqlr, Intro-15, sqls, Intro-20, sqlt, Intro-12

Error message variable, sqlt, 5-13

Error messages, vis_ug, 1-19

creating new messages, sqlr, 1-34

retrieving trigger text in a program, sqlt, 15-15, 15-17

trigger failure, sqlt, 15-14

Errors,

after DELETE, sqlt, 6-4

codes for, sqlt, 5-10

dealing with, sqlt, 5-17

detected on opening cursor, sqlt, 5-21

during updates, sqlt, 4-27

Informix-specific, sqls, 1-444

inserting with a cursor, sqlt, 6-11

ISAM error code, sqlt, 5-10

with WHENEVER, sqls, 1-822

Escape character. See\, backslash; Condition, comparison, ESCAPE.,

ESQL,

DELETE statement in, sqlt, 6-3

delimiting host variables, sqlt, 5-6

dynamic embedding, sqlt, 5-5, 5-29

error handling, sqlt, 5-17

host variable, sqlt, 5-6, 5-8

indicator variable, sqlt, 5-16

INSERT in, sqlt, 6-9

overview, sqlt, 5-3 to , 5-37, 6-3 to

preprocessor, sqlt, 5-4

See also External routine; External function;External procedure.,

selecting single rows, sqlt, 5-14

SQL Communications Area, sqlt, 5-8

SQLCODE, sqlt, 5-9

SQLERRD fields, sqlt, 5-10

static embedding, sqlt, 5-5

UPDATE in, sqlt, 6-15

ESQL/C, instll32, 10

collection cursor with FETCH, sqls, 1-422

collection cursor with PUT, sqls, 1-563

cursor example, sqls, 1-318

deallocating collection variable memory, sqls, 1-297

deallocating row variable memory, sqls, 1-301

DISCONNECT statement in, sqls, 1-348

inserting collection variables with, sqls, 1-504

inserting row variables, sqls, 1-506

ESQL/C Smart-Large-Object API, sqlr, Glossary-8

ESQLMF environment variable, instll32, 28

Event actions, vis_ug, D-1, 1-7

and executing commands, vis_ug, 9-4

and global parameters, vis_ug, 11-10

and scene parameters, vis_ug, 4-6

creating, vis_ug, 9-4

definition of, vis_ug, 9-3

example of using, vis_ug, 11-10

modifying, vis_ug, 11-11

selecting viewpoints when defining, vis_ug, 11-12

setting parameters when defining, vis_ug, 11-12, 9-6

to execute navigation, vis_ug, 9-4

types of events in, vis_ug, D-2, 9-3

Event band charts,

description of, vis_ug, 5-5

properties of, vis_ug, A-28

Event bands,

description of, vis_ug, 5-21

properties of, vis_ug, A-27

Events page, vis_ug, 9-8, 1-18, 11-11, 9-5, 7-8

Exceptions. See End of data; Errors; Error checking; Warning.,

Exclamation point . See !, exclamation point.,

Exclusive access, sqlr, Glossary-8

specifying in DATABASE statement, sqls, 1-296

specifying in LOCK TABLE statement, sqls, 1-526

Exclusive lock, sqlr, Glossary-8

SeeLock,

exclusive.,

Executable file location, sqls, 1-1012

PATH environment variable, sqlr, 3-58

EXECUTE FUNCTION,

preparing, sqls, 1-402

EXECUTE FUNCTION statement, sqls, 1-397

DESCRIBE with, sqls, 1-341

how it works, sqls, 1-398

INTO clause, sqls, 1-399, 1-417

syntax, sqls, 1-397

EXECUTE IMMEDIATE statement,

description of, sqlt, 5-34

restricted statements, sqls, 1-405

syntax and usage, sqls, 1-404

Execute privilege,

DBA keyword, effect of, sqlt, 14-78

objects referenced by a routine, sqlt, 14-78

EXECUTE PROCEDURE statement, sqls, 1-407 to

how it works, sqls, 1-409

in FOREACH, sqls, 2-27

INTO clause, sqls, 1-410

syntax, sqls, 1-407

EXECUTE statement,

and sqlca record, sqls, 1-395

Deferred-PREPARE feature with, sqls, 1-699

description of, sqlt, 5-32

error conditions with, sqls, 1-395

INTO DESCRIPTOR clause, sqls, 1-391

INTO keyword, sqls, 1-387

INTO SQL DESCRIPTOR clause, sqls, 1-390

parameterizing a statement, sqls, 1-393

syntax, sqls, 1-385

USING DESCRIPTOR clause, sqls, 1-395

USING SQL DESCRIPTOR clause, sqls, 1-394

Execution time,

varying length data types influences, sqlt, 9-23

Existence dependency, sqlt, 8-10

EXISTS keyword,

in a WHERE clause, sqlt, 3-30

EXIT statement, sqls, 2-20

EXP function, sqls, 1-918

Explicit cast, sqlr, Glossary-8

Explicit connection, sqlr, Glossary-8

Explicit select list, sqlr, Glossary-8

Explicit temporary table, sqls, 1-218

Exponential function, sqls, 1-918

Export support function, sqls, 1-772, 1-172

Exportbinary support function, sqls, 1-772, 1-172

Expression, sqls, 1-881 to

aggregate, sqls, 1-946 to

boolean, sqls, 1-837

condition with, sqls, 1-836

cast allowed in, sqlt, 13-3

casting, sqls, 1-885

column, sqls, 1-886

combined expressions, sqls, 1-959

concatenating, sqls, 1-883

constant, sqls, 1-892 to

display label for, sqlt, 2-48

fragment, sqls, 1-35

function, sqls, 1-903 to

in UPDATE, sqls, 1-788

ordering by, sqls, 1-638

smart large objects in, sqls, 1-891

Expression Editor,

about toolbar, vis_ug, 3-11

choosing columns in, vis_ug, 3-10

using, vis_ug, 3-11, 3-9

Expression-based distribution scheme,

in CREATE INDEX, sqls, 1-158

Expressions,

defining, vis_ug, 3-11

in queries, vis_ug, 3-7, 3-9

Expresssion,

boolean,

EXTEND function, sqls, 1-932, 1-935, sqlt, 2-58

example, sqlr, 2-13

Extended data type, sqlr, Glossary-8, 2-71, 2-20

Extended data types, sqlt, 9-4

Extensibility,

description of, sqlt, 1-10

Extension, to SQL,

checking for with DBANSIWARN environment variable, sqlr, 3-17

symbol for, sqls, Intro-14

Extent,

changing size of system table, sqlr, 1-10

revising size, sqls, 1-254

size, sqls, 1-87

External function,

aggregate function with, sqls, 1-958

as operator-class strategy function, sqls, 1-177

as operator-class support function, sqls, 1-178

CREATE FUNCTION, sqls, 1-128

definition of, sqlr, Glossary-8

executing, sqls, 1-397, 1-545

name in sysprocedures, sqlr, 1-46

non-variant, sqls, 1-962

registering, sqls, 1-128

See also External routine.,

variant, sqls, 1-962

External procedure,

creating body of, sqls, 1-184

definition of, sqlr, Glossary-8

executing, sqls, 1-545, 1-407

See also External routine.,

External routine,

comments in, sqls, 1-12

compiling multithreaded applications, sqlr, 3-65

concatenation operator with, sqls, 1-884

CREATE PROCEDURE FROM statement in, sqls, 1-192

creating a function in, sqls, 1-135

DEALLOCATE COLLECTION statement, sqls, 1-297

definition of, sqlr, Glossary-8

ill-behaved, sqls, 1-1030

languages supported in sysroutinelangs, sqlr, 1-51

pathname syntax, sqls, 1-1012

preparing, sqls, 1-545

referencing, sqls, 1-961

See also Routine; External function; External procedure.,

setting SQLSTATE, sqls, 1-454

sysprocauth (Execute privileges) information, sqlr, 1-44

sysprocedures information, sqlr, 1-46

External routine reference,

example, sqls, 1-962

External Routine Reference segment, sqls, 1-961

External space, sqlr, Glossary-8

EXTYPEID field,

syntax, sqls, 1-433

with DESCRIBE, sqls, 1-342

with SET DESCRIPTOR, sqls, 1-711

EXTYPELEN field,

syntax, sqls, 1-433

EXTYPELENGTH field,

with DESCRIBE, sqls, 1-342

with SET DESCRIPTOR, sqls, 1-711

EXTYPENAME field,

with DESCRIBE, sqls, 1-342

with SET DESCRIPTOR, sqls, 1-711

EXTYPENM field,

syntax, sqls, 1-433

EXTYPEOWNERLENGTH field,

with DESCRIBE, sqls, 1-342

with SET DESCRIPTOR, sqls, 1-711

EXTYPEOWNERNAME field,

with DESCRIBE, sqls, 1-342

with GET DESCRIPTOR, sqls, 1-439

with SET DESCRIPTOR, sqls, 1-711

EXTYPEOWNNM field,

syntax, sqls, 1-433

EXTYPOWNLEN field,

syntax, sqls, 1-433

See alsoCondition, comparison.,