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 ]

A

.a file extension, esqlc, 1-77

ABS function, sqls, 1-908

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

Access,

restricting to columns or rows, sqlt, 11-23

restricting to view, sqlt, 11-32

restricting with SPL routine, sqlt, 11-19

Access control. See Privilege, database-level, Connect.,

Access method,

CREATE TABLE option, sqls, 1-255

CREATE TABLE with, sqls, 1-255

definition of, sqlr, Glossary-1

index, sqls, 1-138

name clause, sqls, 1-256

primary, sqls, 1-255

secondary, sqls, 1-138

SQL statements for, sqls, 1-14

sysams information about, sqlr, 1-12

Access methods, dbdkug, 2-20

Access mode, sqlt, 7-17

Access mode flags, locks on smart large objects, esqlc, 7-27

Access path selection, dbdkug, 2-19

Access privilege, sqlr, Glossary-1

Accessor methods. See ActiveX value objects, properties of.,

ACOS function, sqls, 1-937, 1-939

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

Active set,

constructing with OPEN, sqls, 1-530, 1-531

cursor, sqlt, 5-24 to

deallocating, sqls, 1-94

of sequential cursor, sqls, 1-414

retrieving data with FETCH, sqls, 1-411

scroll cursor, sqls, 1-416, 1-317

sequential cursor, sqls, 1-316

ActiveX value objects, overview, 1-27

accessing custom methods, dbdkug, 7-5

accessor methods. See ActiveX value objects, properties of.,

client application developer, use by, dbdkug, 7-10, 7-3 to

client projects, dbdkug, 6-4

common files, dbdkug, B-4, 6-16

compiling, dbdkug, 6-19 to

creating, dbdkug, 6-3 to

custom methods, dbdkug, 7-8

debugging, dbdkug, 6-7

defining underlying opaque type, dbdkug, 6-9

definition, dbdkug, 6-4

designing, dbdkug, 6-7

files to edit, dbdkug, 6-17

generated files, dbdkug, 6-13, 6-14, B-1 to

guidelines, design, dbdkug, 6-7

guidelines, programming, dbdkug, 6-16

implementing, dbdkug, 6-14 to

installation, dbdkug, 7-4

instantiating, dbdkug, 7-5

internal methods, dbdkug, 6-25

opaque types, dbdkug, 6-8

programming guidelines, dbdkug, 6-16

properties of, dbdkug, 6-10 to

names, dbdkug, 6-11

referencing in Visual Basic, dbdkug, 7-4

restrictions, dbdkug, 6-10, 6-3, 6-16, 6-7, 6-8

server projects, dbdkug, 6-5

source code, dbdkug, 6-14

support methods, dbdkug, 6-25 to

testing, dbdkug, 6-7

add client command, bldmg_ug, 3-15

Aggregate expression. See Aggregate function;Expression segment.,

Aggregate function, esqlc, 11-31, 1-42, 1-43, 11-15

and GROUP BY clause, sqlt, 3-5

behavior of, example, sqls, 1-956

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

error checking with external (ESQL) function, sqls, 1-958

error checking,

counting selected rows with COUNT, sqls, 1-958

empty rows (indicator variable), sqls, 1-958

for an opaque type, extend, 5-22, 5-8

in ESQL, sqlt, 5-14

in subquery, sqlt, 3-32

restrictions, sqls, 1-948

restrictions in modifiable view, sqlt, 11-29

restrictions with GROUP BY, sqls, 1-631

rowid not allowed with, sqls, 1-890

Aggregate functions, sqls, 1-946 to

Aggregates, dbdkug, 2-17

combine function, dbdkug, 3-16

defining in BladeSmith, dbdkug, 3-12

final function, dbdkug, 3-16

functions declarations in C source code, dbdkug, 5-5

initialization function, dbdkug, 3-15

initialization parameter, dbdkug, 3-15

iteration function, dbdkug, 3-16

iteration type for, dbdkug, 3-13

