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 ]

D

, cast operator.,

.dat file extension, gls, 6-3

Data,

accessing in fragmented tables, sqlt, 9-52

character, gls, 3-11

converting, gls, 1-48, 4-7

corruption, gls, 2-18, 2-6

inserting values, sqls, 1-499

loading into database, sqls, 1-515

portability, gls, 6-6

See also Character data; Date data; Monetary data; Numeric data; Time data.,

transferring, gls, 1-34

unloading from database, sqls, 1-769

Data conversion,

arithmetic operations, esqlc, 2-19

definition of, esqlc, 2-15

for boolean values, esqlc, 2-18, 2-14

for CHAR data type, esqlc, 3-11

for char values, esqlc, 4-42, 5-24, 5-15, 4-16, 4-28

for character data types, esqlc, 2-16, 2-18, 2-19, 5-6, 3-11

for DATE values, esqlc, 6-37

for DATETIME values, esqlc, 2-18, 6-51, 6-33, 6-37

for decimal values, esqlc, 4-19, 4-50, 4-42, 4-21, 4-45, 4-23, 4-47, 5-27, 4-16, 4-28

for DECIMAL values, esqlc, 2-20, 4-7, 5-37, 5-18

for double values, esqlc, 4-19, 5-41, 4-45, 5-26

for floating-point data types, esqlc, 2-18, 5-6

for int values, esqlc, 4-21, 4-47, 5-28

for INT8 values, esqlc, 5-8

for INTERVAL values, esqlc, 2-18, 6-33, 6-37

for long int values, esqlc, 4-50, 5-20, 5-44, 4-23, 5-29

for MONEY values, esqlc, 5-41, 5-44, 5-37

for numeric data types, esqlc, 2-16, 2-19, 2-20

for NVARCHAR data type, esqlc, 3-12

for VARCHAR values, esqlc, 2-19, 3-12

when fetching DATETIME, esqlc, 6-35

when fetching INTERVAL, esqlc, 6-35

when inserting DATETIME, esqlc, 6-35

when inserting INTERVAL, esqlc, 6-35

Data conversion. See Data type, conversion.,

Data definition language statements, sqls, 1-16, sqlt, 5-34

DATA descriptor field,

after a DESCRIBE, esqlc, 16-6, 16-7

after a FETCH, esqlc, 16-42, 16-12, 16-14, 16-28, 16-19

allocating memory for, esqlc, 16-5

definition of, esqlc, 15-7

freeing memory for, esqlc, 16-12

See also Item descriptor.,

setting column value, esqlc, 16-30, 16-33

setting input parameter, esqlc, 16-41, 16-36

setting simple large-object column, esqlc, 16-55

Data distribution, sqlr, Glossary-5

Data distributions,

confidence, sqls, 1-814

disk space for (DBUPSPACE), sqlr, 3-41

on temporary tables, sqls, 1-811

RESOLUTION, sqls, 1-814

UPDATE STATISTICS (HIGH), sqls, 1-814

UPDATE STATISTICS (MEDIUM), sqls, 1-814

sysdistrib information, sqlr, 1-32

DATA field,

and INDICATOR field, sqls, 1-710

and TYPE field, sqls, 1-709

syntax, sqls, 1-433

with DATETIME and INTERVAL types, sqls, 1-710

with DESCRIBE, sqls, 1-342

with SET DESCRIPTOR, sqls, 1-709

Data formatting, gls_api, 3-3, 4-9

Data integrity, sqlt, 4-19, 4-27 to

definition of, sqlr, Glossary-5

object modes, sqls, 1-669

object modes with, sqls, 1-663 to

statements, sqlr, Glossary-5, sqls, 1-17

Data manipulation language,

SQL statements for, sqls, 1-17

Data manipulation statements, sqlr, Glossary-5

object modes with, sqls, 1-657 to

Data model, dbdkug, 2-3

attribute, sqlt, 8-17

building, sqlt, 8-3 to

defining relationships, sqlt, 8-9

description of, sqlt, 1-3, 8-3

entity relationship, sqlt, 8-5

many-to-many relationship, sqlt, 8-13

one-to-many relationship, sqlt, 8-13

one-to-one relationship, sqlt, 8-13

See also Relational model.,

telephone-directory example, sqlt, 8-7

Data replication, sqlr, Glossary-6

Data type, sqls, 1-860 to

approximate, sqlr, 1-68

automatic conversions, sqlt, 5-16

BLOB, gls, 4-13

built-in, extend, 1-5

BYTE, gls, 1-48, 4-7

casting, sqlr, 2-25 to , sqls, 1-112, 1-885

changing with ALTER TABLE, sqls, 1-79, sqlt, 9-33

CHAR, gls, 3-17, 1-48, 4-7

character, sqlt, 9-20 to , gls, 3-11

choosing, sqlt, 9-5 to

referential constraint considerations, sqlt, 9-6

chronological, sqlt, 9-15 to

CLOB, gls, 4-13

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

collation order, gls, 1-11

collection, sqls, 1-876

complex, sqls, 1-874, gls, 4-14, extend, 1-7

constructing an instance of, sqls, 1-900

conversion, sqlt, 4-9

creating, extend, 1-12

DataBlade-module, extend, 1-16

DATE, gls, 1-15, A-9

date and time, sqlt, 9-15

DATETIME, gls, 1-15, A-9

DECIMAL, gls, A-7, 1-14

definition, extend, 1-4

definition of, sqlr, Glossary-6

determining dynamically, sqls, 1-341

distinct, sqls, 1-873, gls, 4-14

duration interval, sqlt, 9-17

exact numeric, sqlr, 1-68

execution time, sqlt, 9-23

extended, sqlr, 2-71, 2-20, extend, 1-12

extending existing, extend, 1-11

fixed-point, sqlt, 9-13

FLOAT, gls, A-7, 1-14

floating-point, sqlr, 2-47, sqlt, 9-12

for code, sqlt, 9-9

for counter, sqlt, 9-9

for sequential integer, sqlr, 2-61, 2-59

for unique numeric code, sqlr, 2-61, 2-59

formatting loaded values, sqls, 1-517

fundamental, extend, 1-13

INSERT considerations, sqls, 1-1018, 1-502

INT, sqlr, 2-47

INTEGER, gls, A-7, 1-14

internal format, gls, 1-12

locale-sensitive, gls, 1-26, 3-11, 8-6

locale-specific, gls, 1-36

locator structure, gls, 8-12

LVARCHAR, gls, 4-13

MONEY, gls, 1-14

named row type, extend, 1-15

NCHAR, gls, 1-48, 4-7, 3-11, 8-6

numeric, sqlt, 9-9 to , gls, A-7, 1-14

NVARCHAR, gls, 3-13, 8-6

NVARCHAR data type, gls, 1-48, 4-7

opaque, sqls, 1-167, gls, 4-14

opaque. See Opaque data type.,

referential constraints rules, sqls, 1-71

See also each data type listed under its own name.,

See also individual data type names.,

simple large object, sqlr, 2-19, sqls, 1-870

SMALLFLOAT, gls, A-7, 1-14

