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 ]

C

C code,

advantages and disadvantages of using versus C++, dbdkug, 6-5

casting functions, dbdkug, 5-36

comments in, dbdkug, 5-8

compiling on UNIX, dbdkug, 5-38

compiling on Windows NT, dbdkug, 5-39

DataBlade API tips, dbdkug, 4-15

definitions, dbdkug, A-1

definitions files, dbdkug, 5-4

error handling, dbdkug, 5-9

generated files, dbdkug, A-1, 5-4

global and static variables, avoiding, dbdkug, 4-13

header files, dbdkug, A-1, B-4, 5-4

iterator functions for, dbdkug, 5-35

makefiles, dbdkug, A-1, 5-41, 5-4, 5-5, 5-36, 5-39

MI_FPARAM structure in, dbdkug, 5-8

MMX support, dbdkug, 3-53

opaque data type support routines, dbdkug, 5-21

overview of tasks, dbdkug, 5-6

POSIX calls allowed, dbdkug, 4-11

private state, tracking with MI_FPARAM, dbdkug, 4-14

programming guidelines, dbdkug, 4-10 to

readme files, dbdkug, A-1

server connection handle, dbdkug, 5-9

signals, avoiding, dbdkug, 4-13

source files, dbdkug, A-1, 5-4, 5-5

system and library calls, avoiding, dbdkug, 4-10

system calls in user-defined virtual processors, dbdkug, 4-10

thread safety, dbdkug, 4-13

tracing in, dbdkug, 5-9

utility functions generated, dbdkug, 5-19

yielding, dbdkug, 4-14

C compiler,

ANSI C, esqlc, 1-26, 1-25

-bc option, esqlc, 1-79

8-bit clean, gls, 8-8

Borland, esqlc, 1-79

-c option, esqlc, 1-84, 1-79

called by esql, esqlc, 1-11

#define preprocessor statement, esqlc, 1-15

generating thread-safe code, esqlc, 13-27

#include preprocessor statement, esqlc, 1-26, 1-63, 1-14

initializer expressions, esqlc, 1-29

limitations, gls, 7-4, 8-7

linking in other files, esqlc, 1-87

-mc option, esqlc, 1-80

Microsoft, esqlc, 1-80

multibyte characters, gls, 8-7, 8-8

naming restrictions, esqlc, 1-28

non-ASCII filenames, gls, 7-4

non-ASCII source code, gls, 8-7, 8-8

options invoked implicitly, esqlc, 1-83

passing arguments to, esqlc, 1-91, 1-81, 1-76, 1-79

passing options to, esqlc, 1-77

passing source files to, esqlc, 1-79

role in compiling ESQL/C programs, esqlc, 1-10

See also ESQL/C compiler.,

specifying, esqlc, 1-81, 1-78

C compiler (INFORMIXC), sqlr, 3-44

.c file extension, esqlc, 1-59, 1-81, 1-9, 11-33, 13-14, 1-87, 1-77, 1-79, gls, 8-11, 7-4

C header files,

for conditional compilation of ESQL/C programs, esqlc, 1-67

for defining host variables, esqlc, 1-67

including in EXEC SQL declare section, esqlc, 1-71

shared between ESQL/C and C programs, esqlc, 1-70

C language,

compiling source code in, overview, 2-7

source code in, overview, 2-4

writing DataBlade module routines, overview, 1-22

C omments symbol. See--, double dash; {}, curly brackets.,

C preprocessor,

role in compiling ESQL/C programs, esqlc, 1-10

running first, esqlc, 1-10, 1-67

C preprocessor directives, using to define ESQL/C host variables, esqlc, 1-10

-c processor option, esqlc, 1-81, 1-84, 1-79

C programs, compiling, esqlc, 1-87

C shell,

.cshrc file, sqlr, 3-8

.login file, sqlr, 3-8

setting environment variables, sqlr, 3-8

C++ code,

advantages and disadvantages of using versus C, dbdkug, 6-5

class files, dbdkug, B-3, B-5

comments in, dbdkug, 6-14

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

compiling, dbdkug, 6-19

files to edit, dbdkug, 6-17

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

header files, dbdkug, B-2, B-3, B-4, B-5, 6-27

makefiles, dbdkug, 6-20, 6-21, 6-23

restrictions, dbdkug, 6-3, 6-5, 6-16

source files, dbdkug, B-3, B-4, B-5

support library, dbdkug, B-2, B-4, 6-34, 6-27 to

C++ code in DataBlade modules, overview, 1-27

C++ Interface API, using with ActiveX value objects, dbdkug, 7-6

.c_ file extension, gls, 8-11

Calculated expression, restrictions with GROUP BY, sqls, 1-631

CALL statement, sqls, 2-4

call_type table in stores7 database, columns in, sqlr, A-6

Callback,

mi_lo_invalidate() with, dapi, 12-296, 12-365

callback, dapi, 5-7

description, dapi, 9-4

disabled, dapi, 5-7

example, dapi, 9-7

Callback function,

declaring, esqlc, 12-40, 12-38

defining, esqlc, 12-70, 12-39

definition of, esqlc, 12-37

determining current connection, esqlc, 12-32

disassociating, esqlc, 12-56, 12-39

registering, esqlc, 12-40, 12-54

callbacks_enabled field,

of MI_PARAMETER_INFO structure, dapi, 5-7

calloc() system call, esqlc, 17-10

Candidate key, sqlt, 8-26

Cardinality, sqlt, 8-11

in relationship, sqlt, 8-15

CARDINALITY function, sqls, 1-912, sqlt, 12-18

Cardinality, ifx_cl_card(), esqlc, 9-45

Caret. See ^, caret.,

Carriage-return character, gls_api, 2-12

See also Vertical white space.,

Cartesian product, sqlt, 2-66

refining, sqlt, 2-67

Cascading deletes, sqls, 1-330, sqlt, 4-23

adding with ALTER TABLE, sqls, 1-71

ALTER TABLE...ON DELETE CASCADE, sqls, 1-71

CREATE TABLE example, sqls, 1-239

CREATE TABLE with, sqls, 1-239

disallowing with REVOKE REFERENCES, sqls, 1-580

locking associated with, sqls, 1-240

logging, sqls, 1-240

multiple child tables, sqls, 1-240

privileges, sqls, 1-240

restriction, sqls, 1-240

restrictions, sqlt, 4-24

See alsoCREATE TABLE statement;DELETE sstatement.,

trigger restriction, sqls, 1-260

Cascading triggers, sqls, 1-281

effect on a triggering table, sqls, 1-278

Case conversion,

buffer-size estimate, gls_api, 2-16

description of, gls_api, 2-14

INFORMIX-GLS functions for, gls_api, 4-8

lowercase to uppercase, gls_api, 4-188, 4-193

optimizing, gls_api, 2-20

uppercase to lowercase, gls_api, 4-185, 4-191

Case sensitivity, esqlc, 1-18, 1-33

Cast, sqlr, 2-25 to , sqlt, 13-3 to , gls, 4-17

by a support function, extend, 5-29

by support functions, extend, 5-17

