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

-e preprocessor option, esqlc, 1-59, 1-49, 1-55

.ec file extension, esqlc, 1-48, 1-81, 1-82, 1-10, gls, 8-11, 7-4

.eco file extension, gls, 7-4

ECO-DAT library routine, gls, 7-8, 7-9

ECO-DEF library routine, gls, 7-10, 7-8

ECO-DSH library routine, gls, 7-23

ECO-DTCVASC library routine, gls, 7-15

ECO-DTTOASC library routine, gls, 7-15

ECO-FEL library routine, gls, 7-17

ECO-FIN library routine, gls, 7-17

ECO-FMT library routine, gls, 7-10, 7-8

ECO-STR library routine, gls, 7-8, 7-9

ECO-USH library routine, gls, 7-23

.ecp file extension, esqlc, 1-48, 1-10

-ED preprocessor option, esqlc, 1-61, 1-52, 1-57

Editing source code, overview, 2-7

Editor, specifying with DBEDIT, sqlr, 3-26

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

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

Element, of a collection, overview, 1-18

elif preprocessor directive, esqlc, 1-16, 1-12

else preprocessor directive, esqlc, 1-16, 1-12

Embedded SQL,

defined, sqlt, 5-4

languages available, sqlt, 5-4

Empty string, esqlc, 3-6

en_us.8859-1 locale, sqlr, Intro-5, sqls, Intro-6, esqlc, Intro-4, sqlt, Intro-6, dapi, Intro-5, extend, Intro-4, udr, Intro-4

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 OF DATA condition. See NOT FOUND condition.,

End-user format, gls_api, 3-4

conversion modifier, gls, 2-29, 2-37

customizing, gls, 1-49

date data, gls, 1-15, 1-19, 1-50, A-9, 2-21, 2-35, 2-26

date format qualifiers, gls, 2-31

default, gls, 1-19

definition of, gls, 1-50, 1-53, 1-12

extended DATE-format strings, gls, 7-10

extended DATETIME format strings, gls, 7-16

monetary data, gls, 2-19, 1-19, A-8, 1-53, 1-14

numeric data, gls, 1-19, A-7, 1-14

printing, gls, 2-38, 1-15, 2-33, 1-13, 1-14

scanning, gls, 2-38, 1-15, 2-32, 1-13, 1-14

sending to database server, gls, 1-39, 1-32

time data, gls, 1-15, 1-19, 1-50, A-9, 2-35

time format qualifiers, gls, 2-38

End-user routine, sqlr, Glossary-7

definition of, extend, 1-9, 2-10

end-user function, extend, 2-10

end-user procedure, extend, 2-10

for an opaque data type, extend, 5-25, 5-8

privileges on, extend, 2-10, 5-25, 2-11

endif preprocessor directive, esqlc, 1-16, 1-12

English locale, gls, 1-30, A-10

See also Default locale.,

See Default locale.,

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

ENVIGNORE environment variable, sqlr, 3-43

chkenv utility with, sqlr, 3-11

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, esqlc, 1-108, gls, 2-5

checking with chkenv utility, sqlr, 3-10

CLIENT_LOCALE, esqlc, 1-106, sqlt, 2-24, gls, 1-28, 2-6

COLLCHAR, esqlc, 1-106

configuration file with, sqlr, 3-6

CPFIRST, esqlc, 1-68

DB_LOCALE, esqlc, 1-106, sqlt, 2-24, gls, 2-17, 1-28

DBALSBC, esqlc, 1-108

DBANSIWARN, sqlr, 3-17, esqlc, 12-18, 1-60, 1-106, 11-31, 11-23

DBAPICODE, gls, 1-45

DBASCIIBC, esqlc, 1-109

DBBLOBBUF, sqlr, 3-19

DBCENTURY, sqlr, 3-20, esqlc, 6-63, 6-44, 6-11, 6-23, 1-109, 6-48, gls, 2-29

DBCODESET, esqlc, 1-109, gls, 1-37, 1-39

DBCONNECT, esqlc, 1-109

DBCSCONV, esqlc, 1-109

DBCSOVERRIDE, esqlc, 1-109

DBCSWIDTH, esqlc, 1-109

DBDATE, sqlr, 3-23, esqlc, 6-63, 1-105, 6-23, 6-48, 6-6, gls, 2-7

DBDELIMITER, sqlr, 3-26