SMALLINT, gls, A-7, 1-14

smart large object, sqlr, 2-17

smart large objects, gls, 4-13

summary table, sqlr, 2-7

TEXT, gls, 1-48, 3-18, 4-7

user-defined, extend, 1-12

VARCHAR, gls, 3-18

VARCHAR data type, gls, 1-48, 4-7

varying length, sqlt, 9-22 to

view inherits, sqls, 1-290

Data type conversion. See Data conversion.,

Data type hierarchy, description of, udr, 2-10

Data Type segment, sqls, 1-860

data types,

DataBlade API types that correspond to server types, dapi, 2-3

Data types,

ActiveX properties, dbdkug, 6-11

array of host variables, esqlc, 1-36

BLOB, dbdkug, C-1, 2-7

casts between, dbdkug, 3-17, 2-18

CLOB, dbdkug, C-1, 2-7

collection, dbdkug, 3-31, overview, 1-18

converting, overview, 1-25

converting with casts, dbdkug, 3-17

creating in BladeSmith, dbdkug, 3-31 to , 3-42, 6-9

defined, overview, 1-13

defined constants for, esqlc, 16-9, 15-20

designing, dbdkug, 2-6

distinct, overview, 1-17

documentation of, overview, A-7

for dynamic thread library, esqlc, 13-43

gl_wchar, dbdkug, 6-32, 6-28

list of, overview, 1-14

locale-specific, esqlc, 3-3

locator structure, esqlc, 8-6

LVARCHAR, dbdkug, 2-7

opaque, dbdkug, 2-6, overview, 1-15

POINTER, dbdkug, 3-15

pointers, esqlc, 1-39

qualified, dbdkug, 3-39

qualified built-in, overview, 1-15

relationship between C and SQL types, esqlc, 2-3, 2-4

row, dbdkug, 3-40, 2-6, overview, 1-20

See also ESQL/C data types; SQL data types.,

structures, esqlc, 1-37, 1-36

typedef expressions, esqlc, 1-38

X/Open defined constants for, esqlc, 15-21, 2-9

Database,

access control. See Privilege, database-level.,

ANSI-compliant, sqlt, 1-17

archiving, sqlt, 1-9

closing, esqlc, 12-41

closing with CLOSE DATABASE, sqls, 1-97

concurrent use, sqlt, 1-8

creating with CREATE DATABASE, sqls, 1-118

data types, sqlr, 2-33

default isolation levels, sqls, 1-746, 1-725

defined, sqlr, Glossary-6

determining available, esqlc, 12-33

determining if ANSI-compliant, esqlc, 11-30, 11-22, 12-27, 11-15

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

dropping with DROP DATABASE, sqls, 1-352

environment, esqlc, 12-5

exception codes, sqls, 1-442

fetching CHAR data, esqlc, 3-11

fetching DATETIME data, esqlc, 6-33

fetching INTERVAL data, esqlc, 6-34

fetching VARCHAR data, esqlc, 3-13

GLS, sqlt, 1-17

inserting CHAR data, esqlc, 3-12

inserting NCHAR data, esqlc, 3-12

inserting NVARCHAR data, esqlc, 3-15

inserting VARCHAR data, esqlc, 3-14

loading, gls, 3-52

loading data into, sqls, 1-515

lock, sqls, 1-296

management of, sqlt, 1-8

map of,

stores7, sqlr, A-8

migrating from GLS, gls, 5-10

mission-critical, sqlt, 1-9

naming, gls, 3-6, 6-4, 7-6, 6-7

naming conventions, sqls, 1-858

naming unique to database server, sqlt, 9-38

naming with variable, sqls, 1-859

object-relational, description of, sqlt, 1-10

opening, esqlc, 12-20

opening in exclusive mode, sqls, 1-296

optimizing queries, sqls, 1-809

populating new tables, sqlt, 9-43

privileges. See Privilege, database-level.,

remote, sqls, 1-859

renaming, sqls, 1-571

saving locale information, gls, 1-26

script for creating, sqlt, 9-42

SE names, gls, 6-4, 6-6

server, sqlt, 1-8

stores7 description of, sqlr, A-1

tables in (systables), sqlr, 1-54

unloading, gls, 3-52

unloading data from, sqls, 1-769

Database administrator (DBA), sqlr, Glossary-6, sqlt, 11-7

privileges,

granting, sqls, 1-462

list of, sqls, 1-464

revoking, sqls, 1-577

Database application, sqlr, Glossary-6

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

Database conversion, gls, 1-26, 5-10

Database cursor,

in explicit connection, esqlc, 12-94

structure definitions, esqlc, 1-23

Database cursor. See Cursor.,

Database environment, sqlr, Glossary-6

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

code set. See Database code set.,

database code set, gls, 1-41

in system catalog, gls, 1-26, 1-33

incompatible, gls, 1-33

sample, gls, 1-27, 1-23, 1-35

saving, gls, 1-26

See also DB_LOCALE environment variable.,

setting, gls, 1-28

uses of, gls, 1-36

verifying, gls, 1-38, 2-18, 1-33

Database lock, sqlt, 7-8

Database management system (DBMS), sqlr, Glossary-6

Database Name segment,

for remote database, sqls, 1-859

naming conventions, sqls, 1-857

naming with variable, sqls, 1-859

syntax, sqls, 1-857

Database object, sqlr, Glossary-6

constraints as a, sqlt, 4-25

creating,

revoking privileges for, sqls, 1-578

index as a, sqlt, 4-25

object modes, sqlt, 4-25

state of (sysobjstate), sqlr, 1-40

trigger as a, sqlt, 4-25

violation detection, sqlt, 4-25

Database objects, gls, 3-4, 1-6

Database schema, example of, overview, B-9

Database server,

archiving, sqlt, 4-31

attributes in Information Schema view, sqlr, 1-70

code-set conversion, gls, 1-47

collation, gls, 1-11

connecting to, esqlc, 12-21

current, esqlc, 12-11

default, esqlc, 1-105, 12-11, 12-7, 12-26

default for connection (INFORMIXSERVER), sqlr, 3-49

determining available databases, esqlc, 12-33

determining features of, esqlc, 12-27

determining name of, esqlc, 12-31, 11-11

determining server-processing locale, gls, 1-31, 1-34

determining type of, esqlc, 11-23, 11-15

end-user formats, gls, 1-13

in InetLogin structure, esqlc, 1-105

internal formats, gls, 1-12

interpreting character data, gls, 1-26

interrupting, esqlc, 12-52

message request, esqlc, 12-90, 14-30, 14-22, 14-24, 14-36, 12-34, 12-39

optimized message transfers, esqlc, 12-42

optimizing OPEN, FETCH, and CLOSE, esqlc, 14-35

receiving configuration information, esqlc, 12-8

reducing messages, esqlc, 14-30

See also DATABASE statement; INFORMIX-Universal server.,

See also INFORMIX-OnLine database server; INFORMIX-SE database server; INFORMIX-Universal Server.,

setting a locale, gls, 1-28

setting locale, gls, 1-18