CAST AS keywords, sqlt, 13-4, extend, 3-6, 3-7

casting function, extend, 3-9

collection data type, sqlt, 13-13 to

collection elements, sqlt, 13-16

CREATE CAST, sqls, 1-112

definition of, sqlr, Glossary-3, extend, 3-3, 1-10

distinct data type, sqlr, 2-31, sqlt, 13-5, 13-17

DROP CAST, sqls, 1-350

dropping, extend, 3-13

effect on routine resolution, udr, 2-15

explicit, sqlr, 2-29, 2-30, sqls, 1-114, sqlt, 13-4

invoking, sqlt, 13-4

syntax, sqls, 1-885

explicit. See Explicit cast.,

extending for existing data types, extend, 1-12

extending for new data types, extend, 1-17

function for, sqls, 1-116

implicit, sqlr, 2-29, 2-30, sqls, 1-115, sqlt, 13-4

implicit. See Implicit cast.,

invoking, sqlt, 13-5, 13-6

named row type, sqlt, 13-12, 13-5

operator, extend, 3-6, 3-7

operator for explicit cast, sqlt, 13-4

precedence of, sqlr, 2-30

privileges, sqls, 1-113

registering, sqls, 1-112

row type, sqlt, 13-6 to

See also User-defined cast.,

single-level vs. multilevel, sqlt, 13-22

straight, extend, 3-8

syscasts information, sqlr, 1-19

system-defined, sqlr, 2-25 to , 2-28, 2-30, sqls, 1-115, sqlt, 13-4, extend, 3-3, 3-8, 3-13

DROP CAST restrictions, sqls, 1-351

types of, sqlt, 13-4, extend, 3-3

unnamed row type fields, sqlt, 13-12

user-defined, sqlt, 13-20 to

creating, sqlt, 13-5

user-defined. See User-defined cast.,

Cast (::) operator, extend, 3-6, 3-7

CAST AS keywords, extend, 3-6, 3-7

Casting function, sqlr, Glossary-3, extend, 3-9, 5-8

Casts, dbdkug, 2-18

code generated for support functions, dbdkug, 5-36

converting data types with, dbdkug, 3-17

data type restrictions, dbdkug, 3-17

defined, overview, 1-25

defining in BladeSmith, dbdkug, 3-17

documentation of, overview, A-6

explicit, dbdkug, 3-18, overview, 1-25

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

functions for, dbdkug, 3-18, overview, 1-25

implicit, dbdkug, 3-18, overview, 1-25

properties of, dbdkug, 3-17

straight, overview, 1-25

test data, adding for, dbdkug, 3-44

test scripts for, dbdkug, 8-10

tests for, overview, 1-26

CBOOLTYPE data-type constant, esqlc, 2-11, 2-14

See also boolean data type.,

-cc processor option, esqlc, 1-81, 1-79

CC8BITLEVEL environment variable, esqlc, 1-108, gls, 8-10, 2-5, 7-4

-ccargs preprocessor option, esqlc, 1-50

CCHARTYPE data-type constant, esqlc, 2-10, 2-33

See also char data type.,

CCOLTYPE data-type constant, esqlc, 2-10

See also collection data type (ESQL/C).,

CCSID code set. See IBM CCSID code set.,

CDATETYPE data-type constant, esqlc, 2-10

See also long int data type.,

CDECIMALTYPE data-type constant, esqlc, 2-10

See also decimal data type.,

CDOUBLETYPE data-type constant, esqlc, 2-10

See also double data type.,

CDTIMETYPE data-type constant, esqlc, 2-10

See also datetime data type.,

Certification of DataBlade modules, dbdkug, 1-12

CFILETYPE data-type constant, esqlc, 2-10

See also char data type.,

CFIXBINTYPE data-type constant, esqlc, 2-11

See also fixed binary data type.,

CFIXCHARTYPE data-type constant, esqlc, 2-10

See also fixchar data type.,

CFLOATTYPE data-type constant, esqlc, 2-10

See also float data type.,

CHAR data type, sqlr, 2-36, sqls, 1-863, sqlt, 9-20

casts for, sqlr, 2-27

code-set conversion, gls, 1-48, 4-7

collation order, gls, 1-11

collation order dependency, sqlr, 2-36

coltype code for, sqlr, 1-24

corresponding ESQL/C data type, esqlc, 3-3, 2-4, 2-11

data conversion, esqlc, 3-11

defined constant, esqlc, 15-21, 2-8, 2-9

difference from NCHAR, gls, 3-12

fetching, esqlc, 3-11

GLS aspects, gls, 3-17

greater than condition, sqls, 1-1020

inserting, esqlc, 3-18, 3-12

numeric values with, sqlr, 2-37

performance considerations, gls, 3-16

See also char data type; fixchar data type; string data type; varchar data type.,

See Character; Character string.,

unloading, sqls, 1-770

char data type,

converting from decimal, esqlc, 4-42, 5-37, 4-28

converting from double, esqlc, 5-41

converting from int8, esqlc, 5-24

converting from long int, esqlc, 5-44

converting to decimal, esqlc, 4-16

converting to int8, esqlc, 5-15

defined constant, esqlc, 2-10

definition of, esqlc, 3-4

fetching into, esqlc, 3-17, 2-18, 6-35, 5-6, 3-11, 3-13

inserting from, esqlc, 3-17, 3-18, 3-12, 3-14

See also CHAR data type.,

with ANSI-compliant database, esqlc, 3-18

CHAR_LENGTH function, sqls, 1-921, gls, 3-45

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

Character,

alphabetic. See Alphabetic character.,

8-bit, gls_api, 2-4, gls, 1-8

7-bit, gls_api, 2-4, gls, 1-8

blank. See Blank character.,

case conversion, gls_api, 2-14

classifying. See Character classification.,

comparing, gls_api, 2-34

control. See Control character.,

digit. See Digit character.,

graphical. See Graphical character.,

hexadecimal digit. See Hexadecimal-digit character.,

lowercase. See Lowercase character.,

mismatched, gls, A-17, 1-42

multibyte. See Multibyte character.,

non-ASCII. See Non-ASCII character.,

nonprintable, gls, 3-13, 3-15

operations on, gls_api, 2-10

partial, gls, 7-25, 3-36

printable. See Printable character.,

punctuation. See Punctuation character.,

searching for, gls_api, 2-33

shifting case of, gls, 7-23

single-byte. See Single-byte character.,

sorting, gls_api, 2-34

space. See Space character.,

types of, gls_api, 2-4

uppercase. See Uppercase character.,

visible, gls_api, 4-123, 4-99

white space. See White space.,

wide. See Wide character.,

Character classification,

alnum class, gls_api, 4-88, 2-11

alpha class, gls_api, 4-90, 4-113, 4-115, 4-88, 2-11

blank class, gls_api, 4-93, 4-117, 2-12

cntrl class, gls_api, 4-95, 4-119, 2-12

description of, gls_api, 2-10

digit class, gls_api, 4-121, 4-113, 4-97, 4-88, 2-11

error-checking examples, gls_api, 1-21