name, dbdkug, 3-14

overloading existing, dbdkug, 3-15

properties of, dbdkug, 3-13

return type for, dbdkug, 3-13

state type, dbdkug, 3-15

templates, dbdkug, 3-13

Algebraic functions, sqls, 1-905 to

Algorithm,

for adding columns to tables, sqls, 1-59

Alias,

SELECT with, sqls, 1-610, 1-599

SELECT...AS with, sqls, 1-613

SELECT...FROM with, sqlt, 2-74

table name replacement, sqlt, 2-74

to assign column names in temporary table, sqlt, 3-13

typed table with, sqlt, 12-6

use before define, sqlt, 2-74

use with GROUP BY clause, sqls, 1-630, 1-634

ALLOCATE COLLECTION statement, esqlc, 9-12

ALLOCATE DESCRIPTOR statement, sqls, 1-27, esqlc, 16-4, 16-5

syntax, sqls, 1-22

WITH MAX clause, sqls, 1-25

ALLOCATE ROW statement, esqlc, 9-57

Allocating memory,

for fetch arrays, esqlc, 15-38

with ALLOCATE COLLECTION, sqls, 1-22

Allocation extent size, esqlc, 7-75, 7-66, 7-9, dapi, 12-330, 12-320, 3-48

Alnum class, gls_api, 4-88, 2-11, 2-13

Alpha class, gls_api, 4-90, 4-113, 4-115, 4-88, 2-11, 2-13

Alphabetic character,

case ignored, gls_api, 4-90, 4-113, 4-115, 4-88, 2-13

definition of, gls_api, 2-11

lowercase, gls_api, 4-101, 4-125, 2-11, 2-13

uppercase, gls_api, 4-133, 2-11, 4-109, 2-13

ALS. See Asian Language Support (ALS).,

ALS. See Asian Language Support.,

ALTER FRAGMENT statement,

ADD Clause, sqls, 1-46

ATTACH clause, sqls, 1-32 to

example, sqls, 1-36

DETACH clause, sqls, 1-37

DROP clause, sqls, 1-48

effects on large objects, triggers, constraints, indexes, sqls, 1-33

example, sqlt, 9-49

INIT clause, sqls, 1-38, sqlt, 9-50, 9-53

logging, sqls, 1-31

MODIFY clause, sqls, 1-49

privileges, sqls, 1-30

ALTER INDEX, sqls, 1-52

ALTER INDEX statement, esqlc, 12-52, 12-34, 15-18

creating clustered index, sqls, 1-52

dropping clustered index, sqls, 1-53

TO CLUSTER clause, sqls, 1-53

ALTER TABLE,

DEFAULT clause, sqls, 1-61

ALTER TABLE statement, esqlc, 12-52, 12-34, 15-17, gls, 3-11, 3-48, extend, 5-28

ADD clause, sqls, 1-58

ADD CONSTRAINT clause, sqls, 1-81

ADD ROWIDS clause, sqlt, 9-53

ADD TYPE clause, sqls, 1-86

BEFORE option, sqls, 1-74

casting effects, sqlr, 2-26

CHECK clause, sqls, 1-73

constraint mode definition, sqls, 1-65

DROP clause, sqls, 1-75

DROP CONSTRAINT clause, sqls, 1-85

DROP ROWIDS clause, sqlt, 9-53

LOCK MODE clause, sqls, 1-88

MODIFY NEXT SIZE clause, sqlr, 1-10

ON DELETE CASCADE option, sqls, 1-71

PAGE keyword, sqls, 1-88

privileges for See Privilege, table-level.,

REFERENCES clause, sqls, 1-68

ROW keyword, sqls, 1-88

ROWIDS clause, sqls, 1-88

setting columns NOT NULL, sqls, 1-64

Alternative date formats, gls, 2-29

Alternative time formats, gls, 2-37

American National Standards Institute. See ANSI.,

Ampersand (&) symbol, esqlc, 5-30