specified, esqlc, 12-11

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

uses of client locale, gls, 1-31, 1-32, 1-24

uses of database locale, gls, 1-26

uses of server locale, gls, 1-27, 4-3, 5-3, 6-3

using DB_LOCALE, gls, 2-18

utilities, gls, 1-6

verifying a connection, gls, 7-24, 1-31

verifying database locale, gls, 1-38, 1-33

Database server connection,

active, esqlc, 12-31, 12-48, 13-18

checking status of, esqlc, 12-33

client-locale information, gls, 1-32

current, esqlc, 12-29, 7-53, 12-31, 12-47, 12-48, 12-17

detaching from, esqlc, 12-33

determining features, esqlc, 12-27

determining name of, esqlc, 12-31, 11-11

dormant, esqlc, 12-29, 13-18, 12-17

establishing, gls, 7-24, 1-31

explicit. See Explicit connection.,

freeing resources of, esqlc, 12-65

implicit. See Implicit connection.,

in thread-safe application, esqlc, 13-18

interrupting, esqlc, 12-34

naming, gls, 3-5

sample, gls, 1-27, 1-44, 1-23, 1-24

server-processing locale, gls, 2-6

switching between, esqlc, 12-29

terminating, esqlc, 12-41, 13-22

types of, esqlc, 12-16

using across threads, esqlc, 13-20

verifying, gls, 1-38, 7-24, 1-31, 1-33

warnings, gls, 7-24, 1-33

database server name,

function name qualifier, sqls, 1-965

Database server session,

current, dapi, 12-273, 12-275, 12-301, 12-281

DATABASE statement, esqlc, 12-96

and implicit connections, esqlc, 12-18, 12-19, 12-68

defined statement constant, esqlc, 15-17

determining database type, sqls, 1-296

determining name of a connection, esqlc, 11-11

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

exclusive mode, sqls, 1-296, sqlt, 7-8

locking, sqlt, 7-8

opening a database, esqlc, 12-27

specifying current database, sqls, 1-295

SQLWARN after, sqls, 1-296, sqlt, 5-12

starting a database server, esqlc, 12-20

syntax, sqls, 1-295

Database, stores 7, sqlr, A-1

Databases,

connecting to from the command line, bldmg_ug, 3-7, 3-8

connecting to with the GUI, bldmg_ug, 2-5

listing from the command line, bldmg_ug, 3-8

Databases page, bldmg_ug, 2-4

Datablade,

message information (syserrors), sqlr, 1-33

DataBlade API, sqlr, Glossary-6

client errors, dapi, 9-12

example callback, dapi, 9-7

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

initialization, dapi, 5-3

memory allocation functions, dbdkug, 4-13

memory management routines, udr, 5-13

overview of, overview, 1-11

server exceptions, dapi, 9-10

tips for using, dbdkug, 4-15

writing DataBlade module routines, overview, 1-22

DataBlade API data type,

mi_boolean, dapi, 2-4

mi_char, dapi, 2-3

mi_char1, dapi, 2-3

mi_date, dapi, 2-4

mi_datetime, dapi, 2-4

mi_decimal, dapi, 2-4

mi_double_precision, dapi, 2-3

mi_float, extend, 5-9

mi_impexp, extend, 6-15

mi_impexpbin, extend, 6-17

mi_int1, dapi, 2-3

mi_int8, dapi, 2-3

mi_integer, dapi, 2-3, extend, 5-9

mi_interval, dapi, 2-4

mi_lvarchar, dapi, 2-3, extend, 6-6

mi_money, dapi, 2-3

mi_numeric, dapi, 2-4

mi_real, dapi, 2-4, extend, 5-13

mi_sendrecv, extend, 6-11

mi_smallint, dapi, 2-3

mi_string, dapi, 2-3

mi_unsigned_char1, dapi, 2-3

mi_unsigned_int8, dapi, 2-3

mi_unsigned_integer, dapi, 2-3, extend, 5-12

mi_unsigned_smallint, dapi, 2-3, extend, 5-12

mi_wchar, dapi, 2-3

DataBlade API functions,

reference pages, dapi, 12-28 to

DataBlade client application,

compiling, gls_api, 1-15

current processing locale, gls_api, 1-11

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

linking INFORMIX-GLS, gls_api, 1-15

localizing, gls_api, 1-9

DataBlade Developers Kit,

example DataBlade modules, overview, 2-10

overview, overview, 1-6

Partners Program, dbdkug, 1-6

software requirements, dbdkug, Intro-5, overview, Intro-5

tools in, overview, 2-3

Tutorial, dbdkug, 1-6

tutorial, overview, 2-9

DataBlade Developers Kit InfoShelf,

about, bldmg_ug, Intro-10

contents, dbdkug, Intro-9

described, overview, 2-8

launching, dbdkug, Intro-9

software requirement, dbdkug, Intro-5, overview, Intro-5, bldmg_ug, Intro-4

DataBlade Developers Program,

error code allocation, dbdkug, 3-20, Intro-11

DataBlade module, sqlr, Glossary-6

debugging, udr, 4-8

loading into server address space, udr, 4-9

DataBlade module objects,

adding test data for, dbdkug, 3-42

aggregates, dbdkug, 3-12

casts, dbdkug, 3-17

creating, dbdkug, 3-11 to , 3-42, 6-9

data types, dbdkug, 3-31 to

errors, dbdkug, 3-19

generating files, dbdkug, 3-47 to

interfaces, dbdkug, 3-21

user-defined routines, dbdkug, 3-22

DataBlade modules, sqlt, 1-10

aggregates in, overview, 1-13

APIs used in development of, overview, 1-10

C++ code, using in, overview, 1-27

casts in, overview, 1-25

compiling source code, overview, 2-7

components of, overview, 1-12

creation task list, overview, 2-7

data model, dbdkug, 2-3

data types in, overview, 1-13 to

debugging, overview, 2-7

defined, dbdkug, 1-3

definition, overview, 1-3

dependencies between, overview, A-7

designing, dbdkug, 2-3 to

directory for on UNIX, bldmg_ug, 1-5

directory for on Windows NT, bldmg_ug, 1-6

documenting, overview, 2-8

editing source code, overview, 2-7

errors in, overview, 1-26

examples, overview, A-7

extending Informix Dynamic Server with, overview, 1-3

foundation, using as, overview, 1-6

generating files, dbdkug, 6-13

identification code for, overview, 2-7

imported files in, overview, 1-26

importing interfaces from, dbdkug, 3-11

information on, displaying, bldmg_ug, 3-14, 2-13

Informix, overview, B-1 to

installation files, overview, 2-4

installing, overview, A-7, 2-7

installing on UNIX, dbdkug, 8-6, bldmg_ug, 1-4

installing on Windows NT, dbdkug, 9-5, bldmg_ug, 1-5

interfaces for, bldmg_ug, 2-7, 3-10

interfaces in, overview, 1-25

loading into server address space, dbdkug, 9-10

loading the shared object file, dbdkug, 8-15

managing from the command line, bldmg_ug, 3-7 to