graph class, gls_api, 4-123, 4-99, 2-12

INFORMIX-GLS functions for, gls_api, 4-7

lower class, gls_api, 4-101, 4-125, 2-11

print class, gls_api, 4-103, 4-127, 2-12

punct class, gls_api, 4-105, 4-129, 2-12

space class, gls_api, 4-131, 4-107, 2-12

testing for, gls_api, 2-13

upper class, gls_api, 4-133, 2-11, 4-109

xdigit class, gls_api, 4-111, 4-135, 2-11

Character classification. See Locale, CTYPE category.,

Character data,

avoiding corruption of, gls, 1-48, 4-7

collation of, gls, A-6, 3-20, 1-36

converting, gls, 1-48, 1-41, 4-7

data types, gls, 3-11

equivalent characters, gls, 3-28, A-6, 3-23, 1-11

ESQL functions, gls, 7-23

interpreting, gls, 1-26, 1-36

processing with locales, gls, 1-5

See also Data.,

Character data type, sqlt, 9-20 to

collength (column length) information, sqlr, 1-27

execution time, sqlt, 9-23

fixed and varying length, sqls, 1-863

fixed length,

ANSI compliancy, sqls, 1-863

length functions, sqls, 1-921

list of, sqlr, 2-9

See also CHAR; CHARACTER; LVARCHAR; VARCHAR; CHARACTER; VARYING data types.,

subscripting, sqlt, 2-43

subscripting substring, sqls, 1-889

substring notation, sqlt, 2-26

syntax, sqls, 1-862

varying length, sqlr, 2-38, sqlt, 9-22

varying length in ANSI-compliant database, sqls, 1-863

CHARACTER data type, sqlr, 2-37

ANSI compliancy, sqls, 1-863

See CHAR data type.,

CHARACTER data type. See CHAR data type.,

Character operation,

case conversion, gls_api, 2-14

character classification, gls_api, 2-10

code-set conversion, gls_api, 2-21

INFORMIX-GLS functions for, gls_api, 2-10

Character processing, gls_api, 2-3, 4-6

Character set, gls, A-18, 1-8

Character string,

as DATETIME values, sqlr, 2-43, 2-14

as INTERVAL values, sqlr, 2-51

casting to multibyte string, gls_api, 2-7

comparing, gls_api, 2-34

complementary, gls_api, 4-153, 4-204

concatenating, gls_api, 2-31

conversion of, gls_api, 3-11

copying, gls_api, 2-32

date, gls_api, 3-7

date/time, gls_api, 3-7

deallocating, gls_api, 2-42

formatting of, gls_api, 3-12

length of, gls_api, 2-32

length-terminated, gls_api, 2-37

memory management, gls_api, 2-40, 2-41

money, gls_api, 3-5

null-terminated, gls_api, 2-37

number, gls_api, 3-4

operations on, gls_api, 2-29

processing of, gls_api, 2-31

searching, gls_api, 2-33

See also Multibyte-character string; Wide-character string.,

sorting, gls_api, 2-34

string traversal, gls_api, 2-29

termination of, gls_api, 2-37

Character variables,

subscripting, sqls, 1-847

CHARACTER VARYING data type, sqlr, 2-38, sqlt, 9-22

description of, sqlr, 2-38

in ANSI-compliant database, sqls, 1-863

length, sqlr, 1-27

syntax, sqls, 1-862

CHARACTER_LENGTH function, sqls, 1-921

CHARACTER_LENGTH function. See CHAR_LENGTH function.,

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

Charmap file. See Code-set file.,

Charmap 12,

Check constraint, sqlt, 9-34, 4-20

adding with ALTER TABLE..CHECK, sqls, 1-73

definition of, sqlr, Glossary-3

renamed column with, sqls, 1-569

syschecks information, sqlr, 1-20

syscoldepend (dependencies), sqlr, 1-23

trigger and, sqls, 1-282

Checkpoint, sqlr, Glossary-3

Child process,

detaching from database server, esqlc, 12-57

handling defunct, esqlc, 12-67

Chinese locale, gls, 1-7, 1-30

chkenv utility, sqlr, 3-10, gls, 5-10, 4-11

error message for, sqlr, 3-11

Chunk, sqlr, Glossary-3, gls, 4-4, 5-4

CINT8TYPE data-type constant, esqlc, 2-10

See also int8 data type.,

CINTTYPE data-type constant, esqlc, 2-10

See also int data type.,

CINVTYPE data-type constant, esqlc, 2-10

See also interval data type.,

Class libraries, shared, sqlt, 1-10

CLASS routine modifier, sqls, 1-1030

Class value. See SQLSTATE variable, class and subclass codes.,

classes,

trace, dapi, 10-3

Classes,

creating for user-defined virtual processors, dbdkug, 4-8

DkInStream, dbdkug, 6-28 to

DkOutStream, dbdkug, 6-32 to

trace, creating, dbdkug, 5-14

virtual processors, dbdkug, 4-5

Client, sqlr, Glossary-3

APIs, for use with ActiveX value objects, dbdkug, 7-10, 7-3 to

files, dbdkug, 7-4, 6-25

adding with BladeSmith, dbdkug, 3-46

generated, dbdkug, B-2, B-3

projects, dbdkug, 6-23, 6-4

client and server function compatibility, dapi, 11-8

Client API, example of, overview, B-9

Client application,

checking a connection, gls, 1-38, 1-33, 1-47

code-set conversion, gls, 1-45, 1-46

definition of, gls, 1-6

end-user formats, gls, 1-12

establishing a connection, gls, 7-24

opening another database, gls, 1-38, 1-47

requesting a connection, gls, 2-18, 1-31

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

See ESQL/C client application; DataBlade client application.,

sending client locale to server, gls, 1-39, 7-24, 1-32

setting a locale, gls, 1-28, 1-18, 1-24

support for locales, gls, 1-6, 1-7

uses of client locale, gls, 2-6, 1-23

uses of database locale, gls, 1-27

verifying locales, gls, 1-45

Client code set, gls, 1-41, 1-45, 1-46

Client computer,

client code set, gls, 1-41

code-set-conversion files, gls, 1-46

setting CLIENT_LOCALE, gls, 1-28

setting DB_LOCALE, gls, 1-28

Client files,

about from the command line, bldmg_ug, 3-12

about on the GUI, bldmg_ug, 2-10

additional processing from the command line, bldmg_ug, 3-13

additional processing with the GUI, bldmg_ug, 2-11

directory installed in, bldmg_ug, 3-12, 2-11

installing from the command line, bldmg_ug, 3-12

installing with the GUI, bldmg_ug, 2-11

listing from the command line, bldmg_ug, 3-12

uninstalling from the command line, bldmg_ug, 3-13

uninstalling with the GUI, bldmg_ug, 2-11

Client Files page, bldmg_ug, 2-10

Client files, adding with BladeSmith, overview, 1-27

Client locale, gls_api, 1-19, 1-10, 1-11

client code set, gls, 1-41

code set. See Client code set.,

COLLATION category, gls, 1-24

CTYPE category, gls, 1-24

customizing, gls, 1-49