DBEDIT, sqlr, 3-26

DBFLTMASK, sqlr, 3-27, esqlc, 1-109

DBLANG, sqlr, 3-28, esqlc, 1-106, gls, 2-15

DBMONEY, sqlr, 3-29, esqlc, 5-41, 5-30, 5-31, 1-105, 5-44, 5-37, gls, 2-19

DBMONEYSCALE, esqlc, 1-110

DBNLS, esqlc, 1-106, gls, 1-32

DBONPLOAD, sqlr, 3-31

DBPATH, sqlr, 3-31, esqlc, 12-50, 1-105, 12-26

DBPRINT, sqlr, 3-34

DBREMOTECMD, sqlr, 3-35

DBSPACETEMP, sqlr, 3-36

DBSS2, esqlc, 1-110

DBSS3, esqlc, 1-110

DBTEMP, esqlc, 1-105

DBTIME, sqlr, 3-38, esqlc, 6-62, 6-74, 1-105, 6-68, 6-47, gls, 2-20

DBUPSPACE, sqlr, 3-41

DELIMIDENT, sqlr, 3-42, esqlc, 1-107, 1-33, gls, 3-10

ENVIGNORE, sqlr, 3-43

ESQLMF, esqlc, 1-108, gls, 2-22

FET_BUF_SIZE, sqlr, 3-43, esqlc, 14-23, 1-108

GL_DATE, esqlc, 6-63, 6-23, 1-108, 6-48, 6-6, gls, 2-25

GL_DATETIME, esqlc, 1-108, gls, 2-35

GLS-related, gls, 2-4

GLS8BITFSYS, gls, 2-23

IFX_AUTOFREE, sqls, 1-682, 1-683, 1-678, esqlc, 14-25

IFX_DEFERRED, esqlc, 14-32

IFX_DEFERRED_PREPARE, sqls, 1-700

in thread-safe application, esqlc, 13-25

INF_ROLE_SEP, sqlr, 3-53

INFORMIXC, sqlr, 3-44, esqlc, 1-78

INFORMIXCONRETRY, sqlr, 3-45, esqlc, 1-107

INFORMIXCONTIME, sqlr, 3-46, esqlc, 1-107

INFORMIXDIR, sqlr, 3-47, esqlc, 1-48, B-2, 1-106, 1-64

INFORMIXOPCACHE, sqlr, 3-48

INFORMIXSERVER, sqlr, 3-49, esqlc, 16-51, B-2, 12-50, 1-105, 1-119, 12-7, 12-68

INFORMIXSHMBASE, sqlr, 3-50

INFORMIXSQLHOSTS, sqlr, 3-51, esqlc, B-2, 12-7, 12-13

INFORMIXSTACKSIZE, sqlr, 3-51

INFORMIXTERM, sqlr, 3-52

LANG, esqlc, 1-106, gls, 1-32

LC_COLLATE, esqlc, 1-106

LC_CTYPE, esqlc, 1-107

LC_MONETARY, esqlc, 1-107

LC_NUMERIC, esqlc, 1-107

LC_TIME, esqlc, 1-107

LD_LIBRARY_PATH, esqlc, 13-50, 13-9

listed, by topic, sqlr, 3-65

locale-related, gls, 1-28

modifying, sqlr, 3-9

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

ONCONFIG, sqlr, 3-56

OPTCOMPIND, sqlr, 3-57

OPTMSG, esqlc, 12-43

OPTOFC, esqlc, 14-37

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

PATH, sqlr, 3-58, esqlc, B-2, 1-97

PDQPRIORITY, sqlr, 3-58

PLCONFIG, sqlr, 3-60

precedence, esqlc, 1-112

precedence for ALS, gls, 1-38, 1-40, 1-25

precedence for client locale, gls, 1-24

precedence for DATE data, gls, 1-51, 7-14

precedence for DATETIME data, gls, 1-51, 7-17

precedence for monetary data, gls, 1-53, 7-19

precedence for NLS, gls, 1-37, 1-40, 1-25

precedence for server-processing locale, gls, 1-37, 1-39

PSORT_DBTEMP, sqlr, 3-60

PSORT_NPROCS, sqlr, 3-61

retrieving, esqlc, 1-98

rules of precedence, sqlr, 3-11

See also individual environment variable names.,

SERVER_LOCALE, gls, 1-28, 2-41