managing with the GUI, bldmg_ug, 2-4 to

memory allocation for, overview, 1-10

objects, defining with BladeSmith, dbdkug, 3-11

preparation from the command line, bldmg_ug, 3-9

preparation with the GUI, bldmg_ug, 2-6

query language interface to, dbdkug, 2-10 to

registering from the command line, bldmg_ug, 3-9

registering in a database, overview, 2-6

registering with the GUI, bldmg_ug, 2-7

registration script, dbdkug, C-1

routines in, overview, 1-22 to

source code, overview, 2-4

SQL scripts, overview, 2-4

storage for, overview, A-8

test files, overview, 2-4

testing, overview, A-8, 2-7

tests in, overview, 1-26

thread-safe calls in, dbdkug, 4-10

trace class, creating for, dbdkug, 5-14

unregistering from the command line, bldmg_ug, 3-11

unregistering with the GUI, bldmg_ug, 2-9

upgrading from the command line, bldmg_ug, 3-10

upgrading with the GUI, bldmg_ug, 2-8

virtual processors, using, overview, 1-9

DataBlade UDR,

compiling, gls_api, 1-16

current processing locale, gls_api, 1-11

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

linking INFORMIX-GLS, gls_api, 1-16

localizing, gls_api, 1-9

MI_SERVBUILD compiler flag, gls_api, 1-18

DataBlade-module data types, extend, 1-16

Dataskip,

skipping unavailable dbspaces, sqls, 1-692

Date data,

alternative digits for, gls_api, 3-8

alternative formats, gls, 2-29

Asian. See Era-based dates.,

converting, gls_api, 4-15

customizing format of, gls, 1-50

end-user format, gls, 1-15, 1-39, 1-19, 1-50, A-9

era names, gls_api, 3-8

field width, gls_api, 4-22, 4-58

format of, gls, A-8

format string, gls_api, 4-54, 4-16

formatting, gls_api, 4-53

formatting and conversion functions, gls_api, 4-10

formatting directives for, gls_api, 4-18, 4-20, 4-55, 4-57

locale category for, gls_api, 3-7

locale-specific, gls, 1-6, 1-14

locale-specific formats, gls_api, 3-7

month names, gls_api, 3-8

precedence of environment variables, gls, 1-51, 7-14

precision, gls_api, 4-58

See also Data; DATE data type; DATETIME data type; Era-based dates.,

See also Date/time data.,

setting GL_DATE, gls, 2-25

SQL data types for, gls_api, 3-4

weekday names, gls_api, 3-8

date data type,

corresponding SQL data type, esqlc, 2-4, 2-11

data conversion, esqlc, 6-37

declaration, esqlc, 6-3

defined constant, esqlc, 2-10

See also DATE data type.,

DATE data type, sqlr, 2-39, sqls, 1-871, sqlt, 9-15

casting to integer, sqlr, 2-28

converting to DATETIME, sqlr, 2-28

corresponding ESQL/C variable type, esqlc, 2-4, 2-11

data conversion, esqlc, 6-37

DATETIME, INTERVAL with, sqlr, 2-10, 2-13

declaring host variables for, esqlc, 6-3

defined constant, esqlc, 2-8

end-user format, gls, 1-15, 1-19, 1-50, A-9, 2-7, 2-25

era-based dates, gls, 1-51

ESQL library functions, gls, 7-8

ESQL/C functions, gls, 7-10, 7-8

ESQL/C library functions, gls, 7-9

ESQL/COBOL library routines, gls, 7-9

ESQL/COBOL routines, gls, 7-10, 7-8

extended-format strings, gls, 7-10

format for (DBDATE), sqlr, 3-23

functions in, sqls, 1-932

greater than condition, sqls, 1-1020

internal format, gls, 1-15, 1-12

international date formats, sqlr, 2-40, sqlt, 1-17

ORDER BY sequence, sqlt, 2-13

precedence of environment variables, gls, 1-51, 7-14

rdatestr(), esqlc, 6-6

rdayofweek(), esqlc, 6-8

rdefmtdate(), esqlc, 6-10

rfmtdate(), esqlc, 6-14

rjulmdy(), esqlc, 6-17

rleapyear(), esqlc, 6-19

rmdyjul(), esqlc, 6-21

rstrdate(), esqlc, 6-23

rtoday(), esqlc, 6-26

See also date data type.,

See also Date data.,

source data, sqlr, 2-14

syscolumns coltype code for, sqlr, 1-24

two-digit year values and DBCENTURY variable, sqlr, 2-40

unloading, sqls, 1-770

year digits for (DBCENTURY), sqlr, 3-20

Date expressions,

formatting, esqlc, 6-4

valid characters, esqlc, 6-4

DATE function, sqls, 1-932, 1-933, sqlt, 2-58

Date string, gls_api, 3-7

Date/time data,

A.M. equivalent, gls_api, 3-8

alternative digits for, gls_api, 3-8

converting, gls_api, 4-24

field width, gls_api, 4-32, 4-68

format string, gls_api, 4-62, 4-25

formatting, gls_api, 4-61

formatting and conversion functions, gls_api, 4-10

formatting directives for, gls_api, 4-63, 4-30, 4-66, 4-27

locale category for, gls_api, 3-7

locale-specific formats, gls_api, 3-7

P.M. equivalent, gls_api, 3-8

precision, gls_api, 4-68

See also Date data.,

SQL data types for, gls_api, 3-4

Date/time string, gls_api, 3-7

datetime data type,

arithmetic operations, esqlc, 6-36

corresponding SQL data type, esqlc, 2-4

data conversion, esqlc, 6-37

declaration, esqlc, 6-29

defined constant, esqlc, 2-10

definition of, esqlc, 6-28

fetching into, esqlc, 6-33

inserting from, esqlc, 6-33

role of datetime.h, esqlc, 2-11

See also DATETIME data type; dtime_t typedef.,

DATETIME data type, sqlr, 2-40, sqls, 1-871, sqlt, 9-16

ANSI-standard qualifiers, esqlc, 6-36

character string values, sqlr, 2-43

converting to DATE, sqlr, 2-28

converting to integer, sqlr, 2-28

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

data conversion, esqlc, 2-18, 6-51, 6-33, 6-35, 6-37

DATE function with, sqlt, 2-58

DATE INTERVAL with, sqlr, 2-10 to

declaring host variables for, esqlc, 6-29

defined constant, esqlc, 2-8

dtaddinv(), esqlc, 6-40

dtcurrent(), esqlc, 6-42

dtcvasc(), esqlc, 6-44

dtcvfmtasc(), esqlc, 6-47

dtextend(), esqlc, 6-51

dtsub(), esqlc, 6-54

dtsubinv(), esqlc, 6-57

dttoasc(), esqlc, 6-59

dttofmtasc(), esqlc, 6-62

dynamically allocating structures for, esqlc, 17-12

end-user format, gls, 1-15, 1-19, 1-50, A-9, 2-20, 2-35

era-based dates, gls, 1-51

ESQL library functions, gls, 7-15

ESQL/C functions, gls, 7-15

ESQL/COBOL routines, gls, 7-15