definition of, gls, 1-26, 1-23

determining, gls, 1-24

ESQL/C source files, gls, 7-5, 7-6

ESQL/COBOL source files, gls, 7-5, 7-6

MESSAGES category, gls, A-9

MONETARY category, gls, 1-24

NUMERIC category, gls, 1-24

sample, gls, 1-23, 1-35, 1-24

See also Client application; CLIENT_LOCALE environment variable.,

sending to database server, gls, 7-24, 1-32

setting, gls, 1-28

TIME category, gls, 1-24

CLIENT routine modifier, sqls, 1-1030

Client utility, example of, overview, B-3

Client-server environment,

and the cursor buffer, esqlc, 14-23

architecture of, esqlc, 12-3

connecting to a database, esqlc, 12-18

local connection, esqlc, 12-4

locating simple large objects, esqlc, 8-10

optimized message transfers, esqlc, 12-42

remote connection, esqlc, 12-4

setting the cursor-buffer size, esqlc, 14-24

Client-side collection variable, esqlc, 9-11

Client/server,

architecture, sqlr, Glossary-3

client stacksize (INFORMIXSTACKSIZE), sqlr, 3-51

connection statements, sqlr, Glossary-3

default database (INFORMIXSERVER), sqlr, 3-49

environment, sqls, 1-284

shared memory communication segments (INFORMIXSHMBASE), sqlr, 3-51

Client/server environment,

client locale, gls, 1-32

code-set conversion, gls, 1-41, 1-44

database locale, gls, 1-33

locales of, gls, 1-18, 1-22

server-processing locale, gls, 1-34

setting environment variables, gls, 1-28

CLIENT_GEN_VER version macro, esqlc, 13-14

CLIENT_GLS_VER version macro, esqlc, 13-14

CLIENT_LOCALE environment variable, gls_api, 1-11, extend, 6-24

client code set, gls, 1-41

default value, gls, 1-28

ESQL filenames, gls, 7-4

ESQL source code, gls, 7-4

for NLS applications, gls, 1-37

interpreting command-line arguments, gls, 4-10, 5-9, 6-9

location of message files, gls, 2-16

precedence of, gls, 2-16, 1-39, 1-51, 7-14, 1-52, 1-53, 7-17, 7-19, 1-24

role in code-set conversion, gls, 1-45, 1-47

See also Client locale.,

sending to database server, gls, 1-32

setting, gls, 1-28

syntax, gls, 2-6

with TEXT data, gls, 3-17, 3-18, 3-19, 3-12, 3-15

CLIENT_LOCALE environment variable, in InetLogin structure, esqlc, 1-106

CLIENT_OS_VER version macro, esqlc, 13-14

CLIENT_SQLI_VER version macro, esqlc, 13-14

CLOB data type, sqlr, 2-38, sqls, 1-870, sqlt, 9-25, dbdkug, C-1, 2-7

attributes in syscolatribs, sqlr, 1-20

casting not available, sqlr, 2-38

code-set conversion of, sqlr, 2-39

collation, sqlr, 2-39

coltype code for, sqlr, 1-26

column-level storage characteristics, dapi, 3-44

contents of, dapi, 3-15

copying to a file, sqls, 1-928

copying to a smart large object, sqls, 1-930

corresponding ESQL/C data type, esqlc, 2-5, 2-13

creating from a file, sqls, 1-926

declaring host variable for, esqlc, 7-7

definition of, sqlr, Glossary-3, dapi, 3-15

deleting, dapi, 3-80

displaying values, sqlt, 2-10

fetching, dapi, 3-17, 3-61

handle values, sqls, 1-890

implementation of, esqlc, 10-48

inserting, dapi, 3-18, 3-55

inserting data, sqlr, 2-39

on optical disc, esqlc, 7-32

restrictions,

with GROUP BY, sqlt, 3-6

role of locator.h, esqlc, 2-13

See also ifx_lo_t data type; Smart large-object data type.,

See also Smart large object.,

SQL restrictions, sqlt, 9-26

syntax, sqls, 1-869

unloading, sqls, 1-771, 1-773

updating, dapi, 3-18, 3-72, 3-55

CLOCATORTYPE data-type constant, esqlc, 2-10

See also loc_t data type.,

CLONGTYPE data-type constant, esqlc, 2-10

See also long int data type.,

CLOSE DATABASE statement, sqls, 1-97, esqlc, 12-18, 12-19, 12-41, 12-65, 12-99, 15-18

effect on database locks, sqlt, 7-8

prerequisite actions, sqls, 1-97

CLOSE statement, sqls, 1-93, esqlc, 9-24, 14-13, 14-15, 14-19

collection cursor, sqls, 1-95

function cursor, sqls, 1-94

insert cursor, sqls, 1-94

optimizing, esqlc, 14-35

select cursor, sqls, 1-94

CLSID information, dbdkug, 7-4, 6-25

Cluster index, sqlr, Glossary-3

Cluster key, sqlr, Glossary-3

Cluster size, sqlr, Glossary-3

CLVCHARTYPE data-type constant, esqlc, 2-11

See also lvarchar data type.,

.cm file extension, gls, A-18, A-21

.cmo file extension, gls, A-18

CMONEYTYPE data-type constant, esqlc, 2-10

See also decimal data type.,

.cmp file, components file, dbdkug, 10-5

cmZ.txt file, gls, A-26

Cntrl class, gls_api, 4-95, 4-119, 2-12, 2-13

.cob file extension, gls, 7-4

COBOL, sqlt, 5-6

COBOL compiler, gls, 7-4

Codd, E. F., sqlt, 8-35, 1-10

Code point, gls_api, 2-4, 2-34, gls, 1-8, 1-10, 3-16

Code set, gls_api, 2-4, 2-7

1252, gls, 1-19, 1-8, 1-21

8859-1, gls, 1-19, 1-8, 1-21, A-13

affecting filenames, gls, 4-6, 6-5, 5-6, 7-5, 2-25

ASCII, gls_api, 2-4, gls, 1-19, 1-8

character classes, gls_api, 2-10

code points, gls, 1-8, 3-16

code-set collation order, gls_api, 2-34

compatible, gls, 1-26, 1-6

condensed name, gls, 1-26, 1-49, 1-21, A-12

convertible, gls, 1-48, 1-29, 4-7, 1-46

converting. See Code-set conversion.,

default, gls_api, 2-10, gls, 1-19, 1-30, 1-20

definition of, gls, 1-8

destination, gls_api, 4-51, 4-45, 2-21, 4-13, 4-49

determining, gls, 1-41, 1-30

for client application, gls, 1-23

for database, gls, 1-26

for database server, gls, 1-27

in locale name, gls, 1-20, 1-21, 1-33

incompatible, gls, 1-46

ISO8859-1, gls_api, 2-10

Microsoft 1252, gls_api, 2-10

multibyte, gls_api, 2-28, 2-5, gls, 3-42, 7-25, 1-30, 1-9, 3-35, 3-36

name of, gls_api, 4-50, 4-51, 4-46, 4-13, 2-24

non-state dependent, gls_api, 2-25