setting, sqlr, 3-6, esqlc, 1-98

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, esqlc, 13-50, 13-26, 13-27

types of, sqlr, 3-5

view current setting, sqlr, 3-9

Environment variables,

INFORMIXDIR, dbdkug, 8-4, 6-19

INFORMIXSERVER, dbdkug, 8-4

LD_LIBRARY_PATH, dbdkug, 8-4

ONCONFIG, dbdkug, 8-4

PATH, dbdkug, 8-4

TARGET, dbdkug, 6-20, 8-4, 5-38

TESTDB, dbdkug, 8-4

environment variables,

INFORMIXSERVER, dapi, 5-9

SERVERNUM, dapi, 5-9

eprotect utility,

protecting SQL keywords, esqlc, 1-73

-u mode, esqlc, 1-73, 1-69

Equal method, dbdkug, 6-18

Equal method/routine, dbdkug, 7-7, 6-18, 7-9

Equal routine, dbdkug, 6-18

Equal sign. See=, equals operator.,

equal() function, extend, 2-6, 5-23, 4-8

equal() operator function, sqls, 1-1020

equal() support function, extend, 5-22

Equi-join, sqlt, 2-68

Era-based dates,

DATE-format functions, gls, 7-8

DATETIME-format functions, gls, 7-15

DBDATE formats, gls, 2-8, 7-9

DBTIME formats, gls, 2-21, 7-16

defined in locale, gls, A-8

definition of, gls, 1-16

extended-format strings, gls, 7-10, 7-16

GL_DATE formats, gls, 2-29, 1-51

GL_DATETIME formats, gls, 1-51

in DELETE statement, gls, 3-50

in INSERT statement, gls, 3-50

in SQL statements, gls, 3-50

in UPDATE statement, gls, 3-50

sample, gls, 1-16, 2-10, 2-12, 2-13

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

INFORMIX FIND ERROR utility, esqlc, 1-6

Error code, finderr utility, esqlc, 1-6

error descriptor,

copying, dapi, 12-90

destroying, dapi, 12-91

determining if a copy, dapi, 12-92

Error handling,

retrieving an error message, esqlc, 11-48

role of sqlca.h, esqlc, 1-23

See also Exception handling; Warnings.,

using in-line code, esqlc, 11-41

with optimized message transfers, esqlc, 12-45

Error handling functions, gls_api, 4-6

Error message,

DATE-format, gls, 7-23

DATETIME-format, gls, 7-23

GLS-specific, gls, 7-23

in code-set conversion, gls, 1-48, 4-8

numeric-format, gls, 7-23

Error message files, sqlr, Intro-15, sqls, Intro-20, esqlc, Intro-13, sqlt, Intro-12, gls_api, Intro-13, 1-12, dapi, Intro-9, gls, Intro-16, extend, Intro-10, udr, Intro-9

Error message variable, sqlt, 5-13

error messages,

internationalization of, dapi, 12-73

Error messages,

creating new messages, sqlr, 1-34

determining length of, esqlc, 11-11

Informix-specific, esqlc, 11-40, 11-54

internationalizing, gls_api, 1-7

list of error numbers, gls_api, A-1

obtaining parameters, esqlc, 11-29

redirecting, esqlc, 1-65

retrieving error numbers, gls_api, 4-137, 1-20

retrieving text of, esqlc, 11-51, 11-10, 11-47, 11-48

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

See also individual function names.,

trigger failure, sqlt, 15-14

Error number, gls_api, A-1, 4-137

Errors,

-9793 error, dbdkug, 8-5

adding, dbdkug, 5-11

after DELETE, sqlt, 6-4

allocation of error codes, dbdkug, 3-20, Intro-11, 1-11

and SQLSTATE standard, dbdkug, 1-11

C language generated code, in, dbdkug, 5-9

codes for, sqlt, 5-10, dbdkug, 3-20

codes, obtaining, overview, 2-7

DBDK_TRACE_ERROR() macro, dbdkug, 5-12

dealing with, sqlt, 5-17

defining in BladeSmith, dbdkug, 3-19

detected on opening cursor, sqlt, 5-21

documentation of, overview, A-7

during updates, sqlt, 4-27

Informix-specific, sqls, 1-444

inserting with a cursor, sqlt, 6-11

internationalization of, dbdkug, 3-21

ISAM error code, sqlt, 5-10

locale for, dbdkug, 3-21