EXTEND function with, sqlr, 2-13, sqlt, 2-58

extended-format strings, gls, 7-16

extending, esqlc, 6-51, 6-33

extending fields in, sqlr, 2-11

fetching, esqlc, 2-18, 6-33

field qualifiers, sqlr, 2-41, sqls, 1-879

format, sqlt, 9-18

format for, sqlt, 2-58

format for (DBTIME), sqlr, 3-38

formatting directives for, gls, 2-36

functions on, sqls, 1-932

greater than condition, sqls, 1-1020

inserting, esqlc, 2-18, 6-33

internal format, gls, 1-15

international formats, sqlr, 2-44, sqlt, 9-19

length (syscolumns), sqlr, 1-28

macros, esqlc, 6-31

ORDER BY sequence with, sqlt, 2-13

precedence of environment variables, gls, 1-52, 7-17

precision of underlying decimal value, esqlc, 6-29

qualifiers, esqlc, 6-36, 6-29

role of datetime.h, esqlc, 2-11, 1-22

See also Date data.,

See also datetime data type.,

source data, sqlr, 2-14

syscolumns coltype code for, sqlr, 1-24

two-digit year values and DBDATE variable, sqlr, 2-43

unloading, sqls, 1-772

with SET DESCRIPTOR, sqls, 1-710

year digits for (DBCENTURY), sqlr, 3-20

DATETIME Field Qualifier, sqls, 1-879

DATETIME function,

CREATE TABLE with, sqls, 1-223

datetime.h header file, dapi, 1-6

contents and use, esqlc, 6-40, 6-28

data types defined, esqlc, 2-11, 2-12

definition of, esqlc, 1-22

macros defined, esqlc, 17-12, 6-31

DAY function, sqls, 1-932, 1-934

DB code set. See Database code set.,

DB-Access,

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

Modify option, sqlt, 14-80

syntax error, sqlt, 14-80

UNLOAD statement, sqlt, 9-44

DB-Access utility, gls, 1-6

DB_LOCALE environment variable, esqlc, 1-106, gls_api, 1-11, extend, 6-24

database code set, gls, 1-41

default value, gls, 1-28

precedence of, gls, 1-37

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

See also Database locale.,

sending to database server, gls, 1-32

server-processing locale, gls, 1-37

setting, gls, 1-28

syntax, gls, 2-17

verifying database locale, gls, 1-33

DBA See Database administrator (DBA); Privilege,

database-level.,

dbaccess utility, gls, 5-10, 4-10, 6-9

dbaccessdemo7 script, sqlr, Intro-6, sqls, Intro-6, sqlt, Intro-7, extend, Intro-5, udr, Intro-5

DBALSBC environment variable, esqlc, 1-108

DBANSIWARN environment variable, sqlr, 3-17, sqls, 1-206, 1-291, 1-969, esqlc, 12-18, 1-60, 1-106, 11-31, 11-23

DBAPICODE environment variable, esqlc, 1-108, gls, 1-45

DBASCIIBC environment variable, esqlc, 1-109

DBBLOBBUF environment variable, sqlr, 3-19, sqls, 1-773

LOAD with, sqls, 1-521

DBCENTURY environment variable, sqlr, 3-20, esqlc, 6-63, 6-44, 6-11, 6-23, 1-109, 6-48, gls_api, 4-29, 4-19, 4-31, 4-21, gls, 2-29

date value interpretation, sqls, 1-1045

DBDATE with, sqlr, 3-25

LOAD with, sqls, 1-517

DBCODESET environment variable, esqlc, 1-109, gls, 1-37, 1-39, 1-32

DBCONNECT environment variable, esqlc, 1-109

DBCSCONV environment variable, esqlc, 1-109

DBCSOVERRIDE environment variable, esqlc, 1-109

DBCSWIDTH environment variable, esqlc, 1-109

DBDATE environment variable, sqlr, 3-23, sqls, 1-770, 1-933, esqlc, 6-63, 1-105, 6-23, 6-48, 6-6, sqlt, 9-16, 4-9, gls_api, 4-31, 4-54, 4-21, 4-67, 4-58, 4-16

era-based dates, gls, 3-51, 1-51, 2-8

ESQL library functions, gls, 7-9

precedence of, gls, 1-39, 1-51, 7-14, 1-24

sending to database server, gls, 1-32

setting, gls, 1-50

syntax, gls, 2-7

DBDELIMITER environment variable, sqlr, 3-26, sqls, 1-775

LOAD with, sqls, 1-523

DBDK_TRACE_ENTER() macro, dbdkug, 5-13

DBDK_TRACE_ERROR() macro, dbdkug, 5-12

DBDK_TRACE_EXIT() macro, dbdkug, 5-13

DBDK_TRACE_MSG() macro, dbdkug, 5-12

DBEDIT environment variable, sqlr, 3-26

dbexport utility, gls, 5-10, 1-7, 4-11, 6-9, 2-25

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

dbimport utility, gls, 5-10, 4-11, 6-9

DBINFO function, sqls, 1-912

sessionid option with, sqls, 1-915

DBLANG environment variable, sqlr, 3-28, esqlc, 1-106

precedence of, gls, 2-16

setting, gls, 1-49

syntax, gls, 2-15

dbload utility, gls, 5-10, 4-11, 6-9

DBMONEY environment variable, sqlr, 3-29, sqls, 1-771, esqlc, 5-41, 5-30, 5-31, 1-105, 5-44, 5-37, sqlt, 9-15, gls_api, 4-72, 4-36

defining currency symbols, gls, 7-22

ESQL library functions, gls, 7-22, 7-19

precedence of, gls, 1-39, 1-53, 7-19, 1-24

sending to database server, gls, 1-32

setting, gls, 1-53

syntax, gls, 2-19

DBMONEYSCALE environment variable, esqlc, 1-110

DBMS. See Database management system.,

DBNLS environment variable, esqlc, 1-106, gls, 1-39, 1-51, 1-52, 1-53, 1-32, 1-45, 1-34, 1-24

DBONPLOAD environment variable, sqlr, 3-31

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

DBPRINT environment variable, sqlr, 3-34

DBREMOTECMD environment variable, sqlr, 3-35

.dbs file extension, gls, 6-3

dbschema utility, sqlt, 9-42, gls, 5-10, 4-11, 6-9

DBSERVERNAME function, sqls, 1-895

CREATE TABLE with, sqls, 1-223

example, sqlt, 3-19

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

dbspace,

ALTER FRAGMENT to add, sqlt, 9-50

CREATE DATABASE with, sqlt, 9-39

DBINFO function with, sqls, 1-914

default, sqls, 1-118

definition of, sqlr, Glossary-6

INFO statement with, sqls, 1-492

name, sqls, 1-914

round robin distribution, sqls, 1-44

setting with CREATE TABLE, sqls, 1-246

skipping if unavailable, sqls, 1-692

temporary tables in, sqls, 1-246, 1-643

dbspaces,

size and location, sqlr, 1-18

DBSPACETEMP configuration parameter,

CREATE TEMP TABLE with, sqls, 1-219