See also Client code set; Code-set conversion; Database code set; Server code set.,

single-byte, gls_api, 2-28, 4-51, 2-4, gls, 3-41, 1-8, 1-30, 3-35, 3-38

source, gls_api, 4-51, 4-45, 2-21, 4-13, 4-49, gls, 1-41, 1-42

state-dependent, gls_api, 2-25

target, gls, 1-41, 1-42

Code-set collation order, gls_api, 2-34

Code-set conversion,

buffer-size estimate, gls_api, 2-40, 2-23

by client application, gls, 1-45

by database server, gls, 1-47

character mismatches, gls, A-17, 1-42

conversion table, gls_api, 2-28, 4-51

data converted, gls, 1-48, 4-7

definition of, gls, 1-41

determining if needed, gls_api, 2-21, 4-13

files. See Code-set-conversion file.,

for blob data, gls, 1-48, 8-13, 4-7

for column names, gls, 1-48, 4-8

for cursor names, gls, 1-48, 4-8

for error message text, gls, 1-48, 4-8

for LVARCHAR, gls, 4-7

for SQL data types, gls, 1-48, 4-7

for SQL statements, gls, 1-48, 4-8

for statement IDs, gls, 1-48, 4-8

for stored procedure text, gls, 1-48, 4-8

for table names, gls, 1-48, 4-8

fragmented string, gls_api, 2-26

handling mismatched characters, gls, 1-42

in ESQL/C program, gls, 8-12

INFORMIX-GLS functions for, gls_api, 4-7

limitations, gls, 1-41

lossy error, gls, 1-42

optimizing, gls_api, 2-28

performing, gls_api, 4-45, gls, 1-48, 4-7, 1-43, 1-47

registry file, gls, A-18, A-20

role of CLIENT_LOCALE, gls, 1-45, 1-47

role of DB_LOCALE, gls, 1-45, 1-47

role of SERVER_LOCALE, gls, 1-47

single-byte characters, gls_api, 4-51

state-dependent code sets, gls_api, 2-25

subdirectory for files, gls_api, 1-23, 1-14

support for, gls_api, 2-21

two-way, gls, A-16

unfragmented string, gls_api, 2-26

Code-set file,

description of, gls, A-17

listing, gls, A-26

location of, gls, A-18, A-19

object, gls, A-18

removing, gls, A-21

source, gls, A-18

Code-set name registry, gls_api, 2-24

Code-set order. See Collation order.,

Code-set-conversion file,

description of, gls, A-14

listing, gls, A-25, 1-46

location of, gls, A-15

object, gls, A-15, A-20

removing unused, gls, A-20

source, gls, A-15, 1-42, A-20

Coded Character Set Identifier (CCSID). See IBM CCSID code set.,

Codes, for errors, overview, 1-26

Coding standards, udr, 3-5

Coding standards, documentation of, overview, A-6

COLLATE locale category. See LC_COLLATE locale-file category.,

Collating sequence. See Collation order.,

Collation,

code-set collation order, gls_api, 2-34

definition of, gls_api, 2-34, gls, 1-9

equivalence classes, gls, 3-28, A-6, 3-31, 3-23, 1-11

localized collation order, gls_api, 4-199, 4-147, 2-34

of character data, gls, 3-20

of NCHAR, gls, 3-12

of NVARCHAR, gls, 3-14

sort order. See Collation order.,

types of, gls_api, 2-34

with ALS database server, gls, 1-26, 1-12

with CLOB data type, sqlr, 2-39

with NLS database server, gls, 1-26, 1-12

COLLATION locale category,

description of, gls, A-4, A-6

in client locale, gls, 1-24

in default locale, gls, A-4

in locale source file, gls, A-12

in server-processing locale, gls, 1-38

Collation order, sqlr, Glossary-3

ascending and descending, sqlt, 2-13

code-set, gls, 1-10, 1-11, 3-16

localized, gls, 1-5, 1-20, 1-10, 1-11, 3-16, 1-36

NCHAR data type, sqlr, 1-12

non-English data, sqlt, 2-24

See alsoGlobal Language Support (GLS); Guide to GLS Functionality,

tasks affected by, gls, 1-9

types of, gls, 1-10

with relational operators, sqls, 1-1021

COLLCHAR environment variable,

in InetLogin structure, esqlc, 1-106

collct.h header file, definition of, esqlc, 1-24

Collection, sqlr, Glossary-3

nested, sqls, 1-993

Collection cursor, sqlr, Glossary-4, sqls, 1-320 to

closing, sqls, 1-95

DECLARE for ESQL/C variable, sqls, 1-320

deleting elements, sqls, 1-332

FOR EACH with, sqls, 2-30

inserting into, sqls, 1-563, 1-422

opening, sqls, 1-533

updating elements, sqls, 1-797

Collection data type, sqlr, 2-22, sqls, 1-876, sqlt, 10-14 to

accessing, sqlt, 12-14

cardinality, returning, esqlc, 9-45

casting, sqlt, 13-13 to

examples, sqlt, 13-15

requirements, sqlt, 13-16

casting,

summary matrix, sqlr, 2-32

coltype code for, sqlr, 1-24

counting elements in, sqlt, 12-18

creating a domain for, sqlt, 9-35

definition of, sqlr, Glossary-4

deleting, sqls, 1-332, 1-333, 1-329

element type, sqlt, 10-14

element,

searching for with IN, sqls, 1-844, sqlt, 12-16

IN operator, sqls, 1-844

LIST, sqlr, 2-51

loading, sqls, 1-522

MULTISET, sqlr, 2-54, sqls, 1-877

nesting, sqlt, 10-19

returning number of elements, sqls, 1-912

See also LIST data type; MULTISET data type; SET data type.,

selecting entire row from, esqlc, 9-26

selecting from, sqls, 1-613

SET, sqlr, 2-62, sqls, 1-877

simple, sqlt, 12-14

sysattrtypes information about elements, sqlr, 1-17

sysxtddesc contents for, sqlr, 1-62

sysxtdtypes information, sqlr, 1-64

type checking, sqlt, 13-14

type constructor, sqlt, 10-14

unloading, sqls, 1-770

updating, sqls, 1-791, 1-795, 1-797, 1-798

collection data type (ESQL/C),

allocating memory for, esqlc, 9-11

client-side, esqlc, 9-11

Collection Derived Table clause, esqlc, 9-14

corresponding SQL data type, esqlc, 2-4, 2-5, 2-12, 2-13

deallocating memory for, esqlc, 9-11

declaration, esqlc, 9-5

defined constant, esqlc, 2-10

fetching from, esqlc, 9-24

fetching into, esqlc, 9-16

initializing, esqlc, 9-16

insert cursor for, esqlc, 9-21

inserting into, esqlc, 9-18

literal values, esqlc, 9-32

operating on, esqlc, 9-13

preparing statements that contain, esqlc, 14-8

See also Collection data type (SQL).,

select cursor for, esqlc, 9-27

typed collection variable, esqlc, 9-6

untyped collection variable, esqlc, 9-9

updating, esqlc, 9-29