parameters in, dbdkug, 3-21

properties of, dbdkug, 3-20

raising, dbdkug, 5-12

SQL error text, dbdkug, 3-21

standard messages, dbdkug, 5-17

using BladeManager command line interface, bldmg_ug, 3-14

using BladeManager GUI, bldmg_ug, 2-12

with WHENEVER, sqls, 1-822

errors, dapi, 9-11

Errors, for DataBlade modules, overview, 1-26

Errors. See Exceptions; Runtime errors; Warnings.,

Escape character, esqlc, 9-76, 9-43, 1-19, gls, 3-32

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

Escape characters, multibyte filter for, esqlc, 1-6

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 client-interface DLL, esqlc, 12-14

contents of, esqlc, 1-95

description, esqlc, 1-89

ESQL client-interface library, esqlc, 1-96, 1-85

esql command,

calling C preprocessor and compiler, esqlc, 1-10

compatibility issues, esqlc, 13-12

compile-only options, esqlc, 1-79

library options, esqlc, 13-6

linking options, esqlc, 1-87

options passed implicitly, esqlc, 1-83

preprocessing options, esqlc, 1-59

requirements for using, esqlc, 1-48, 1-10

See also Compiler; Preprocessor.,

steps it performs, esqlc, 1-47

syntax, esqlc, 1-48

syntax on UNIX systems, esqlc, 1-49

version information, esqlc, 1-55, 1-58

Windows options, esqlc, 1-91, 1-92

esql command. See ESQL/C processor.,

ESQL library functions,

currency notation in, gls, 7-20, 7-18

DATE-format functions, gls, 7-8

DATETIME-format functions, gls, 7-15

GLS enhancements, gls, 7-7

GLS error messages, gls, 7-23

numeric-format functions, gls, 7-17

string functions, gls, 7-23

ESQL preprocessor,

stage1, esqlc, 1-9

ESQL program. See ESQL/C program; ESQL/COBOL program.,

ESQL/C,

ActiveX value objects, using with, dbdkug, 7-5

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

identifying routines and data types from, dbdkug, 5-7

inserting collection variables with, sqls, 1-504

inserting row variables, sqls, 1-506

ESQL/C client application,

compiling, gls_api, 1-14

current processing locale, gls_api, 1-11

initializing INFORMIX-GLS, gls_api, 1-19, 4-86

linking INFORMIX-GLS, gls_api, 1-14

localizing, gls_api, 1-9

ESQL/C compiler,

See also C compiler.,

ESQL/C compiler. See Compiler; C compiler.,

ESQL/C conditional compilation directives,

processing of, esqlc, 1-9

ESQL/C data types, gls, 1-48, 4-7, 8-5

boolean, esqlc, 2-13

char, esqlc, 3-4

character data types, esqlc, 3-3

collection, esqlc, 2-4, 2-5, 9-4, 2-12, 2-13

date, esqlc, 2-4, 6-3, 2-11

datetime, esqlc, 2-4, 2-11, 6-28

decimal, esqlc, 2-4, 4-3, 2-12

defined constants for, esqlc, 15-22, 2-7, 2-10

double, esqlc, 2-4, 5-5, 2-12

fixchar, esqlc, 2-4, 3-4, 3-5, 2-11, 2-12

fixed binary, esqlc, 2-5, 2-13

float, esqlc, 2-4, 5-5, 2-12

floating-point data types, esqlc, 5-5

ifx_lo_t, esqlc, 2-5, 2-11, 7-6, 2-13

int8, esqlc, 2-5, 5-7

integer data types, esqlc, 5-4

interval, esqlc, 2-4, 2-12, 6-28

loc_t, esqlc, 2-4, 2-5, 2-11, 8-5, 2-12

long int, esqlc, 5-4, 2-12

lvarchar, esqlc, 3-4, 2-5, 3-9, 2-12, 2-13

row, esqlc, 2-5, 9-48, 2-13

short int, esqlc, 5-4, 2-12

string, esqlc, 2-4, 3-4, 3-5, 2-12

trailing blanks, esqlc, 3-5

var binary, esqlc, 2-5, 2-13

varchar, esqlc, 2-4, 3-4, 3-6, 2-12

ESQL/C define directives, processing of, esqlc, 1-9

ESQL/C filter,

description of, gls, 8-7

invoking, gls, 8-9

non-ASCII characters, gls, 8-8