DBSPACETEMP environment variable, sqlr, 3-36, sqls, 1-643

CREATE TEMP TABLE with, sqls, 1-219

DBSS2 environment variable, esqlc, 1-110

DBSS3 environment variable, esqlc, 1-110

DBTEMP environment variable, sqlr, 3-37, esqlc, 1-105

DBTIME environment variable, sqlr, 3-38, sqls, 1-772, esqlc, 6-62, 6-74, 1-105, 6-68, 6-47, sqlt, 9-19, gls_api, 4-62, 4-31, 4-67, 4-25

era-based dates, gls, 3-51

ESQL library functions, gls, 7-16

precedence of, gls, 1-39, 1-52, 7-17, 1-24

sending to database server, gls, 1-32

setting, gls, 1-50

syntax, gls, 2-20

with multibyte characters, gls, 2-22

DBUPSPACE environment variable, sqlr, 3-41

dbx utility, dbdkug, 8-17

DCE thread package. See Distributed Computing Environment (DCE).,

DDL.See Data definition language.,

Deadlock detection, sqls, 1-729, sqlt, 7-19

DEALLOCATE COLLECTION statement, sqls, 1-297, esqlc, 9-12

DEALLOCATE DESCRIPTOR statement, sqls, 1-299, esqlc, 16-12, 16-5

DEALLOCATE ROW statement, sqls, 1-301, esqlc, 9-57

debugger utility, dbdkug, 8-17

Debugging,

starting the debugger, udr, 4-11

steps for, udr, 4-9

Debugging a DataBlade module, overview, 2-7

Debugging DataBlade modules,

ActiveX value objects, dbdkug, 6-7

compiling shared object file for, dbdkug, 5-39

UNIX,

attaching to the server process, dbdkug, 8-17

breakpoints, setting, dbdkug, 8-18

debugger utilities, dbdkug, 8-17

installing, dbdkug, 8-6

overview of tasks, dbdkug, 8-14

preparing the environment, dbdkug, 8-4

prerequisite tasks, dbdkug, 8-3

shared object files, dbdkug, 8-4, 8-5

shutting down the server, dbdkug, 8-15

signal handlers, disabling, dbdkug, 8-17

starting the debugger, dbdkug, 8-17

starting the server, dbdkug, 8-15

using Windows NT, dbdkug, 8-18

virtual processor, identifying, dbdkug, 8-16

Windows NT,

attaching to the server process, dbdkug, 9-9, 9-10, 9-11

breakpoints, setting, dbdkug, 9-11

dynamic link library, using, dbdkug, 9-4

installing, dbdkug, 9-5

overview of tasks, dbdkug, 9-8

preparing the environment, dbdkug, 9-4

prerequisite tasks, dbdkug, 9-3

starting the debugger, dbdkug, 9-9, 9-11

starting the server, dbdkug, 9-9, 9-7

stopping the server and debugger, dbdkug, 9-11

Visual C++, using, dbdkug, 9-10

DEC data type. See DECIMAL data type.,

dec_t typedef,

defined constant for DECIMAL data type, esqlc, 2-10

defined constant for MONEY data type, esqlc, 2-10

definition of, esqlc, 4-4

decadd() library function, esqlc, 4-7, 4-9

deccmp() library function, esqlc, 4-11, 4-7

deccopy() library function, esqlc, 4-7, 4-14

deccvasc() library function, esqlc, 4-7, 4-16

deccvdbl() library function, esqlc, 4-19, 4-7

deccvint() library function, esqlc, 4-21, 4-7

deccvlong() library function, esqlc, 4-23, 4-7

decdiv() library function, esqlc, 4-7, 4-25

dececvt() library function, esqlc, 13-30, 13-31, 4-7, 13-25, 4-28

decfcvt() library function, esqlc, 13-30, 13-31, 13-25, 4-28

decfvct() library function, esqlc, 4-7

Decimal arithmetic,

addition, esqlc, 4-9

division, esqlc, 4-25

multiplication, esqlc, 4-35

subtraction, esqlc, 4-40

DECIMAL data type, sqls, 1-866, gls, A-7, 1-53, 1-14

casts for, sqlr, 2-27

corresponding ESQL/C variable type, esqlc, 2-4, 2-12

data conversion, esqlc, 2-19, 2-20, 4-7, 2-21, 5-37, 5-18

decadd(), esqlc, 4-9

deccmp(), esqlc, 4-11

deccopy(), esqlc, 4-14

deccvasc(), esqlc, 4-16

deccvbl(), esqlc, 4-19

deccvint(), esqlc, 4-21

deccvlong(), esqlc, 4-23

decdiv(), esqlc, 4-25

dececvt(), esqlc, 4-28

decfcvt(), esqlc, 4-28

decimal structure shown, esqlc, 4-4

declaring host variables for, esqlc, 4-3

decmul(), esqlc, 4-35

decround(), esqlc, 4-37

decsub(), esqlc, 4-40

dectoasc(), esqlc, 4-42

dectodbl(), esqlc, 4-45

dectoint(), esqlc, 4-47

dectolong(), esqlc, 4-50

dectrunc(), esqlc, 4-52

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

description of, sqlr, 2-45

disk storage, sqlr, 2-45

fixed-point, sqlr, 2-45, sqlt, 9-13

fixed-point decimals, esqlc, 2-20, 2-22

floating-point, sqlr, 2-44, sqlt, 9-12

GET DESCRIPTOR with, sqls, 1-437

length (syscolumns), sqlr, 1-27

number of decimal digits, esqlc, 2-18, 5-6

precision and scale, sqls, 1-437

role of decimal.h, esqlc, 2-12, 1-22

scale and precision, esqlc, 2-22, 15-8

See also decimal data type.,

See Monetary data; Numeric data.,

syscolumns coltype code for, sqlr, 1-24

unloading, sqls, 1-771

with SET DESCRIPTOR, sqls, 1-710

decimal data type,

addition, esqlc, 4-9

arithmetic operations, esqlc, 4-7

comparing, esqlc, 4-11

converting from double, esqlc, 4-19

converting from int8, esqlc, 5-27

converting from integer, esqlc, 4-21

converting from long int, esqlc, 4-23

converting from text, esqlc, 4-16

converting to double, esqlc, 4-45

converting to int, esqlc, 4-47

converting to int8, esqlc, 5-18

converting to long int, esqlc, 4-50

converting to text, esqlc, 4-42, 5-37, 4-28

copying, esqlc, 4-14

corresponding SQL data type, esqlc, 2-4

data conversion, esqlc, 2-20, 4-7

declaration, esqlc, 4-3

defined constant for DECIMAL data type, esqlc, 2-10

defined constant for MONEY data type, esqlc, 2-10

division, esqlc, 4-25

floating-point decimals, esqlc, 2-20, 2-22

in thread-safe application, esqlc, 13-25

multiplication, esqlc, 4-35

role of decimal.h, esqlc, 2-12

rounding, esqlc, 4-37

See also DECIMAL data type; MONEY data type; dec_t typedef.,

subtraction, esqlc, 4-40