Collection data type (SQL),

accessing, esqlc, 9-4

as element type of collection, esqlc, 9-6

as field type in row, esqlc, 9-50

declaring host variables for, esqlc, 9-5

definition of, esqlc, 9-4

deleting, esqlc, 9-44

extended identifier, esqlc, 15-13, 15-9

fetching, esqlc, 9-24, 9-16

in dynamic SQL, esqlc, 15-13

inserting into, esqlc, 9-40, 9-41, 9-18

literal values, esqlc, 9-75, 9-42, 9-43, 9-32

nested collection, esqlc, 9-75, 9-43, 9-37, 9-26

owner of, esqlc, 15-14, 15-9

See also collection data type (ESQL/C); LIST data type; MULTISET data type; SET data type.,

selecting from, esqlc, 9-41

simple collection, esqlc, 9-13

updating, esqlc, 9-40, 9-41, 9-29

Collection data type (SQL), selecting a row from, esqlc, 9-26

Collection data types,

creating in BladeSmith, dbdkug, 3-31

defined, overview, 1-18

denormalization with, overview, 1-19

element of, overview, 1-18

element type restrictions, dbdkug, 3-32

example of, overview, B-6

illlustration of, overview, 1-19

LIST type constructor for, overview, 1-18

MULTISET type constructor for, overview, 1-18

properties, dbdkug, 3-31

return value, using as, overview, 1-19

SET type constructor for, overview, 1-18

type constructors, dbdkug, 3-32

Collection derived table, sqls, 1-832 to

collection cursor, sqls, 1-563, 1-422

collection variables with, sqls, 1-833

DECLARE statement with, sqls, 1-833

definition of, sqlr, Glossary-4

DELETE statement with, sqls, 1-833

DELETE with, sqls, 1-333, 1-337

FETCH statement with, sqls, 1-833

for collection variables, esqlc, 9-13

for row variables, esqlc, 9-59

FOREACH statement, sqls, 1-833

in DELETE, esqlc, 9-34, 9-68

in INSERT, esqlc, 9-64, 9-20, 9-18

in SELECT, esqlc, 9-64, 9-24, 9-26

in UPDATE, esqlc, 9-66, 9-29

INSERT statement with, sqls, 1-833

INSERT with, sqls, 1-324, 1-514, 1-509

PUT statement with, sqls, 1-833

row variables with, sqls, 1-835

SELECT statement with, sqls, 1-833, 1-835

SELECT with, sqls, 1-613

fields from row variable, sqls, 1-617

TABLE keyword, sqls, 1-832, 1-833, 1-835

UPDATE row variable with, sqls, 1-803

UPDATE statement with, sqls, 1-833, 1-835

UPDATE with, sqls, 1-798

Collection variable, sqlr, Glossary-4

accessing, sqls, 1-833

allocating memory for, sqls, 1-22

cursor for, sqls, 1-422

deallocating memory for, sqls, 1-297

deleting, sqls, 1-332, 1-333

describing, sqls, 1-344

inserting, sqls, 1-509

inserting elements into, sqls, 1-510

nested, sqlt, 12-14

selecting, sqlt, 12-16

opening a cursor, sqls, 1-533

selecting from, sqls, 1-613

selecting, inserting elements, sqls, 1-325, 1-320 to

updating, sqls, 1-785, 1-797, 1-798

Colon (:),

between main variable and indicator variable, esqlc, 1-45

preceding host variables, esqlc, 1-21

specifying indicator variable, esqlc, 1-45

Colon (:), delimiter in INTERVAL, sqlr, 2-50

Colon. See:, colon; :: , cast operator.,

Color, setting INFORMIXTERM for, sqlr, 3-52

Column,

algorithms for adding, sqls, 1-59

check constraint, sqlt, 9-34, 4-20

check constraint for, sqls, 1-234

comparisons, sqls, 1-840

constraint properties, sqlt, 8-24

constraints, sqls, 1-226, sqlt, 4-20

constraints,

syconstraints, sqlr, 1-29

syscoldepend, sqlr, 1-23

sysreferences, sqlr, 1-49

data type, sqlt, 4-20

default value, sqlt, 9-34, 4-20

default value,

sysdefaults, sqlr, 1-30

defining, sqlt, 8-23

multiple attributes in, sqlt, 10-10, 10-13

dropping, sqls, 1-75

in stores7 database, sqlr, A-2 to

INFO...COLUMNS with, sqls, 1-491

inserting into, sqls, 1-497

label on, sqlt, 3-43

length, sqls, 1-341

modifying with ALTER TABLE, sqls, 1-77

name. SeeColumn name.,

number, sqlt, 2-22

order listed from SELECT, sqlt, 2-12

primary or foreign key, sqls, 1-232

privileges, sqls, 1-468, sqlt, 11-10

privileges,

syscolauth, sqlr, 1-22

projection, sqls, 1-888

properties, sqlt, 4-20, 9-3

referenced and referencing, sqls, 1-236, 1-70

relational and object-relational model, sqlt, 1-12

renaming, sqls, 1-568

subscript, substring, sqls, 1-636

syscolumns description, sqlr, 1-23 to

value. SeeColumn value.,

virtual, sqls, 1-291

Column (database),

determining data type, esqlc, 2-8

determining if truncated, esqlc, 11-31, 11-15

expressions, gls, 3-34

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

naming, gls, 1-5, 1-6, 3-5, 7-6

substrings, gls, 3-39, 3-34

using data conversion, esqlc, 2-15

Column definition clause, sqls, 1-222

Column expression, sqlr, Glossary-4, sqls, 1-886

determining dynamically, sqls, 1-341

Column name,

'all', 'unique', 'distinct' as, sqls, 1-975

'as', 'from' as, sqls, 1-979

determining dynamically, sqls, 1-341

dot notation, sqls, 1-888

functions as names, sqls, 1-973

'interval', 'datetime' as, sqls, 1-976

label for, sqls, 1-978