AND logical operator, sqls, 1-853

ANSI, sqlt, 1-16

ANSI C standards, esqlc, 13-25

ANSI compliance,

-ansi flag, sqlr, 3-17, sqls, 1-214, 1-206, 1-291, Intro-14

checking for (DBANSIWARN), sqlr, 3-18

DBANSIWARN environment variable, sqlr, 3-17

icon, sqlr, Intro-10, sqls, Intro-12, extend, Intro-8, udr, Intro-8

Informix SQL solution, sqlt, 1-16

level, sqlr, Intro-16, sqls, Intro-21, sqlt, Intro-13, gls, Intro-18, extend, Intro-11, udr, Intro-10

reserved words, sqls, 1-968

SQL statements, sqls, 1-19

SQLSTATE variable, sqls, 1-444

table naming, sqls, 1-572

updating rows, sqls, 1-782

ANSI compliance level, dapi, Intro-10

ANSI compliance, level, esqlc, Intro-15

-ansi preprocessor option, esqlc, 12-18, 1-52, 1-57

See also ANSI SQL standards.,

ANSI SQL standards,

checking for Informix extensions, esqlc, 12-18, 11-31, 11-23, 11-15

connecting to a database, esqlc, 12-18

declaring host variables, esqlc, 1-27

defining ESQL/C function prototypes, esqlc, 1-23

delimiting identifiers, esqlc, 1-32

delimiting strings, esqlc, 1-32

escape character, esqlc, 1-19

for datetime and interval values, esqlc, 6-71, 6-36, 6-59

getting diagnostic information, esqlc, 11-6

preparing SQL statements, esqlc, 14-5

See also ansi preprocessor option; ANSI-compliant database.,

specifying host variables, esqlc, 1-21

SQLSTATE class values, esqlc, 11-14

using EXEC SQL keywords, esqlc, 1-13

using GOTO in WHENEVER, esqlc, 11-46

using INDICATOR keyword, esqlc, 1-45, 1-46

warning values, esqlc, 11-22

ANSI-compliant database,

BEGIN WORK with, sqls, 1-92

CHARACTER VARYING data type, sqls, 1-863

constraint naming, sqls, 1-855

criteria for, sqls, 1-118

cursor in, sqls, 1-310, 1-311, 1-313

determining, esqlc, 11-30, 11-22, 12-27, 11-15

FOR UPDATE not required in, sqlt, 6-16

function naming, sqls, 1-1009, 1-964

index naming, sqls, 1-985

indicating NOT FOUND condition, esqlc, 11-20, 11-35

inserting character data, esqlc, 3-18

logging restrictions, sqlt, 9-40

nonstandard syntax in sqlwarn, esqlc, 11-31

opaque-type naming, sqls, 1-168

operator-class naming, sqls, 1-175

procedure name, sqls, 1-472, 1-583, 1-816

routine resolution, udr, 2-8

routine signature, udr, 2-5

SQLNOTFOUND, sqls, 1-396

SQLWARN flag, sqlt, 5-12

synonym naming, sqls, 1-1047

table name with, sqls, 1-1049

table privileges, sqls, 1-221, sqlt, 11-8

USER function, sqls, 1-895

view naming, sqls, 1-1052

ANSI-style parameters as host variables, esqlc, 1-40

Answers OnLine CD, dbdkug, Intro-10, bldmg_ug, Intro-8

API. See Application programming interfaces.,

API.See Application programming interface (API).,

APIs, client, dbdkug, 7-10, 7-3 to

Application,

design of order-entry, sqlt, 4-27

handling errors, sqlt, 5-17

process, sqlr, Glossary-1

program, sqlr, Glossary-1

single-threaded, sqls, 1-687

thread-safe, sqls, 1-687, 1-690

Application programming interface (API), sqlr, Glossary-1

Application programming interfaces,

DataBlade API, overview, 1-11

documentation of, overview, A-6