with CC8BITLEVEL, gls, 8-10, 2-5

with ESQLMF, gls, 8-10, 2-22

ESQL/C function library,

DATE-format functions, gls, 7-10, 7-8, 7-9

DATETIME-format functions, gls, 7-15

dtcvfmtasc(), gls, 7-15

dttofmtasc(), gls, 7-15

era-based dates, gls, 7-10, 7-9

precedence for DATE data, gls, 7-14

precedence for DATETIME data, gls, 7-17

precedence for MONEY data, gls, 7-19

rdatestr(), gls, 7-8, 7-9

rdefmtdate(), gls, 7-10, 7-8

rdownshift(), gls, 7-23

rfmtdate(), gls, 7-10, 7-8

rfmtdec(), gls, 7-17

rfmtdouble(), gls, 7-17

rfmtlong(), gls, 7-20, 7-17, 7-18

rstrdate(), gls, 7-8, 7-9

rupshift(), gls, 7-23

ESQL/C host variables,

using C preprocessor directives to define, esqlc, 1-10

ESQL/C include directives, preprocessing of, esqlc, 1-9

ESQL/C library functions,

character and string functions, esqlc, 3-19

connection functions, esqlc, 12-93

database server control functions, esqlc, 12-35, 12-47, 12-39

DATE type functions, esqlc, 6-5

DATETIME type functions, esqlc, 6-38

DECIMAL type functions, esqlc, 13-30, 4-8

environment variable functions, esqlc, 1-98

error message functions, esqlc, 11-47

formatting functions, esqlc, 5-36

function prototypes, esqlc, 1-25

INT8 type functions, esqlc, 5-9

INTERVAL type functions, esqlc, 6-38

numeric formatting functions, esqlc, 5-36

rdatestr(), gls, 1-13

See also Function library; Macro.,

size and alignment functions, esqlc, 2-23

smart large-object functions, esqlc, 7-33

ESQL/C preprocessor, gls, 2-6, 8-7

ESQL/C preprocessor, stage2, esqlc, 1-9

ESQL/C preprocessor. See Preprocessor.,

ESQL/C processor,

definition of, gls, 7-3

invoking ESQL/C filter, gls, 8-10, 2-5

multibyte characters, gls, 7-4, 2-25

non-ASCII filenames, gls, 7-4, 2-25

non-ASCII source code, gls, 8-10

operating-system files, gls, 7-4

with CC8BITLEVEL, gls, 2-5

with ESQLMF, gls, 8-10, 2-22

ESQL/C program,

accessing NCHARs, gls, 8-6

accessing NVARCHARs, gls, 8-6

checking database connection, gls, 7-25, 1-33

comments, gls, 2-5, 7-6

compiling, gls, 8-9, 8-11

data type constants, gls, 8-13, 8-17, 8-18

filenames, gls, 7-7

handling code-set conversion, gls, 8-12

host variables, gls, 7-6, 1-23

indicator variables, gls, 7-6

literal strings, gls, 2-5, 7-7, 1-23, 1-12

non-ASCII source code, gls, 7-6

See also Client application.,

writing blobs to database, gls, 8-12

ESQL/C program. See Program.,

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

ESQL/COBOL processor, gls, 7-3, 7-4, 2-25

ESQL/COBOL program,

checking database connection, gls, 7-25, 1-33

comments, gls, 7-6

filenames, gls, 7-7

host variables, gls, 7-6, 1-23

indicator variables, gls, 7-6

literal strings, gls, 7-7, 1-23, 1-12

non-ASCII source code, gls, 7-6

See also Client application.,

ESQL/COBOL routine library,

DATE-format routines, gls, 7-10, 7-8, 7-9

DATETIME-format routines, gls, 7-15

ECO-DAT, gls, 7-8, 7-9

ECO-DEF, gls, 7-10, 7-8

ECO-DSH, gls, 7-23

ECO-DTCVASC, gls, 7-15

ECO-DTTOASC, gls, 7-15

ECO-FEL, gls, 7-17

ECO-FIN, gls, 7-17

ECO-FMT, gls, 7-10, 7-8

ECO-STR, gls, 7-8, 7-9

ECO-USH, gls, 7-23

era-based dates, gls, 7-10, 7-9

precedence for DATE data, gls, 7-14

ESQLAUTH sample program, esqlc, 12-16