'null', `select', sqls, 1-981

rowid as, sqls, 1-977

when qualified, sqls, 1-274

workaround for keyword, sqls, 1-978

Column value,

in a SET clause, sqls, 1-788

in triggered action, sqls, 1-276

INSERT statement considerations, sqls, 1-502

maximum/minimum, sqlr, 1-29

qualified vs. unqualified, sqls, 1-276

Column-level properties. See Constraints,

column-level.,

columns Information Schema view, sqlr, 1-68

COM (Common Object Model), dbdkug, 6-4

Combine function, for an aggregate, dbdkug, 3-16

Comma (,) symbol, esqlc, 5-30

Command line interface, BladeManager, bldmg_ug, 3-15, 3-3 to

Command script file,

comment symbols in, sqls, 1-12

creating database, sqlt, 9-42

defined, sqls, 1-12

Command-line arguments, gls, 4-10, 5-9, 6-9

Command-line conventions,

elements of, sqlr, Intro-11, esqlc, Intro-10, gls, Intro-9

example diagram, sqlr, Intro-12, esqlc, Intro-12, gls, Intro-10

how to read, sqlr, Intro-12, esqlc, Intro-12, gls, Intro-10

Commands,

?, bldmg_ug, 3-19

add client, bldmg_ug, 3-15

bye, bldmg_ug, 3-15

del client, bldmg_ug, 3-16

del logs, bldmg_ug, 3-16

executing at startup from the command line, bldmg_ug, 3-6

executing multiple from the command line interface, bldmg_ug, 3-6

exit, bldmg_ug, 3-16

help, bldmg_ug, 3-16

info, bldmg_ug, 3-16

list, bldmg_ug, 3-17

quit, bldmg_ug, 3-17

register, bldmg_ug, 3-17

set confirm, bldmg_ug, 3-17

set user, bldmg_ug, 3-18

show client, bldmg_ug, 3-18

show log, bldmg_ug, 3-18

show modules, bldmg_ug, 3-19

show servers, bldmg_ug, 3-19

unregister, bldmg_ug, 3-19

Comment icons, 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

Comment symbol,

double dash (--), sqls, 1-1045

how to enter, sqls, 1-11

in application programs, sqls, 1-12

in prepared statements, sqls, 1-544

SPL routine, sqls, 1-1045

Comments, gls, 2-5, 3-34, 7-6

C language code, in, dbdkug, 5-8

C++ language code, in, dbdkug, 6-14

Comments in ESQL/C program, esqlc, 1-21

COMMIT WORK statement, esqlc, 12-30, 15-18

ANSI-compliancy, sqls, 1-100

closing cursors, sqlt, 7-23

commit defined, sqlr, Glossary-4

cursor with, sqls, 1-319

releasing locks, sqlt, 7-10, 7-23

setting SQLCODE, sqlt, 6-5

syntax, sqls, 1-99

Committed Read,

isolation level (Informix), sqlt, 7-14

Committed Read isolation level (Informix), sqls, 1-724

Common files for ActiveX value objects, dbdkug, B-4, 6-16

Commutator function, sqlr, Glossary-4, dbdkug, 3-30

Compare method/routine, dbdkug, 7-8, 6-18

Compare support function, sqls, 1-173

compare() support function, extend, 6-22, 5-22

description of, extend, 5-6

summary of, extend, 6-5

uses of, extend, 5-24

Comparison functions, dbdkug, 5-32, 6-18

compatibility between client and server functions, dapi, 11-8

CompatibleType method, dbdkug, 7-7

Compiler,

built-in scaling, gls_api, 2-4, 2-30, 2-7

environment variable for C (INFORMIXC), sqlr, 3-44

for ESQL/C programs, esqlc, 1-47

options. See Preprocessor option.,

options. See Compiler options.,

preprocessing, esqlc, 1-47

redirecting errors, esqlc, 1-65

See also Preprocessor.,

syntax, esqlc, 1-48

version information, esqlc, 1-59

Compiler option,

-I, gls_api, 1-15, 1-18

-L, gls_api, 1-16

-lixgls, gls_api, 1-16

Compiler version independence, esqlc, 1-90

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

Compiling,

ActiveX value objects, dbdkug, 6-19 to

debugging support, dbdkug, 5-39

debugging symbols, with, dbdkug, 5-39

include files, setting in Visual C++, dbdkug, 5-40, 6-21

library files, setting in Visual C++, dbdkug, 5-40, 6-21

See also Makefiles.,

shared object files, dbdkug, 5-38

UNIX, on, dbdkug, 5-38

using generated makefiles, dbdkug, 5-36, 6-19

Windows NT at the MS-DOS prompt, dbdkug, 5-41

Windows NT, for Visual C++, dbdkug, 5-39

Compiling an ESQL/C program,

default order, overview of, esqlc, 1-11

overview, esqlc, 1-9

the esql command, esqlc, 1-8, 1-9

the ESQL/C preprocessor, esqlc, 1-9

Compiling dynamic thread application, esqlc, 13-51

Compiling ESQL/C programs,

default order, esqlc, 1-67

non-default order, esqlc, 1-69

Compiling source code,

about, overview, 2-7

documentation of, overview, A-6

Complementary string, gls_api, 4-153, 4-204

Complex data type, sqlr, 2-20 to , sqlt, 10-4 to , 9-4, extend, 1-7

collection types, sqlr, 2-22

definition of, sqlr, Glossary-4

loading element values, sqls, 1-522

row types, sqlr, 2-24

sysattrtypes information about members, sqlr, 1-17

unloading, sqls, 1-775

using, sqlt, 10-5

Complex data type. See Collection data type (SQL); Row type (SQL).,

Complex data type. See Collection data type; Row type.,

Complex relationship, sqlt, 8-30

Compliance,

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

with industry standards, sqlr, Intro-16, sqls, Intro-21, extend, Intro-11, udr, Intro-10

Compliance with industry standards, dapi, Intro-10

Compliance, with industry standards, esqlc, Intro-15, sqlt, Intro-13, gls_api, Intro-15, gls, Intro-18

Composite index, sqlr, Glossary-4, sqls, 1-153

Composite key, sqlt, 8-26

Compound assignment, sqls, 2-40

Compound query, sqlt, 3-39

Concat method/routine, dbdkug, 5-34, 7-8, 6-18

concat() function, extend, 2-6

concat() operator function, sqls, 1-884

Concatenation,

description of, gls_api, 2-31

multibyte-character strings, gls_api, 4-142, 4-159, 2-31

wide-character strings, gls_api, 4-195, 2-31, 4-208

Concatenation operator. See ||, concatination operator; concat() operator function.,

Concurrency,

access modes, sqls, 1-746, sqlt, 7-17

ANSI Read Committed isolation, sqls, 1-745, sqlt, 7-14

ANSI Read Uncommitted isolation, sqls, 1-745, sqlt, 7-13

ANSI Repeatable Read isolation, sqls, 1-745, sqlt, 7-16

ANSI Serializable isolation, sqls, 1-745, sqlt, 7-16

database lock, sqlt, 7-8

deadlock, sqlt, 7-19

defining with SET ISOLATION, sqls, 1-722

defining with SET TRANSACTION, sqls, 1-746

description of, sqlr, Glossary-4, sqlt, 4-32, 7-3

effect on performance, sqlt, 7-3

Informix Committed Read isolation, sqls, 1-724

Informix Cursor Stability isolation, sqls, 1-724, sqlt, 7-14

Informix Dirty Read isolation, sqls, 1-724, sqlt, 7-13

Informix Read Committed isolation, sqlt, 7-14

Informix Repeatable Read isolation, sqls, 1-724, sqlt, 7-16

isolation level, sqlt, 7-11

lock duration, sqlt, 7-10

lock scope, sqlt, 7-7

lock types, sqlt, 7-7

SERIAL and SERIAL8 values, sqlt, 9-10

Condition, sqls, 1-836 to , 1-836

ALL/ANY/SOME subquery, sqls, 1-851, 1-621

AND operator, sqls, 1-853

BETWEEN operator, sqls, 1-842, sqlt, 2-31

boolean, sqlt, 2-35

comparing a range of values, sqls, 1-847

comparison, sqls, 1-837, sqlt, 2-27 to

ESCAPE character substitution, sqls, 1-848, sqlt, 2-43

examples using special characters, sqls, 1-846

range of values, sqlt, 2-43

special characters, sqlt, 2-43

value range delimiters, sqls, 1-847

compound, sqlt, 2-35

EXISTS subquery, sqls, 1-851, 1-621

IN operator, sqls, 1-843

IN subquery, sqls, 1-850, 1-621

LIKE comparator, sqls, 1-846

wildcards, sqls, 1-845

LIKE comparator,

wildcards, sqlt, 2-36

logical operators in, sqls, 1-853

MATCHES comparator, sqls, 1-847

wildcards, sqls, 1-845

MATCHES comparator,

wildcards, sqlt, 2-36

NOT IN operator, sqls, 1-843

NOT operator, sqlt, 2-31

NOT operator with, sqls, 1-846, 1-837

null values, sqls, 1-854, 1-837

OR operator, sqls, 1-853

quotation marks in, sqls, 1-840

relational operators, sqls, 1-620

relational operators in, sqls, 1-841

restrictions, sqls, 1-836

subquery in, sqls, 1-849 to

subquery with, sqls, 1-621

subscript delimiters, sqls, 1-847, sqlt, 2-43

Condition segment, sqls, 1-836

join conditions, sqls, 1-627

Conditional compilation directives, esqlc, 8-48, 1-12

Conditional compilation directives, ESQL/C,

processing of, esqlc, 1-9

Conditions,

BETWEEN, gls, 3-25

IN, gls, 3-27

LIKE, gls, 3-30

MATCHES, gls, 3-28

relational operator, gls, 3-24

Condtion,

boolean. SeeCondtion, comparison.,

Configuration file,

database server (ONCONFIG), sqlr, 3-56

ON-Archive utility (ARC_DEFAULT), sqlr, 3-16

tctermcap (TERMCAP), sqlr, 3-16

Configuration information,

in InetLogin structure, esqlc, 1-104

locations of, esqlc, 1-112

reading in, esqlc, 1-112

Configuration parameter,

STACKSIZE, dapi, 11-5

Configuring Informix Dynamic Server environment, bldmg_ug, 2-4, 3-4

Confirmation, turning on and off, bldmg_ug, 3-5

CONNECT DEFAULT statement,

INFORMIXSERVER environment variable effect, sqlr, 3-49

Connect permissions, bldmg_ug, 2-6

Connect privilege. See Privilege, database-level.,

CONNECT statement, sqls, 1-101 to , esqlc, 12-93, 12-12, gls, 3-5

and explicit connections, esqlc, 12-18

connection context, sqls, 1-103

connection identifiers, sqls, 1-103

database environment specification, sqls, 1-106 to

DEFAULT option, sqls, 1-103

determining database server features, esqlc, 12-27

determining name of a connection, esqlc, 11-11

determining name of a database server, esqlc, 12-31, 11-11

establishing a connection, esqlc, 12-20, 13-18

implicit connections, sqls, 1-104

switching connections, sqls, 1-105

transactions with, sqls, 1-105

USER clause, sqls, 1-109

with an active transaction, esqlc, 12-30

WITH CONCURRENT TRANSACTION clause, esqlc, 12-30

WITH CONCURRENT TRANSACTION option, sqls, 1-105

Connecting,

database with the GUI, bldmg_ug, 2-5

database, from the command line, bldmg_ug, 3-7, 3-8

different server, bldmg_ug, 3-8

different user, as, bldmg_ug, 3-8

Informix Dynamic Serve from the command line, bldmg_ug, 3-7

problems with, bldmg_ug, A-1

connecting to a database server, dapi, 11-3

Connecting to data,

INFORMIXCONRETRY environment variable, sqlr, 3-45

INFORMIXCONTIME environment variable, sqlr, 3-46

sqlhosts file and sqlexecd daemon, sqls, 1-109

connection,

establishing, dapi, 12-443

to a database server, dapi, 5-4

Connection, sqlr, Glossary-4

context, sqls, 1-686, 1-103, 1-347

current, sqls, 1-102, 1-348, 1-690

default, sqls, 1-104, 1-347, 1-689

dormant, sqls, 1-102, 1-686, 1-347

identifiers, sqls, 1-103

implicit, sqls, 1-104, 1-347, 1-689

INFORMIXCONRETRY environment variable, sqlr, 3-45

INFORMIXCONTIME environment variable, sqlr, 3-46

using InetLogin structure, esqlc, 1-104, 12-8

using Registry, esqlc, 12-8

Connection authentication, esqlc, 1-89

Connection handle, esqlc, 12-94

Connection. See Database server connection.,

Connectivity in relationship, sqlt, 8-20, 8-10, 8-13

Constant, sqlr, Glossary-5

access, dapi, 3-67

access-mode, dapi, 3-65

comparisons, sqls, 1-840

file-mode, dapi, 12-288, 3-83, 12-359

for smart large objects, dapi, 3-49

IFX_GL_EINVAL, gls_api, A-3, 2-43, 2-44

IFX_GL_NO_LIMIT, gls_api, 2-38

IFX_GL_NULL, gls_api, 2-38

inserting rows of, sqlt, 6-12

NULL, dapi, 1-8

open-mode, dapi, 3-64

UNITS keyword with, sqls, 1-899

whence, dapi, 12-370, 12-312, 12-307

Constant expression,

inserting with PUT, sqls, 1-558

restrictions with GROUP BY, sqls, 1-631

Constants,

for distinct bit, esqlc, 15-32

for ESQL/C data types, esqlc, 2-10

for smart large objects, esqlc, 7-41, 7-10, 7-44, 7-23, 7-58, dapi, 12-291

for SQL data types, esqlc, 16-9, 15-20, 2-8

for SQL statements, esqlc, 11-33, 15-17

for varchar data, esqlc, 3-7

for X/Open SQL data types, esqlc, 2-9

with dynamic-management structures, esqlc, 15-20, 15-17

Constraint, gls, 3-5, 7-6

adding with ALTER TABLE, sqls, 1-80

adding with object modes, sqls, 1-663 to

altering, sqls, 1-228

cardinality, sqlt, 8-11

column-level, sqls, 1-230, sqlt, 8-24

composite column list, sqls, 1-83

definition of, sqlr, Glossary-5, sqls, 1-226

disabled, sqlt, 4-26

dropping a column with, sqls, 1-76

dropping with ALTER TABLE, sqls, 1-85

dropping,

effect on foreign key, sqls, 1-85

duplicate indexes, sqls, 1-84

enabled, sqlt, 4-26

enforcing, sqls, 1-228, sqlt, 11-31

limit on size, sqls, 1-226

mixing, sqls, 1-83

modifying a column that has constraints, sqls, 1-77

names, sqls, 1-228

viewing (sysconstraints), sqls, 1-85

naming conventions, sqls, 1-856

not null, sqlr, 1-23

number of columns allowed, sqls, 1-226

object mode (sysobjstate), sqlr, 1-40

object mode,

disabled example, sqls, 1-660

filtering example, sqls, 1-660

privileges,