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,
syscoldepend (dependencies), sqlr, 1-23
sysconstraints information about, sqlr, 1-29
Constraint mode,
definition, in CREATE TABLE, sqls, 1-241
restriction, sqls, 1-229
types of, sqls, 1-242
using, sqls, 1-243
Constraint Name segment,
syntax, sqls, 1-855
Constraints,
enforcing, sqlt, 11-23
Constructor,
LO-specification structure, dapi, 12-316, 3-34
LO-status structure, dapi, 3-76, 12-338
Constructor function, sqls, 1-900
Constructor functions, example of, overview, B-3
Constructor. See Type constructor.,
Constructor. See Type constructors.,
Contains method/routine, dbdkug, 7-8, 6-18
CONTINUE statement, sqls, 2-7
Control character, gls_api, 4-95, 4-119, 2-12, 2-13
control flag, dapi, 12-99
conv_state_t structure, gls_api, 4-47, 2-25
Conventions, dbdkug, Intro-7, bldmg_ug, Intro-5
syntax, dbdkug, Intro-7
typographical, dbdkug, Intro-6
Conversion,
date strings, gls_api, 4-15
date/time strings, gls_api, 4-24
definition of, gls_api, 3-9
INFORMIX-GLS functions for, gls_api, 3-11
money strings, gls_api, 4-35
number strings, gls_api, 4-40
See also Case conversion; Code-set conversion; Formatting.,
time strings, gls_api, 4-24
wide-character string to multibyte-character string, gls_api, 4-221
conversion,
integer byte ordering, dapi, 12-122
smallint byte ordering, dapi, 12-124
Conversion modifier, gls, 2-29, 1-51, 2-37
Conversion. See Data conversion.,
Converting,
date value to string, gls_api, 4-15
date/time value to string, gls_api, 4-24
money value to string, gls_api, 4-35
number value to string, gls_api, 4-40
string to date value, gls_api, 4-53
string to date/time value, gls_api, 4-61
string to money value, gls_api, 4-71
string to number value, gls_api, 4-77
string to time value, gls_api, 4-61
time value to string, gls_api, 4-24
Converting data types with casts, dbdkug, 3-17
Converting data types. See Casts.,
Coordinated deletes, sqlt, 6-6
Copying,
multibyte-character string, gls_api, 4-150, 4-162, 2-32
wide-character string, gls_api, 4-210, 4-201, 2-32
copying,
bytes, dapi, 12-166, 12-390
double precision values, dapi, 12-395, 12-181
integer values, dapi, 12-184, 12-399
smallints, dapi, 12-406
Correlated subquery,
cascading deletes with, sqls, 1-240
Correlated subquery. See Subquery, correlated.,
Correlation name,
definition of, sqlr, Glossary-5
in triggered action, sqls, 1-274
rules for, sqls, 1-274
scope of, sqls, 1-275
table of values, sqls, 1-276
use with a routine, sqls, 1-279
when to use, sqls, 1-275
COS function, sqls, 1-937, 1-938
cos() built-in function, extend, 2-8
Cost estimates,
query plans, dbdkug, 2-19
routines, dbdkug, 3-30, 2-15
COUNT descriptor field,
after a DESCRIBE, esqlc, 15-15, 16-6
definition of, esqlc, 15-7
determining number of return values, esqlc, 16-27
initializing, esqlc, 16-5
saving, esqlc, 16-10, 16-14, 16-29, 16-18
setting, esqlc, 16-9, 16-40, 16-36
COUNT field,
with DESCRIBE, sqls, 1-342
with GET DESCRIPTOR, sqls, 1-435
with SET DESCRIPTOR, sqls, 1-705
COUNT function, sqls, 1-949
and GROUP BY, sqlt, 3-6
count rows to delete, sqlt, 4-5
DISTINCT keyword with, sqlt, 2-51
use in a subquery, sqlt, 4-6
with (*) argument, sqls, 1-949
with column name argument, sqls, 1-952
with DISTINCT keyword, sqls, 1-951
COUNT functions, sqls, 1-949
Counting number of values in a string, dbdkug, 5-19
-cp preprocessor option, esqlc, 1-49
CPFIRST environment variable, esqlc, 1-68
-cpu processor option, esqlc, 1-92
CPU virtual processor,
adding and dropping in on-line mode, udr, 5-11
CREATE CAST statement, sqls, 1-112 to , gls, 4-17, extend, 5-25, 5-17, 5-18
EXPLICIT keyword, sqls, 1-114, extend, 3-7
IMPLICIT keyword, sqls, 1-115, extend, 3-6
WITH clause, sqls, 1-116, extend, 3-9
CREATE DATABASE statement, sqls, 1-117, esqlc, 12-18, 12-19, 12-20, 15-17, 12-27, sqlt, 9-38, gls, 3-6
ANSI compliance, sqls, 1-118
in command script, sqlt, 9-42
logging, sqls, 1-119
restrictions, sqls, 1-118
sets shared lock, sqlt, 7-8
SQLWARN flags, sqlt, 5-12
WITH BUFFERED LOG option, sqls, 1-119
WITH LOG clause, sqls, 1-119
CREATE DISTINCT TYPE statement, sqls, 1-121, gls, 4-17, extend, 1-15
CREATE DOMAIN statement,
using, sqlt, 9-35
CREATE FUNCTION,
EXTERNAL NAME clause, udr, 3-11
OUT parameter, udr, 3-14
CREATE FUNCTION statement, sqls, 1-125 to , esqlc, 14-46, gls, 4-17, extend, 5-19, 1-16, 2-10, 5-25, 5-15, 1-11, udr, 5-9
and VPCLASS, udr, 5-10
cast registration examples, sqlt, 13-21
DBA keyword, sqls, 1-129
DOCUMENT clause, sqls, 1-131
External Routine Reference, sqls, 1-131
Procedure List, sqls, 1-1033
registering a function, udr, 3-10
Return clause, sqls, 1-1025, 1-130
routine overloading, udr, 2-3
setting stack size, dapi, 11-5
SPECIFIC keyword with specific name, udr, 2-6
WITH LISTING IN clause, sqls, 1-132, sqlt, 14-80
CREATE INDEX statement, sqls, 1-137 to , esqlc, 12-52, 12-34, 15-17, gls, 3-4, 3-20, 3-6
ASC keyword, sqls, 1-145
built-in secondary access method, extend, 4-5
CLUSTER keyword, sqls, 1-139
composite indexes, sqls, 1-153
default operator class, extend, 4-10, 4-8
DESC keyword, sqls, 1-145
DISTINCT keyword, sqls, 1-139
FILLFACTOR clause, sqls, 1-156
fragment by expression, sqls, 1-158
implicit table locks, sqls, 1-138
IN dbspace clause, sqls, 1-157
Index Definition clause, sqls, 1-140
object modes, sqls, 1-161 to
storage option, sqls, 1-157
UNIQUE keyword, sqls, 1-139
user-defined secondary access method, extend, 4-6
USING clause, sqls, 1-151, extend, 4-10, 4-6, 4-8
CREATE OPAQUE TYPE statement, sqls, 1-167 to , gls, 4-17, extend, 1-14
ALIGNMENT modifier, sqls, 1-170, extend, 5-12
CANNOTHASH modifier, sqls, 1-170, extend, 5-23
INTERNALLENGTH keyword, extend, 5-10
INTERNALLENGTH modifier, sqls, 1-168
MAXLEN modifier, sqls, 1-170, extend, 5-11, 5-13
Modifier clause, sqls, 1-169
PASSEDBYVALUE modifier, sqls, 1-170
registering the opaque type, extend, 5-14
VARIABLE keyword, sqls, 1-169
CREATE OPAQUE TYPE statement, maxlength value and lvarchar, esqlc, 10-6
CREATE OPCLASS statement, sqls, 1-174 to , gls, 4-18
STRATEGY clause, sqls, 1-176
SUPPORT clause, sqls, 1-178
CREATE PROCEDURE FROM statement, sqls, 1-134, 1-191
CREATE PROCEDURE statement, sqls, 1-181 to , esqlc, 14-46, 15-18, gls, 4-18, 3-6, 3-7, extend, 1-16, 2-10, 5-25, 1-11
DBA keyword, sqls, 1-185
DOCUMENT clause, sqls, 1-188
External Routine Reference, sqls, 1-187
Procedure List, sqls, 1-1033
Return clause, sqls, 1-186
setting stack size, dapi, 11-5
SPECIFIC keyword with specific name, udr, 2-6
WITH LISTING IN clause, sqls, 1-188, sqlt, 14-80
CREATE ROLE statement, sqls, 1-193, gls, 3-6
CREATE ROUTINE FROM statement, sqls, 1-195
CREATE ROW TYPE statement, gls, 4-18
extended field definition, sqls, 1-202
field definition, sqls, 1-203
field definition syntax, sqls, 1-876
syntax, sqls, 1-197
UNDER clause, sqls, 1-200
CREATE SCHEMA statement, sqls, 1-204
defining a trigger, sqls, 1-259
example, sqlr, 1-4
GRANT with, sqls, 1-206
CREATE SYNONYM statement, sqls, 1-207 to , gls, 3-7
chaining synonyms, sqls, 1-209
synonym for a table, sqls, 1-207
synonym for a view, sqls, 1-207
CREATE TABLE statement, sqls, 1-211 to , esqlc, 9-72, 12-52, 7-14, 12-34, 15-17, dapi, 3-44, 3-46, extend, 5-18
access method option, sqls, 1-255
cascading deletes, sqls, 1-239
character data types, gls, 3-11
CHECK clause, sqls, 1-233
column definition clause, sqls, 1-222
column name in, gls, 3-5
constraint definition,
column-level, sqls, 1-230
table-level, sqls, 1-231
constraint mode definition, sqls, 1-241
constraint name in, gls, 3-5
DEFAULT clause, sqls, 1-223
description of, sqlt, 9-40
FRAGMENT BY clause, sqls, 1-247
fragmentation by expression with, sqls, 1-249
in command script, sqlt, 9-42
IN dbspace clause, sqls, 1-246
LOCK MODE clause, sqls, 1-254
MONEY columns, gls, 3-48
naming database objects, gls, 3-4
ON DELETE CASCADE keywords, sqls, 1-235, 1-239
options clauses, sqls, 1-243
PUT clause, sqls, 1-250
REFERENCES clause, sqls, 1-235
setting columns to NOT NULL, sqls, 1-224
storage option, sqls, 1-245
table name in, gls, 3-7
WITH NO LOG keywords, sqls, 1-244
WITH ROWIDS clause, sqlt, 9-53
WITH ROWIDS keywords, sqls, 1-244
CREATE TRIGGER statement, sqls, 1-258 to , gls, 3-7
action clause referencing, sqls, 1-270
AFTER action keyword, sqls, 1-265
CREATE SCHEMA with, sqls, 1-259
DISABLED/ENABLED keywords, sqls, 1-286
ESQL/C restriction, sqls, 1-259
FOR EACH ROW action, sqls, 1-265
INSERT REFERENCING clause, sqls, 1-267
privileges for, sqls, 1-259
trigger object modes, sqls, 1-286
triggered action list, sqls, 1-271
UPDATE clause, sqls, 1-262
UPDATE REFERENCING clause, sqls, 1-269
WHEN condition, sqls, 1-271
CREATE VIEW statement, sqls, 1-289 to , gls, 3-7
column data types, sqls, 1-290
privileges, sqls, 1-290
sysviews information, sqlr, 1-8
virtual column, sqls, 1-291
WITH CHECK OPTION,
1-292, sqls, 1-292
keywords, sqlt, 11-31
with SELECT * notation, sqls, 1-290
Create-time flags, esqlc, 7-77, 7-67, dapi, 12-322
create_clob sample program, esqlc, 7-100
CreateLvarChar method, dbdkug, 6-32
CreateNew method, dbdkug, 6-26
Creating DataBlade modules, overview, 2-7
CROWTYPE data-type constant, esqlc, 2-11
See also row data type (ESQL/C).,
CSHORTTYPE data-type constant, esqlc, 2-10
See also short data type.,
CSTRINGTYPE data-type constant, esqlc, 2-10, 2-33
See also string data type.,
CTYPE locale category,
character case, gls, 7-23
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
white-space characters, gls, 2-35, 2-26
CTYPE locale category. See LC_CTYPE locale-file category.,
Currency data. See Monetary data.,
Currency notation, gls, 1-15, 2-19, 1-53
Currency symbol, gls_api, 4-74, 3-6, gls, 1-15, A-7, 1-20, 7-19, 3-49
Current database, specifying with DATABASE, sqls, 1-295
CURRENT function, sqls, 1-897, 1-844
CREATE TABLE with, sqls, 1-223
example, sqls, 1-506
CURRENT OF keywords,
in DELETE, sqls, 1-331
in UPDATE, sqls, 1-794
current processing, gls_api, 1-11
Current processing locale, gls_api, 1-18, 4-86, 2-41, 1-21, 1-11, 2-24
current() built-in function, extend, 2-9
Cursor, gls, 1-48, 1-5, 1-6, 3-5, 4-8, 7-6
active set, sqlt, 5-24 to
characteristics, sqls, 1-316
CLOSE statement, sqls, 1-93
closing, sqls, 1-684, 1-93 to , 1-96, sqlt, 7-23
ROLLBACK WORK effects, sqls, 1-594
declaring, sqlt, 5-21
declaring multiple, sqls, 1-305
definition of, sqlr, Glossary-5
dynamic, sqls, 1-306
example,
parts explosion, sqlt, 5-27
fetching values, sqls, 1-411, sqlt, 5-22
freeing automatically with SET AUTOFREE, sqls, 1-676
host variable for, sqls, 1-305
locking considerations, sqls, 1-312
manipulation statements, sqls, 1-15
maximum number of, sqls, 1-305
modes, sqls, 1-309
name restriction, sqls, 1-980
OPEN statement for, sqls, 1-528 to
opening, sqls, 1-698, 1-529, sqlt, 5-21
optimizing, sqls, 1-698, 1-676
prepared statement with, sqls, 1-319
restricted statements, sqls, 1-314
scope of, sqls, 1-305
scroll, sqlt, 5-23
select hold examples, sqls, 1-318
sequential function, sqls, 1-414
sequential select, sqls, 1-414
statement identifier with, sqls, 1-319
transaction end with, sqls, 1-95
transaction with, sqls, 1-325
example, sqls, 1-326
guidelines, sqls, 1-325
trigger with, sqls, 1-260
types of, sqls, 1-306
Cursor (database),
and sqlca.sqlerrd, esqlc, 11-30
deferring PREPARE, esqlc, 14-30
definition of, esqlc, 14-14
dynamic, esqlc, 13-17, 14-19
for receiving rows, esqlc, 14-14
for sending rows, esqlc, 14-18
freeing, esqlc, 14-24, 14-13
hold, esqlc, 14-15, 14-18
identifying variable mismatch, esqlc, 11-31, 11-23, 11-15
in thread-safe application, esqlc, 13-24
insert, esqlc, 14-18
interrupting the database server, esqlc, 12-52
naming, esqlc, 14-19
optimizing, esqlc, 14-20
scroll, esqlc, 14-15
See also Fetching; SELECT statement.,
sequential, esqlc, 14-15, 14-18
sizing the cursor buffer, esqlc, 14-20
update, esqlc, 14-15
using, esqlc, 14-14
Cursor buffer,
changing size of, esqlc, 14-22
default size, esqlc, 14-22
description, esqlc, 14-20
fetch buffer, esqlc, 14-20
insert buffer, esqlc, 14-20
sizing, esqlc, 14-20
Cursor function, sqlr, Glossary-5, sqls, 2-28
definition of, esqlc, 14-48
known at compile time, esqlc, 14-50
not known at compile time, esqlc, 17-28, 16-28
parameterized, esqlc, 14-54
See also SPL function.,
with sqlda structure, esqlc, 17-28
with system-descriptor area, esqlc, 16-28
Cursor name,
'execute', 'select', 'with' as, sqls, 1-983
Cursor names,
case sensitivity, esqlc, 1-18
scope rules, esqlc, 13-24, 1-65
specifying, esqlc, 14-19
using delimited identifiers, esqlc, 1-33, 14-19
using host variables, esqlc, 14-19
Cursor routine, sqlt, 14-30
Cursor Stability isolation level (Informix), sqls, 1-724, sqlt, 7-14
Cursor. SeeCollection cursor; Function cursor; Hold cursor.; Insert cursor; > Read-only cursor; Scroll cursor; Select cursor; Sequential cursor; Update cursor.,
CurString method, dbdkug, 6-28
cust_calls table in stores7 database, columns in, sqlr, A-6
Custom methods,
accessing, dbdkug, 7-5
reference, dbdkug, 7-8
customer table in stores7 database, sqlr, A-2
.cv file extension, gls, A-15, 1-42, A-20
CVARBINTYPE data-type constant, esqlc, 2-11
See also var binary data type.,
CVCHARTYPE data-type constant, esqlc, 2-10
See also varchar data type.,
.cvo file extension, gls, A-15, A-20
cvY.txt file, gls, A-25
See also Privilege,table-level.,
See also Check constraint; Not null constraint;Primary key constraint;Referential constraint; Referntial integrity.,
shared unique constraint index, sqls, 1-83
table-level, sqls, 1-231
transaction mode, sqls, 1-672
unique, sqls, 1-83
with DROP INDEX, sqls, 1-358



Copyright © 1997, Informix Software, Inc. All rights reserved.