esqlauth.c authorization file, esqlc, 12-15

esqlauth.dll ESQL client-interface DLL, esqlc, 1-89

esqlauth.dll Informix DLL, esqlc, 12-16

esqlc command. See ESQL/C preprocessor.,

esqlcobol command. See ESQL/COBOL processor.,

ESQLMF environment variable, esqlc, 1-108, gls, 8-10, 2-22

esqlmf filter. See ESQL/C filter.,

ESQLMF.EXE multibyte filter, esqlc, 1-6

Estimates,

query plans, dbdkug, 2-19

routines, dbdkug, 2-15

-EU preprocessor option, esqlc, 1-61, 1-52, 1-57

event description, dapi, 9-3

example DataBlade modules, overview, 2-10

Excalibur Text Search DataBlade module, overview, B-4

exception,

handling, dapi, 9-14

level, dapi, 12-93

server, dapi, 9-10

Exception handling, gls_api, 4-137, 1-20

definition of, esqlc, 11-4

determining number of exceptions, esqlc, 11-8

displaying error text, esqlc, 11-40, 11-54

NOT FOUND condition, esqlc, 11-20, 11-45, 11-35, 11-36

retrieving error message text, esqlc, 11-10, 11-47

runtime errors, esqlc, 11-45, 11-24, 11-38

See also Error handling; NOT FOUND condition; Runtime errors; Warnings.,

success condition, esqlc, 11-20, 11-34

using the WHENEVER statement, esqlc, 11-45

warning conditions, esqlc, 11-22, 11-45, 11-37

with sqlca structure, esqlc, 11-34

with SQLSTATE variable, esqlc, 11-19

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

Exclamation point (!),

wildcard in smart large-object filenames, dapi, 12-360

Exclamation point (!), wildcard in smart-large-object filenames, esqlc, 7-42

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

.exe file extension, esqlc, 1-80, 1-94, 12-21, 1-95

EXEC SQL keywords,

BEGIN DECLARE SECTION. See DECLARE SECTION.,

END DECLARE SECTION. See DECLARE SECTION.,

to declare host variables, esqlc, 1-27

with embedded SQL statements, esqlc, 1-17

with preprocessor directives, esqlc, 1-12

exec() system call, esqlc, 13-25, 12-58

Executable file location, sqls, 1-1012

PATH environment variable, sqlr, 3-58

EXECUTE FUNCTION,

preparing, sqls, 1-402

EXECUTE FUNCTION statement, sqls, 1-397

associated with a cursor, esqlc, 14-50, 14-51, 14-14

defined statement constant, esqlc, 16-23, 17-27, 16-26, 15-18

DESCRIBE with, sqls, 1-341

executing a cursor function, esqlc, 14-50

executing a noncursor function, esqlc, 14-49

for user-defined functions, esqlc, 14-46, 15-27, 14-48

how it works, sqls, 1-398

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

INTO host_var clause, esqlc, 14-48

known at compile time, esqlc, 14-45, 14-48

not known at compile time, esqlc, 15-24, 15-26

parameterized, esqlc, 14-52, 14-54, 15-26

See also User-defined function.,

syntax, sqls, 1-397

with DESCRIBE, esqlc, 17-8, 15-27, 15-16, 16-6, 17-7

with dynamic-management structures, esqlc, 15-27

with sqlda structure, esqlc, 17-26

with system-descriptor area, esqlc, 16-22

EXECUTE IMMEDIATE statement, esqlc, 11-39, 14-42, 14-47

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, udr, 3-21

objects referenced by a routine, sqlt, 14-78, udr, 3-20

EXECUTE PROCEDURE statement, sqls, 1-407 to , esqlc, 14-40, 14-52, 14-46, 15-26, 14-47, 12-34, 15-18

how it works, sqls, 1-409

in FOREACH, sqls, 2-27

INTO clause, sqls, 1-410

See also User-defined procedure.,

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, esqlc, 17-15, 17-28, 17-4

INTO host_var clause, esqlc, 14-43, 11-31, 14-49

INTO keyword, sqls, 1-387

INTO SQL DESCRIPTOR clause, sqls, 1-390, esqlc, 16-22, 16-11, 16-23, 16-4

parameterizing a statement, sqls, 1-393

role in dynamic SQL, esqlc, 14-10

SQLCODE values, esqlc, 11-40

syntax, sqls, 1-385