truncating, esqlc, 4-52

Decimal digits, display of, sqlr, 3-27

Decimal point (.),

as delimiter in INTERVAL, sqlr, 2-50

Decimal point. See \xfa , decimal point.,

Decimal separator, gls_api, 4-75, 3-5, 3-6, gls, 1-19, A-7, 7-19, 3-49, 1-14

decimal structure, esqlc, 4-4

decimal.h header file, dapi, 1-6

data types defined, esqlc, 4-4, 2-12

definition of, esqlc, 1-22

DECLARE SECTION, esqlc, 1-27

excluding C header file statements from, esqlc, 1-72

including C declaration syntax in, esqlc, 1-72

DECLARE statement, sqls, 1-303 to , gls, 3-5

and sqlca structure, esqlc, 11-39, 11-30

collection derived table with, sqls, 1-833

collection variables with, sqls, 1-833

CURSOR FOR keyword, sqlt, 5-21

CURSOR keyword, sqls, 1-316

cursors with prepared statements, sqls, 1-319

FOR INSERT clause, sqlt, 6-9

FOR READ ONLY option, sqls, 1-310

FOR UPDATE, sqlt, 6-15

FOR UPDATE column list, sqls, 1-312

FOR UPDATE option, sqls, 1-310

in thread-safe application, esqlc, 13-24

insert cursor for collection variable, esqlc, 9-21

restrictions with SELECT with ORDER BY, sqls, 1-638

SCROLL keyword, sqls, 1-317, sqlt, 5-24

select cursor for collection variable, esqlc, 9-27

SELECT with, sqls, 1-608

transactions with, sqls, 1-325

WHERE CURRENT OF clause, sqls, 1-311

with a SELECT statement, esqlc, 14-15

with an EXECUTE FUNCTION statement, esqlc, 17-28, 16-28, 14-15

with an INSERT statement, esqlc, 14-18

with deferred PREPARE, esqlc, 14-30

WITH HOLD clause, sqlt, 7-24

WITH HOLD keywords, sqls, 1-318

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

decmul() library function, esqlc, 4-7, 4-35

decround() library function, esqlc, 4-7, 4-37

decsub() library function, esqlc, 4-40, 4-7

dectoasc() library function, esqlc, 4-42, 4-7

dectodbl() library function, esqlc, 4-45, 4-7

dectoint() library function, esqlc, 4-7, 4-47

dectolong() library function, esqlc, 4-50, 4-7

dectrunc() library function, esqlc, 4-52, 4-7

.def file extension, esqlc, 1-80, 1-85, 1-87

default,

system, dapi, 5-9

default information structures, dapi, 5-10

DEFAULT keyword,

in CONNECT statement, sqls, 1-103

Default locale, sqlr, Intro-5, sqls, Intro-6, esqlc, Intro-4, sqlt, Intro-6, gls_api, 3-11, 3-13, 1-11, dapi, Intro-5, extend, Intro-4, udr, Intro-4

default code set, gls, 1-19, 1-30, 1-20, A-13

definition of, gls, 1-18

for client application, gls, 1-28

for database server, gls, 1-28

locale modifier, gls, 1-21

locale name, gls, 1-20

required, gls, A-20

Default order of compilation of ESQL/C programs, overview of, esqlc, 1-11

Default user name, bldmg_ug, 2-6, 3-8

Default value, sqlr, Glossary-7, sqlt, 9-34

CREATE TABLE limitations, sqls, 1-225

CREATE TABLE syntax for, sqls, 1-223

sysdefaults information, sqlr, 1-30

Deferred PREPARE feature, esqlc, 14-30

enabling, esqlc, 14-32

restrictions on, esqlc, 14-31

SET DEFERRED_PREPARE statement, esqlc, 14-32

with AUTOFREE and OPTOFC features, esqlc, 14-39

with OPTOFC feature, esqlc, 14-38

Deferred-PREPARE feature, sqls, 1-698

define directives, ESQL/C,

processing of, esqlc, 1-9

define preprocessor directive, esqlc, 1-61, 1-12, 1-14

DEFINE statement, sqls, 2-8

placement of, sqls, 2-10

Defining ActiveX value objects, dbdkug, 6-9

Definitions files, dbdkug, B-2, 5-4

del client command, bldmg_ug, 3-16

del logs command, bldmg_ug, 3-16

delete operator, dbdkug, 6-34

Delete privilege, sqlt, 11-8

DELETE statement, sqls, 1-327 to

all rows of table, sqlt, 4-4

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

cascading, sqls, 1-330

collection columns, esqlc, 9-44

collection columns with, sqls, 1-329

Collection derived table clause, sqls, 1-333, 1-337

Collection Derived Table clause, esqlc, 9-34, 9-68

collection derived table with, sqls, 1-833

collection variables with, sqls, 1-332, 1-333, 1-833

coordinated deletes, sqlt, 6-6

count of rows, sqls, 1-450, 1-915, sqlt, 6-4

cursor with, sqls, 1-311

defined statement constant, esqlc, 15-17, 15-18

description of, sqlt, 4-4

determining estimated cost of, esqlc, 11-30

determining number of rows deleted, esqlc, 11-30, 11-8

determining rowid, esqlc, 11-30

dynamic, esqlc, 14-40, 14-52, 15-26

embedded, sqlt, 5-6, 6-3 to

era-based dates, gls, 3-50

failing to access rows, esqlc, 11-29

GLS considerations, gls, 3-49

in ANSI-compliant database, esqlc, 3-18

interrupting, esqlc, 12-52, 12-34

known at compile time, esqlc, 14-40, 14-52

missing WHERE signalled, sqls, 1-340

not known at compile time, esqlc, 15-26

number of rows, sqlt, 5-10

object modes with, sqls, 1-657

parameterized, esqlc, 17-43, 14-52, 16-46, 15-27

preparing, sqlt, 5-31

privilege for, sqlt, 11-5, 11-8

privilege for See Privilege, table-level.,

row variables, esqlc, 9-68

row variables with, sqls, 1-337

smart large object, dapi, 3-80

transactions with, sqlt, 6-5

trigger, sqls, 1-260

using subquery, sqlt, 4-6

view with, sqlt, 11-29

WHERE clause, sqls, 1-330

checking for, sqls, 1-340

WHERE clause conditions, gls, 3-50

WHERE clause restricted, sqlt, 4-7

WHERE CURRENT OF clause, sqls, 1-331, esqlc, 14-19

with cursor, sqlt, 6-7

with DESCRIBE, esqlc, 15-23, 15-16

with SELECT...FOR UPDATE, sqls, 1-639

with update cursor, sqls, 1-331

within a transaction, sqls, 1-328

without WHERE clause, esqlc, 15-23, 11-31, 11-23, 15-18, 11-15

Deleting,

log files from the command line, bldmg_ug, 3-14

log files with the GUI, bldmg_ug, 2-13

DELIMIDENT environment variable, sqlr, 3-42, sqls, 1-972, esqlc, 9-68, 1-107, 1-33, gls, 3-10

variable name 'global' with, sqls, 1-983