INFORMIX-ESQL\xda C, overview, 1-12

INFORMIX-GLS, overview, 1-11

Object Interface for C++, overview, 1-11

Arbitrary rule, sqls, 1-160

ARC_DEFAULT environment variable, sqlr, 3-16

ARC_KEYPAD environment variable, sqlr, 3-16

Archiving,

description of, sqlt, 4-31, 1-9

personal default qualifier file (ARC_DEFAULT), sqlr, 3-16

remote shell for (DBREMOTECMD), sqlr, 3-35

tctermcap file for (ARC_KEYPAD), sqlr, 3-16

Argument, sqlr, Glossary-1, sqls, 1-829 to

data type does not match parameter data type, udr, 2-11, 2-12

data-type cast, udr, 2-15

Argument list,

distinct data type in, udr, 2-11

modal, udr, 3-5

order of, udr, 2-8

prefered format, udr, 3-5

size, udr, 3-5

Arguments, for user-defined routines, dbdkug, 3-26

Arithmetic functions. See Algebraic functions.,

Arithmetic operations,

datetime data, esqlc, 6-36

decimal data, esqlc, 4-7

description of, esqlc, 2-19

int8 data, esqlc, 5-8

interval data, esqlc, 6-36

Arithmetic operator,

binary, sqls, 1-959

description of, extend, 2-5

expression with, sqls, 1-959

for an opaque type, extend, 5-20

SELECT with, sqlt, 2-45

unary, sqls, 1-960

Array,

and truncated SQL value, esqlc, 1-44

definition of, sqlr, Glossary-2

dimension limit, esqlc, 1-36

in a host-variable typedef, esqlc, 1-38

moving rows into with FETCH, sqls, 1-418

of host variables, esqlc, 1-36

Array size,

multibyte-character string, gls_api, 2-40

wide-character string, gls_api, 2-41

Arrays as ActiveX properties, dbdkug, 6-12

as formatting character, gls, 7-20

ASCII code set, sqls, 1-1022, gls_api, 2-4, gls, 1-19

Asian character, gls_api, 1-22

Asian date. See Era-based dates.,

Asian Language Support (ALS),

code-set conversion with, gls, 1-46

collation order, gls, 1-12

DBDATE support, gls, 7-12, 2-7

DBTIME support, gls, 2-20

information in systables, gls, 1-26

multibyte data, gls, 1-4

precedence of environment variables, gls, 1-38, 1-40, 1-25

reverting to, gls, 5-10

Asian language. See Multibyte character.,

ASIN function, sqls, 1-939

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

ASKPASSATCONNECT network parameter, esqlc, 1-108, 12-14, 12-15

Assign support function, sqls, 1-793, 1-523, 1-503, 1-518, 1-172

assign() support function, dapi, 12-294, 12-231, 3-81, 12-267, 3-55

description of, extend, 5-6, 6-19

for smart large objects, extend, 6-22

mi_large_object_expand(), dapi, 12-227

summary of, extend, 6-4

Assign/Destroy routines, dbdkug, 5-30

Asterisk (*) symbol,

as formatting character, esqlc, 5-30

as overflow character, esqlc, 2-17, 6-35

ATAN function, sqls, 1-939

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

ATAN, ATAN2 functions, sqls, 1-939

ATAN2 function, sqls, 1-939

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

ATL project files, dbdkug, B-2, B-5

Attached index, sqlr, Glossary-2

Attribute,

identifying, sqlt, 8-17

important qualities of, sqlt, 8-17

nondecomposable, sqlt, 8-17

Attributes flag, dapi, 12-332, 3-48

AUTOFREE feature, sqls, 1-677, esqlc, 14-24

enabling, esqlc, 14-25

for a particular cursor, esqlc, 14-25

with Deferred PREPARE and OPTOFC features, esqlc, 14-39

Automatic type conversion. See Data type conversion.,

Auxiliary statements, sqlr, Glossary-2

AVG function, sqls, 1-953