USING DESCRIPTOR clause, sqls, 1-395, esqlc, 17-41, 17-42, 17-31, 17-43, 17-14, 16-4, 17-4

USING host_var clause, esqlc, 14-52

USING SQL DESCRIPTOR clause, sqls, 1-394, esqlc, 16-30, 16-43, 16-44, 16-11, 16-45, 16-46

with non-SELECT statements known at compile time, esqlc, 14-41

with noncursor functions known at compile time, esqlc, 14-49

with singleton SELECT statements known at compile time, esqlc, 14-43

with user-defined procedures, esqlc, 14-47

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 command, bldmg_ug, 3-16

EXIT statement, sqls, 2-20

exit() system call, esqlc, 11-44, 11-33

Exiting BladeManager command line interface, bldmg_ug, 3-5

EXP function, sqls, 1-918

exp() built-in function, extend, 2-8

Expected errors, bldmg_ug, 2-12, 3-14

Expensive routines, dbdkug, 2-15

Explain file, gls, 1-27

Explicit cast, sqlr, Glossary-8, overview, 1-25, extend, 3-7

Explicit casts, dbdkug, 3-18

Explicit connection, sqlr, Glossary-8

connection handle, esqlc, 12-94

default, esqlc, 12-26

definition of, esqlc, 12-21, 12-17

establishing, esqlc, 12-95, 12-20

identifying, esqlc, 12-31

limits of, esqlc, 12-94

starting, esqlc, 12-20

switching to, esqlc, 12-100

terminating, esqlc, 12-41, 12-98

when to use, esqlc, 12-21

with sqlexit(), esqlc, 12-65

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

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

export support function, dapi, 12-251

ExportBinary routine, dbdkug, 6-18

Exportbinary support function, sqls, 1-772, 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

Exporting runtime routines, esqlc, 1-90

ExportText routine, dbdkug, 6-17

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-based distribution scheme,

in CREATE INDEX, sqls, 1-158

Expresssion,

boolean,

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

example, sqlr, 2-13

extend() built-in function, extend, 2-9

Extended data type, sqlr, Glossary-8, 2-71, 2-20, extend, 5-15, 1-12

Extended data types, sqlt, 9-4

Extended identifier, esqlc, 15-31, 15-13, 15-9, extend, 5-15

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, esqlc, 14-47

definition of, sqlr, Glossary-8

executing, sqls, 1-397, 1-545

executing dynamically, esqlc, 14-50, 16-23, 17-28, 17-29, 16-29, 14-49

iterator function, esqlc, 14-50

name in sysprocedures, sqlr, 1-46

non-variant, sqls, 1-962

registering, sqls, 1-128, udr, 3-10

See also External routine.,

See also User-defined function.,

variant, sqls, 1-962

External procedure, esqlc, 14-47

creating body of, sqls, 1-184

definition of, sqlr, Glossary-8

executing, sqls, 1-545, 1-407

registering, udr, 3-12

See also External routine.,

See also User-defined procedure.,

External routine, esqlc, 14-47

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

library entry point, udr, 3-11

module library, specifying, udr, 3-11

pathname syntax, sqls, 1-1012

preparing, sqls, 1-545

referencing, sqls, 1-961

registering, with modifiers, udr, 3-13

See also Routine; External function; External procedure.,

setting SQLSTATE, sqls, 1-454

specifying library location, udr, 3-11

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 descriptor field, esqlc, 15-9

EXTYPEID field,

syntax, sqls, 1-433

with DESCRIBE, sqls, 1-342

with SET DESCRIPTOR, sqls, 1-711

EXTYPELEN field,

syntax, sqls, 1-433

EXTYPELENGTH descriptor field, esqlc, 15-9

EXTYPELENGTH field,

with DESCRIBE, sqls, 1-342

with SET DESCRIPTOR, sqls, 1-711

EXTYPENAME descriptor field, esqlc, 15-9

EXTYPENAME field,

with DESCRIBE, sqls, 1-342

with SET DESCRIPTOR, sqls, 1-711

EXTYPENM field,

syntax, sqls, 1-433

EXTYPEOWNERLENGTH descriptor field, esqlc, 15-9

EXTYPEOWNERLENGTH field,

with DESCRIBE, sqls, 1-342

with SET DESCRIPTOR, sqls, 1-711

EXTYPEOWNERNAME descriptor field, esqlc, 15-9

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