Delimited identifier, esqlc, 9-68, 1-32, 14-19

See also SQL identifier.,

Delimited identifiers, gls, 3-10

Delimiter,

for DATETIME values, sqlr, 2-42

for INTERVAL values, sqlr, 2-50

specifying with LOAD, sqls, 1-523

specifying with UNLOAD, sqls, 1-775

DELIMITER keyword,

in UNLOAD, sqls, 1-775

Delimiters,

field, dbdkug, 6-27

string, dbdkug, 6-27

demo1 sample program, esqlc, 1-117

demo2 sample program, esqlc, 14-54

demo3 sample program, esqlc, 16-37, 16-15, 17-18

demo4 sample program, esqlc, 17-34, 14-54, 16-15

Demonstration database, sqlr, Intro-6, sqls, Intro-6, esqlc, Intro-5, sqlt, Intro-7, extend, Intro-5, udr, Intro-5

creating and populating, esqlc, B-3

map of, sqlr, A-8

See also stores7 database.,

structure of tables, sqlr, A-2

tables in, sqlr, A-2 to

Demonstration programs,

location, esqlc, 1-117

source files for, esqlc, B-1

Denormalization,

collection data types, with, overview, 1-19

row data types, with, overview, 1-21

Dependencies, for custom SQL, dbdkug, 3-46

DESCRIBE statement, sqls, 1-338 to , gls, 8-14

allocating memory for data, esqlc, 17-10, 2-30, 16-6, 16-7

allocating memory for sqlda, esqlc, 17-6

and deferred PREPARE, esqlc, 14-34

and lvarchar host variables, esqlc, 16-7

and sqlca structure, esqlc, 15-23

collection variable with, sqls, 1-344

Deferred-PREPARE feature with, sqls, 1-699

describing statement type, sqlt, 5-33

determining column data type, esqlc, 15-21, 15-22, 3-7, 2-8

determining return-value data type, esqlc, 15-21

determining SQL statement type, esqlc, 11-29, 11-33, 15-17

distinct data type with, sqls, 1-439

GET DESCRIPTOR with, sqls, 1-436

initializing sqlda structure, esqlc, 17-7

initializing system-descriptor area, esqlc, 16-6

INTO clause, esqlc, 17-43, 15-16, 17-4, 17-6, 17-7

INTO sqlda pointer clause, sqls, 1-343

LENGTH field, sqls, 1-438

opaque data type with, sqls, 1-438

role in dynamic SQL, esqlc, 14-10

setting COUNT field, esqlc, 16-6

SQLCODE value, esqlc, 11-33, 15-17

SQLSTATE value. See DESCRIBE statement, SQLCODE value.,

statement type, sqls, 1-339

USING SQL DESCRIPTOR clause, sqls, 1-341, esqlc, 16-46, 16-14, 15-15, 16-4, 16-29, 16-6

warnings after, esqlc, 11-31, 11-23, 11-15

with an item descriptor, esqlc, 16-14, 16-29

with deferred PREPARE, esqlc, 14-31

with input parameters, esqlc, 16-6

with SET DESCRIPTOR, sqls, 1-712

with sqlvar_struct, esqlc, 17-27, 17-17

X/Open data type values, esqlc, 15-21

Description locale, for a project, dbdkug, 3-10

Descriptor column, sqlt, 8-25

Descriptor. See System-descriptor area.,

Designing DataBlade modules, dbdkug, 2-3 to

ActiveX value objects, dbdkug, 6-7

data types, dbdkug, 2-6

design specification, dbdkug, 1-8

functional specification, dbdkug, 1-7

programming language options, dbdkug, 1-8

Destroy support function, sqls, 1-377, 1-329, 1-172

destroy() support function, dapi, 3-81, 12-277, 12-224

description of, extend, 6-20, 5-6

for smart large objects, extend, 6-22

summary of, extend, 6-4

Destructor,

LO-specification structure, dapi, 12-314

LO-status structure, dapi, 12-346

Detached index, sqlr, Glossary-7, sqls, 1-157

Developing DataBlade modules,

certifying, dbdkug, 1-12

development plan, dbdkug, 1-10

Informix registry, contacting, dbdkug, 1-11

overview, dbdkug, 1-4 to

Diagnostic area,

message codes in, sqls, 1-442

Diagnostic file, gls, 1-27, 4-3, 5-3

Diagnostic information,

definition of, esqlc, 11-4

with GET DIAGNOSTICS statement, esqlc, 11-7

with the sqlca structure, esqlc, 11-27

Diagnostic table,

examples with object mode, sqls, 1-659

many to one relationship to violations table, sqls, 1-663

starting with constraint -mode and index-mode objects, sqls, 1-666

Diagnostics area,

CLASS_ORIGIN field, esqlc, 11-10, 11-22, 11-24, 11-25

CONNECTION_NAME field, esqlc, 12-31, 11-11

definition of, esqlc, 11-7

fields of, sqls, 1-452

GET DIAGNOSTICS statement with, sqls, 1-441

INFORMIX_SQLCODE field, esqlc, 11-10, 11-13

MESSAGE_LENGTH field, esqlc, 11-11

MESSAGE_TEXT field, esqlc, 11-10, 11-24

MORE field, esqlc, 11-8

NUMBER field, esqlc, 11-8

number of exceptions, sqls, 1-450

RETURNED_SQLSTATE field, esqlc, 11-10, 11-12

ROW_COUNT field, esqlc, 11-8

See also GET DIAGNOSTICS statement.,

SERVER_NAME field, esqlc, 12-31, 11-11

SUBCLASS_ORIGIN field, esqlc, 11-10, 11-22, 11-24, 11-25

undefined fields, esqlc, 11-13

Diagnostics table,

creating with START VIOLATIONS TABLE, sqls, 1-748

examples, sqls, 1-763, 1-765, 1-768

how to stop, sqls, 1-767

privileges on, sqls, 1-761

relationship to target table, sqls, 1-753

relationship to violations table, sqls, 1-753

starting with filtering-mode objects, sqls, 1-653

starting with START VIOLATIONS TABLE, sqls, 1-748

stopping with filtering-mode objects, sqls, 1-654

structure, sqls, 1-760

sysviolations information, sqlr, 1-61

use with SET, sqls, 1-653

Digit character,

decimal number, gls_api, 4-90, 4-121, 4-113, 4-97, 4-115, 4-88, 2-11, 2-13

hexadecimal number, gls_api, 4-111, 4-135, 2-11, 2-13

Digit class, gls_api, 4-121, 4-113, 4-97, 4-88, 2-11, 2-13

Directive. See Preprocessor directive.,

Directories,

client files, for, bldmg_ug, 3-12, 2-11

DataBlade modules on UNIX, bldmg_ug, 1-5

DataBlade modules on Windows NT, bldmg_ug, 1-6

log files, bldmg_ug, 3-14

Directory, generated file property, dbdkug, 3-50

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

Disabled object mode, sqls, 1-658

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

DISCONNECT statement, sqls, 1-346 to , esqlc, 12-93, 12-98

ALL keyword,