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 ]

L

l preprocessor option, esqlc, 1-76
-l processor option, esqlc, 1-80, 1-88
L10n abbreviation, gls_api, 1-9
Label, sqlt, 3-43, 2-48
LANG environment variable, esqlc, 1-106
precedence of, gls, 2-16, 2-17, 1-39, 1-52, 1-53, 1-25
sending to database server, gls, 1-32
Language,
code sets, gls, 1-43
default, gls, 1-20
for client application, gls, 1-23
for database, gls, 1-26
for database server, gls, 1-27
in locale name, gls, 1-20, A-10, 1-33
supported,
sysroutinelangs information, sqlr, 1-51
Language environment,
DBLANG, sqlr, 3-28
setting with DBLANG, sqlr, 3-28
Large object, sqlr, 2-16, sqls, 1-869, sqlt, 9-24 to
attaching tables, sqls, 1-36
character, sqlr, 2-38
constraints, sqls, 1-229
definition of, sqlr, Glossary-11
fragmentation with, sqls, 1-36
See also Simple large object ; Smart large object.,
Large object. See Simple large-object data type; Smart large-object data type.,
Large objects,
defined, dbdkug, C-1, 2-7
documentation of, overview, A-7
loading from a file, dbdkug, 5-19
LOhandles function, dbdkug, 5-31
writing to a file, dbdkug, 5-19
last_frag field, gls_api, 4-47, 2-25
.lc file extension, gls, A-15, A-20, A-11, A-12
LC_* environment variables. See the LC_COLLATE, LC_CTYPE, LC_MONETARY, LC_NUMERIC, LC_TIME environment variables individually.,
LC_COLLATE environment variable, esqlc, 1-106, gls, 1-24
LC_COLLATE locale-file category, gls_api, 4-200, 4-148, 2-34, 2-35
LC_COLLATION environment variable, gls, 1-37
LC_CTYPE environment variable, esqlc, 1-107, gls, 1-37, 1-24
LC_CTYPE locale-file category,
alnum class, gls_api, 4-113, 4-89, 2-11
alpha class, gls_api, 4-91, 4-116, 2-11
blank class, gls_api, 4-93, 4-117, 2-12
cntrl class, gls_api, 4-96, 4-119, 2-12
description of, gls_api, 2-11
digit class, gls_api, 4-122, 4-98, 2-11
graph class, gls_api, 4-123, 4-99, 2-12
lower class, gls_api, 4-102, 4-126, 2-11
print class, gls_api, 4-104, 4-127, 2-12
punct class, gls_api, 4-130, 4-106, 2-12
space class, gls_api, 4-132, 4-108, 2-12
upper class, gls_api, 4-110, 4-134, 2-11
use in case conversion, gls_api, 2-15
use in character classification, gls_api, 2-13
xdigit class, gls_api, 4-112, 4-136, 2-11
LC_MONETARY environment variable, esqlc, 1-107, gls, 1-39, 1-53, 1-25
LC_MONETARY locale-file category,
currency_symbol subcategory, gls_api, 4-73, 3-6, 4-37
description of, gls_api, 3-5
int_curr_symbol subcategory, gls_api, 4-73, 3-6, 4-37
subcategories of, gls_api, 3-6
use in conversion, gls_api, 4-36, 4-38
use in formatting, gls_api, 4-72, 4-76
LC_NUMERIC environment variable, esqlc, 1-107, gls, 1-39, 1-25
LC_NUMERIC locale-file category,
description of, gls_api, 3-4
subcategories of, gls_api, 3-5
use in conversion, gls_api, 4-41, 4-44
use in formatting, gls_api, 4-81, 4-78
LC_TIME environment variable, esqlc, 1-107, gls, 1-39, 1-51, 1-25
precedence, gls, 1-52
LC_TIME locale-file category,
abday subcategory, gls_api, 4-18, 4-63, 4-55, 3-8, 4-27
abmon subcategory, gls_api, 4-18, 4-63, 4-55, 3-8, 4-27
alt_digits subcategory, gls_api, 4-29, 4-20, 4-65, 4-56, 3-8
am_pm subcategory, gls_api, 4-64, 3-8, 4-28
converting date values, gls_api, 4-22
converting date/time values, gls_api, 4-33
d_fmt subcategory, gls_api, 4-19, 4-65, 4-54, 4-56, 3-8, 4-16, 4-28
d_t_fmt subcategory, gls_api, 4-62, 4-63, 3-8, 4-25, 4-27
day subcategory, gls_api, 4-18, 4-63, 4-55, 3-8, 4-27
description of, gls_api, 3-7
era subcategory, gls_api, 4-30, 4-20, 4-66, 3-8, 4-57
era_d_fmt subcategory, gls_api, 4-30, 4-20, 4-66, 3-8, 4-57
era_d_t_fmt subcategory, gls_api, 4-30, 4-66, 3-8
era_t_fmt subcategory, gls_api, 4-30, 4-66, 3-8
formatting date values, gls_api, 4-59
formatting date/time values, gls_api, 4-69
mon subcategory, gls_api, 4-18, 4-63, 4-55, 3-8, 4-27
subcategories of, gls_api, 3-8
t_fmt subcategory, gls_api, 4-65, 3-8, 4-28
t_fmt_ampm subcategory, gls_api, 4-64, 3-8, 4-28
.lco file extension, gls, A-20, A-11
lcX.txt file, gls, A-22, A-24
LD_LIBRARY_PATH environment variable, esqlc, 13-9, dbdkug, 8-4
ldchar() library function, esqlc, 8-67, 3-30
LENGTH descriptor field,
after a DESCRIBE, esqlc, 16-21, 16-6
definition of, esqlc, 15-7
for varchar data, esqlc, 3-7
inserting opaque-type data, esqlc, 15-29
setting input parameter length, esqlc, 16-41, 16-36
LENGTH field,
and TYPE field, sqls, 1-709
with DATETIME and INTERVAL types, sqls, 1-710
with DECIMAL and MONEY types, sqls, 1-710
with DESCRIBE, sqls, 1-709, 1-342
with SET DESCRIPTOR, sqls, 1-709
LENGTH function, sqls, 1-921, sqlt, 2-60, gls, 3-40
Length functions, sqls, 1-920
length() built-in function, extend, 2-8
Length-terminated string, gls_api, 2-37
Less than (<) sign, esqlc, 5-30
LessThan method/routine, dbdkug, 7-7, 6-18, 7-9
lessthan() function, extend, 2-6, 4-8
lessthan() operator function, sqls, 1-1020
LessThanOrEqual method/routine, dbdkug, 6-18, 7-9
lessthanorequal() function, extend, 2-6, 4-8
lessthanorequal() operator function, sqls, 1-1020
LET statement, sqlt, 14-26
syntax, sqls, 2-39
Level, for tracing, dbdkug, 5-13
.lib file extension, esqlc, 1-80
libasf Informix library, esqlc, 13-5, 13-13, 1-88
libgen Informix library, esqlc, 13-5, 13-13, 1-88
libgls Informix library, esqlc, 13-5, 13-13, 1-88
libos Informix library, esqlc, 13-5, 13-13, 1-88
Libraries,
Informix. See Informix general library.,
of ESQL/C functions, esqlc, 1-7
runtime search path, esqlc, 13-9
shared, esqlc, 13-10, 13-3, 13-8
static, esqlc, 13-3, 13-7
thread-safe, esqlc, 13-3
thread-safe shared, esqlc, 13-28
thread-safe static, esqlc, 13-28
Library, sqlr, Glossary-11
C++ support, dbdkug, B-2, B-4, 6-34, 6-27 to
creating dynamic thread, esqlc, 13-40
ESQL client-interface, esqlc, 1-96, 1-85
import, esqlc, 1-96
library calls, avoiding, dbdkug, 4-10
library files, setting in Visual C++, dbdkug, 5-40, 6-21
runtime, esqlc, 1-93
sapi.lib file, dbdkug, 5-39
shared, sqlr, Glossary-17, sqls, 1-922
static-link, esqlc, 1-95, 1-96
system, esqlc, 1-80
library errors, dapi, 9-11
Library function. See ESQL/C library functions; Function library.,
-libs preprocessor option, esqlc, 1-50
-libs processor option, esqlc, 1-87, 1-55
libsql Informix library, esqlc, 13-5, 13-13, 1-88
libtgen Informix library, esqlc, 13-13
libtos Informix library, esqlc, 13-13
libtsql Informix library, esqlc, 13-13
Lightweight I/O,
for smart large objects, esqlc, 7-25
specifying for all smart large objects, esqlc, 7-26
switching to buffered I/O, esqlc, 7-26
LIKE relational operator, gls, 3-30, 1-10
like() function, extend, 2-6
like() operator function, sqls, 1-847
Limits, Informix product, esqlc, Intro-14
Line wrapping, esqlc, 1-74
Link, sqlr, Glossary-11
Linker,
linking the ESQL client-interface DLL, esqlc, 1-96
marking beginning of arguments, esqlc, 1-80
options invoked implicitly, esqlc, 1-83
passing arguments to, esqlc, 1-88
LIST, sqlr, Glossary-11, sqlt, 10-18
list command, bldmg_ug, 3-17
LIST data type, sqlr, 2-51
accessing, esqlc, 9-4
after a DESCRIBE, esqlc, 17-8
corresponding ESQL/C data type, esqlc, 2-5, 2-13
declaring host variable for, esqlc, 9-6
defined constant, esqlc, 2-9
definition of, esqlc, 9-4
deleting elements, sqls, 1-332
deleting elements from, sqls, 1-333, 1-329
inserting many elements into, esqlc, 9-20
See also Collection data type (SQL).,
selecting one element from, sqls, 1-614
syscolumns coltype code for, sqlr, 1-24
unloading, sqls, 1-770
updating elements, sqls, 1-791, 1-797, 1-798
updating elements in, sqls, 1-803
LIST type constructor, overview, 1-18
LIST, type constructor, dbdkug, 3-32
Literal, sqlr, Glossary-11
Collection, sqls, 1-990 to
expression with, sqls, 1-899
nested example, sqls, 1-993
quotation marks with, sqls, 1-993
syntax for non-collection elements, sqls, 1-991
DATETIME, sqls, 1-996 to
current date, sqls, 1-897
quoted string as, sqls, 1-1017
INSERT with, sqls, 1-501
INTERVAL, sqls, 1-999 to
expression with, sqls, 1-898
quoted string as, sqls, 1-1017
Number, sqls, 1-1002
expression with, sqls, 1-896
Row, sqls, 1-1004 to
expression with, sqls, 1-900
literal collection with, sqls, 1-993
nested row containing, sqls, 1-1007
Literal Collection segment, sqls, 1-990
Literal DATETIME segment, sqls, 1-996
Literal matches, gls, 3-28, 3-31
Literal Row segment, sqls, 1-1004
Literal string, gls, 2-5, 7-7, 1-12
LO file descriptor,
creating, dapi, 12-272, 12-275, 12-288, 12-301, 12-280
deallocating, esqlc, 7-29, dapi, 12-264, 3-70
declaring, dapi, 3-23
description, dapi, 7-12
description of, esqlc, 7-20, dapi, 1-7, 3-20, 3-22
ESQL/C functions for, esqlc, 7-20
functions for, dapi, 3-25
obtaining, dapi, 3-50, 3-75, 3-53
LO handle,
allocating, dapi, 3-52
binary representation, dapi, 3-62
checking validity of, dapi, 12-365
comparing, dapi, 12-302
converting to binary, dapi, 12-293
converting to text, dapi, 12-362
deallocating, dapi, 3-56, 12-309
declaring, dapi, 3-22
deleting from a database, dapi, 3-80
description, dapi, 7-12
description of, dapi, 1-7, 3-20, 3-21, 3-8
fetching from a database, dapi, 3-17
functions for, dapi, 3-26
in BLOB column, dapi, 3-15
in CLOB column, dapi, 3-15
in DELETE, dapi, 3-80
in INSERT, dapi, 3-18, 3-55
in opaque data type, dapi, 3-16
in SELECT, dapi, 3-17, 3-61
in UPDATE, dapi, 3-18, 3-73, 3-55
invalidating, dapi, 12-296
memory duration, dapi, 3-82, 3-56
memory duration of, dapi, 3-52
obtaining, dapi, 3-50, 3-51
representations of, dapi, 3-62
retrieving from client, dapi, 12-187
selecting from a database, dapi, 3-61
sending to client, dapi, 12-402
storing in a database, dapi, 3-18, 3-73, 3-55
text mode, dapi, 3-62
updating, dapi, 3-73
valid, dapi, 3-63
validating, dapi, 3-63
LO handle, deallocating, esqlc, 7-59
LO seek position,
current, dapi, 12-367, 12-304
definition of, dapi, 12-354, 3-22
initial, dapi, 3-22
initializing, dapi, 12-300
obtaining, dapi, 12-354, 3-53, 3-69
read operations, dapi, 3-66, 3-69
specifying, dapi, 12-370, 12-311, 3-53, 12-307, 3-69
write operations, dapi, 3-53, 3-66
LO-pointer structure,
creating, esqlc, 7-16
description of, esqlc, 7-18
ESQL/C functions for, esqlc, 7-19
in INSERT, esqlc, 7-17
in UPDATE, esqlc, 7-17
obtaining a valid, esqlc, 7-30
LO-specification structure,
allocating, esqlc, 7-49, 7-7, dapi, 12-316, 3-34, 3-35
allocation extent size, esqlc, 7-75, 7-66, dapi, 12-330, 12-320, 3-48
attributes flag, dapi, 12-332, 3-48
constructor, dapi, 12-316, 3-34
create-time flags, esqlc, 7-10, 7-77, 7-67, dapi, 12-322
deallocating, esqlc, 7-63, 7-16, dapi, 12-314, 3-56
declaring, dapi, 3-21, 3-23
description of, esqlc, 7-8, dapi, 1-7, 3-20, 3-21
destructor, dapi, 12-314
disk-storage information, esqlc, 7-8, dapi, 3-47
ESQL/C functions for, esqlc, 7-11
estimated size, esqlc, 7-73, 7-64, dapi, 12-328, 12-318, 3-47
functions for, dapi, 3-28
initializing, esqlc, 7-49, dapi, 12-317
last-access time indicators, dapi, 3-49
logging indicators, dapi, 3-49
maximum size, esqlc, 7-79, 7-69, dapi, 12-334, 12-324, 3-47
memory duration, dapi, 3-56
memory duration of, dapi, 3-34
obtaining, dapi, 3-33
sbspace name, esqlc, 7-71, 7-80, dapi, 12-336, 12-326, 3-48
setting, esqlc, 7-84, 7-39
setting fields of, dapi, 12-266, 12-268
storage characteristics, esqlc, 7-12, dapi, 3-37
LO-status structure,
allocating, esqlc, 7-30, dapi, 3-76, 3-77, 12-338
constructor, dapi, 12-338
deallocating, esqlc, 7-87, 7-32, dapi, 3-80, 12-346
description of, esqlc, 7-30, dapi, 3-20, 1-8, 3-23
destructor, dapi, 12-346
functions for, dapi, 3-30
initializing, dapi, 12-339
last-access time, dapi, 12-340, 3-78
last-change time, dapi, 12-344, 3-78
last-modification time, dapi, 12-348, 3-78
memory duration, dapi, 3-80
memory duration of, dapi, 3-76
obtaining, dapi, 3-76
reference count, dapi, 12-350, 3-78
size, dapi, 12-352, 3-78
storage characteristics, dapi, 12-342, 3-78
LO_APPEND access-mode constant, esqlc, 7-24, 7-25
LO_APPEND file-location constant, esqlc, 7-44
LO_BUFFER access-mode flag, esqlc, 7-25
LO_CLIENT_FILE file-location constant, esqlc, 7-41, 7-44
LO_KEEP_LASTACCESS_TIME create-time constant, esqlc, 7-31, 7-10
LO_LOG create-time constant, esqlc, 7-10
LO_NOBUFFER access-mode flag, esqlc, 7-25
LO_NOKEEP_LASTACCESS_TIME create-time constant, esqlc, 7-10
LO_NOLOG create-time constant, esqlc, 7-10
LO_RDONLY access-mode constant, esqlc, 7-24, 7-25
LO_RDWR access-mode constant, esqlc, 7-24, 7-25
LO_SEEK_CUR whence constant, esqlc, 7-62, 7-99, 7-58
LO_SEEK_END whence constant, esqlc, 7-62, 7-99, 7-58
LO_SEEK_SET whence constant, esqlc, 7-62, 7-99, 7-58
LO_SERVER_FILE file-location constant, esqlc, 7-41, 7-44
LO_WRONLY access-mode constant, esqlc, 7-24, 7-25
Load file, gls, 3-52
LOAD FROM file, sqls, 1-517
LOAD statement, sqls, 1-515, gls, 3-52, 3-6, 3-49
DELIMITER clause, sqls, 1-523
format requirements, sqls, 1-517
INSERT INTO clause, sqls, 1-524
LOAD FROM file, sqls, 1-517
loading CHAR and VARCHAR data types, sqls, 1-520
loading CLOB or BLOB columns, sqls, 1-521
loading collections, sqls, 1-522
loading row types, sqls, 1-522
loading TEXT or BYTE columns, sqls, 1-521
opaque-type columns, sqls, 1-522
privileges, sqls, 1-516
specifying the table to load into, sqls, 1-524
Loading shared object in the server address space, dbdkug, 8-15
LOB Locator DataBlade module, dbdkug, 2-8, overview, B-3
LOC_ALLOC locator constant, esqlc, 8-13
LOC_APPEND locator mask, esqlc, 8-20, 8-22
loc_buffer field, gls, 8-14
LOC_DESCRIPTOR locator mask, esqlc, 8-40
LOC_RONLY locator mask, esqlc, 8-20, 8-34, 8-25
loc_t data type, gls, 8-12, 8-13
corresponding SQL data type, esqlc, 2-4, 2-5
declaration, esqlc, 8-5
defined constant, esqlc, 2-10
definition of, esqlc, 8-5
role of locator.h, esqlc, 2-11, 2-12
See also BYTE data type; Locator structure; TEXT data type.,
loc_t structure, with fetch array, esqlc, 15-39
loc_t.lc_union structure. See individual field names under Locator structure.,
loc_t.loc_loctype field,
assigning values to, esqlc, 8-10
definition of, esqlc, 8-10, 8-8
LOCFILE value, esqlc, 8-21, 8-10
LOCFNAME value, esqlc, 8-10, 8-26
LOCMEMORY value, esqlc, 8-10, 16-55, 8-11
LOCUSER value, esqlc, 8-31, 8-10
loc_t.loc_oflags field,
file-open mode flags, esqlc, 8-20
setting for memory, esqlc, 8-12
setting for named file, esqlc, 8-26
setting for open file, esqlc, 8-21
setting for optical disc, esqlc, 8-40
using LOC_APPEND mask, esqlc, 8-20
using LOC_RONLY mask, esqlc, 8-20, 8-34
using LOC_USEALL mask, esqlc, 8-30
using LOC_WONLY mask, esqlc, 8-20, 8-33
loc_t.loc_size field,
definition of, esqlc, 8-9
determining transfer size, esqlc, 8-30
indicating simple large-object size, esqlc, 8-13, 8-14
inserting a simple large object, esqlc, 8-34, 8-25
loc_type field, gls, 8-13
LOC_USEALL locator mask, esqlc, 8-30
LOC_WONLY locator mask, esqlc, 8-20, 8-33
-local preprocessor option, esqlc, 1-53, 14-6, 1-65, 1-57
local variable,
defined, sqlt, 14-15
Local variable, sqlr, Glossary-11
Locale, sqlr, Intro-5, sqls, Intro-6, esqlc, Intro-4, sqlt, 1-17, Intro-6, gls_api, 1-11, dapi, Intro-5, extend, Intro-4, udr, Intro-4
alpha class, gls, 3-8
character classes, gls_api, 2-10
choosing, gls_api, 1-9
client, gls_api, 1-10, 1-11
code set. See Code set.,
COLLATION category. See COLLATION locale category.,
CTYPE category. See CTYPE locale category.,
current, gls_api, 2-24
database, gls_api, 1-10, 1-11
default, gls_api, 1-11
default. See Default locale.,
definition of, gls_api, 1-9, gls, 1-18, 1-4, 1-7
determining maximum character size, gls_api, 2-40
effect on collation, gls_api, 4-200, 4-148
effect on date-string conversion, gls_api, 4-22
effect on date-string formatting, gls_api, 4-59
effect on date/time-string conversion, gls_api, 4-33
effect on date/time-string formatting, gls_api, 4-69
effect on money-string conversion, gls_api, 4-38
effect on money-string formatting, gls_api, 4-76
effect on number-string conversion, gls_api, 4-44
effect on number-string formatting, gls_api, 4-81
environment variables, gls, 1-28
filename, gls, A-9, A-12
for code-set conversion, gls, 1-40
for database server connections, gls, 1-31
identifying. See Locale name.,
initializing, gls_api, 4-86
International Language Supplement, gls, 1-7
LC_COLLATE category, gls_api, 2-34
LC_CTYPE category, gls_api, 2-11
LC_MONETARY category, gls_api, 3-5
LC_NUMERIC category, gls_api, 3-4
LC_TIME category, gls_api, 3-7
listing, gls, 1-21, A-21
locale categories, gls, A-4
locale names, gls, 1-20
localized collation order, gls_api, 2-34
maximum number of bytes in characters, gls_api, 4-139
MESSAGES category. See MESSAGES locale category.,
MONETARY category. See MONETARY locale category.,
name of, gls_api, 4-50, 4-51, 4-46, 4-13, 2-24
name. See Locale name.,
non-ASCII characters, gls, 1-30
NUMERIC category. See NUMERIC locale category.,
operating-system, gls, A-24
operating-system compatible, gls, A-11
sample, gls, 1-30
See also Client locale; Database locale; Server locale.,
server, gls_api, 1-10, 1-11
server-processing, gls_api, 1-19
setting, gls, 1-28, 1-18
setting for tracing, dbdkug, 5-17
SQL scripts, dbdkug, 3-52
subdirectory for files, gls_api, 1-23, 1-14
TIME category. See TIME locale category.,
U.S. English. See Default locale.,
uses of, gls, 1-30
verifying, gls, 1-38, 1-33
white space, gls_api, Intro-11, gls, Intro-14
Locale category. See Locale, locale categories.,
Locale file,
description of, gls, A-3, 1-21
listing, gls, 1-21, A-21, A-22
location of, gls, A-9, 1-21
object, gls, A-20, A-11
operating-system compatible, gls, A-11
removing unused, gls, A-20
required, gls, A-20
source, gls, A-20, A-11
Locale modifier, gls, 1-20, 1-21, 1-33, A-12
Locale name,
assigning, gls, 1-28
code-set name, gls, 1-30, 1-20, 1-21, 1-33
description of, gls, 1-20
language name, gls, 1-20, A-10, 1-33
locale modifier name, gls, 1-20, 1-21, 1-33, A-12
sample, gls, 1-21
syntax, gls, 1-20
territory name, gls, 1-20, A-10, 1-33
Locales, for errors, overview, 1-26
Localization, gls_api, 1-9
Localized collation order, gls_api, 4-199, 4-147, 2-34
Localized collation order. See Collation order, localized.,
Locating a simple large object,
in a client-server environment, esqlc, 8-10
in a named file, esqlc, 16-33, 16-34, 8-26
in an open file, esqlc, 8-21
in memory, esqlc, 16-55, 8-11
locations for, esqlc, 8-10
on optical disc, esqlc, 8-40
with user-defined functions, esqlc, 8-31
Locator structure, gls, 8-13
definition of, esqlc, 8-5, 8-6
fields of, esqlc, 8-8
lc_union structure, esqlc, 8-32, 8-11, 8-19, 8-8
loc_buffer field, esqlc, 8-11, 8-13
loc_bufsize field, esqlc, 16-55, 8-11, 8-12, 8-13
loc_close field, esqlc, 8-32, 8-33, 8-34, 8-39
loc_currdata_p field, esqlc, 8-11
loc_fd field, esqlc, 8-21, 8-25, 8-19
loc_fname field, esqlc, 8-26, 8-19
loc_indicator field, esqlc, 8-9, 8-14
loc_loctype field. See loc_t.loc_loctype field.,
loc_mflags field, esqlc, 8-11, 8-12
loc_mode field, esqlc, 8-19
loc_oflags field. See loc_t.loc_oflags field.,
loc_open field, esqlc, 8-31, 8-20, 8-33, 8-34, 8-35
loc_position field, esqlc, 8-20, 8-19
loc_read field, esqlc, 8-31, 8-34, 8-36
loc_size field. See loc_t.loc_size field.,
loc_status field, esqlc, 8-9, 8-20, 8-13, 8-26
loc_type field, esqlc, 8-9
loc_user_env field, esqlc, 8-32
loc_write field, esqlc, 8-31, 8-33, 8-37
loc_xfercount field, esqlc, 8-32
memory buffer, esqlc, 8-12
See also loc_t data type.,
locator.h header file, dapi, 1-6
access-mode constants, esqlc, 7-23
create-time constants, esqlc, 7-10
data types defined, esqlc, 2-11, 2-12, 2-13, 8-7
definition of, esqlc, 1-23
description of, esqlc, 7-7
field name shortcuts, esqlc, 8-20, 8-11
file-location constants, esqlc, 7-41, 7-44
file-open mode flags, esqlc, 8-20
LO-pointer structure, esqlc, 7-18
LO-specification structure, esqlc, 7-8
LO-status structure, esqlc, 7-30
LOC_ALLOC constant, esqlc, 8-13
location constants, esqlc, 8-10
whence constants, esqlc, 7-62, 7-99, 7-58
LOCFILE location constant, esqlc, 8-21, 8-10
LOCFNAME location constant, esqlc, 8-10, 8-26
Lock, sqlr, Glossary-12
database, sqlt, 7-8
exclusive, sqls, 1-239, sqlt, 7-10, 7-7, dapi, 12-263, 3-70, 3-68
granularity, sqlt, 7-7
key, sqlt, 7-9
page, sqls, 1-254, sqlt, 7-9
promotable, sqls, 1-312, sqlt, 7-10, 7-7
row, sqls, 1-254, sqlt, 7-9
scope of, sqlt, 7-7
setting with SET LOCK MODE, sqls, 1-728
share mode, dapi, 3-68
share-mode, dapi, 3-70
shared lock, sqlt, 7-7
table,
changing mode, sqls, 1-88
creating with ALTER INDEX, sqls, 1-53
explicit, sqlt, 7-9
implicit, sqlt, 7-8
LOCK TABLE statement, sqls, 1-525
unlocking, sqls, 1-777
update, sqls, 1-783
update mode, dapi, 3-70, 3-68
Lock mode, sqlr, Glossary-12
altering with ALTER TABLE, sqls, 1-88
setting, sqlt, 7-9
LOCK TABLE statement, sqlt, 7-9
reversing with UNLOCK TABLE, sqls, 1-777
with transactions, sqls, 1-526
without transactions, sqls, 1-527
Locking, sqlr, Glossary-12
and concurrency, sqlt, 4-32
and integrity, sqlt, 7-3
cursors, effect on, sqls, 1-312
deadlock, sqlt, 7-19
default table locking, sqls, 1-254
DELETE statement with, sqlt, 6-4
description of, sqlt, 7-6
during,
delete, sqls, 1-328
updates, sqls, 1-783
FETCH statement and, sqls, 1-421
lock duration, sqlt, 7-10
lock mode, sqlt, 7-18
not wait, sqlt, 7-18
wait, sqlt, 7-18
locks released at end of transaction, sqlt, 7-23
modifying data with, sqlt, 7-10
overriding row-level, sqls, 1-526
releasing with COMMIT WORK, sqls, 1-99
releasing with ROLLBACK WORK, sqls, 1-594
SET ISOLATION with, sqls, 1-722
setting lock mode, sqlt, 7-18
smart large objects, dapi, 3-68
transactions with, sqls, 1-91
types of locks,
database lock, sqlt, 7-8
waiting period, sqls, 1-729
Locking granularity, sqlr, Glossary-12
Locks, on smart large objects, esqlc, 7-26
LOCMEMORY location constant, esqlc, 8-10, 16-55, 8-11
LOCOPY function, sqlr, 2-38, 2-33, sqls, 1-930
LOCUSER location constant, esqlc, 8-31, 8-10
Log file, gls, 1-27, 4-3, 5-3, 6-3
Log filename, non-ASCII characters in, gls, 4-4, 5-4
Log files,
defined, bldmg_ug, 2-12, 3-14
verifying registration with from the command line, bldmg_ug, 3-10
verifying registration with from the GUI, bldmg_ug, 2-7
verifying unregistration with from the command line, bldmg_ug, 3-12
verifying unregistration with from the GUI, bldmg_ug, 2-9
verifying upgrades with from the command line, bldmg_ug, 3-11
verifying upgrades with from the GUI, bldmg_ug, 2-9
log preprocessor option, esqlc, 1-65
-log preprocessor option, esqlc, 1-53, 1-58
log() built-in function, extend, 2-8
LOG10 function, sqls, 1-919
Logarithmic functions, sqls, 1-918
Logging,
ANSI-compliant database with, sqls, 1-119
buffered, sqlt, 9-40
buffered versus unbuffered, sqls, 1-731
buffered,
changing to with SET BUFFERED LOG, sqls, 1-731
setting with CREATE DATABASE, sqls, 1-119
cascading deletes, sqls, 1-240
database creation, sqls, 1-119
types of, sqlt, 9-39
unbuffered, sqlt, 9-39
unbuffered,
changing to with SET LOG, sqls, 1-731
with triggers, sqls, 1-285
Logging behavior (smart large object),
altering, dapi, 3-73
description of, dapi, 3-11
setting, dapi, 3-42
system-specified storage characteristics, dapi, 3-43
Logging, generated file property, dbdkug, 3-50
Logical log, sqlt, 4-31
Logical operator,
AND, sqls, 1-853
condition with, sqls, 1-853
NOT, sqls, 1-837
OR, sqls, 1-853
unknown values, sqls, 1-854, 1-837
login.h header file, esqlc, 1-105, 12-14, 1-25
LOGN function, sqls, 1-919
logn() built-in function, extend, 2-8
Logs page, bldmg_ug, 2-12
LOhandles function, dbdkug, 5-31
Lohandles support function, sqls, 1-173
lohandles() support function, dapi, 12-365, 12-299
description of, extend, 5-6
summary of, extend, 6-5
.lok extension, sqls, 1-729
.lok file extension, sqls, 1-729
long int data type,
converting from decimal, esqlc, 4-50
converting from int8, esqlc, 5-29
converting to decimal, esqlc, 4-23
converting to int8, esqlc, 5-20
converting to text, esqlc, 5-44
corresponding SQL data type, esqlc, 5-4, 2-12
data conversion, esqlc, 2-20
defined constant, esqlc, 2-10
See also INTEGER data type; int data type.,
longjmp() system call, esqlc, 12-64, 12-36
Loop,
exiting with RAISE exception, sqlt, 14-88
indefinite with WHILE, sqls, 2-61
Lossy error, gls, 1-42
LOTOFILE function, sqlr, 2-38, 2-33, sqls, 1-928
Lower class, gls_api, 4-101, 4-125, 2-11, 2-13
Lowercase character,
converting from uppercase, gls_api, 4-185, 4-191, 2-15
converting to uppercase, gls_api, 4-188, 4-193, 2-15
description of, gls_api, 2-11
testing for, gls_api, 4-101, 4-125, 2-13
LVARCHAR, sqlr, Glossary-12
lvarchar data type,
checking for null, esqlc, 10-14
corresponding SQL data type, esqlc, 2-5, 2-12, 2-13
CREATE OPAQUE TYPE statement, esqlc, 10-6
declaration, esqlc, 10-7
declaring, esqlc, 3-9
defined constant, esqlc, 2-11
definition of, esqlc, 3-4, 3-9
description of, esqlc, 3-9
fetching from column, esqlc, 3-17
fetching into, esqlc, 10-14
inserting from, esqlc, 3-18
inserting from, fixed size, esqlc, 10-12
inserting to column, esqlc, 3-17
of a fixed size, esqlc, 3-10
of fixed size, esqlc, 10-9
opaque type name, esqlc, 10-11
pointer host variable, esqlc, 3-10, 10-9
allocating memory, esqlc, 10-10
and ifx_var() functions, esqlc, 10-11
functions for, esqlc, 10-32
ifx_var_alloc() function, esqlc, 10-33
ifx_var_dealloc() function, esqlc, 10-35
ifx_var_flag() function, esqlc, 10-37
ifx_var_getdata() function, esqlc, 10-39
ifx_var_getlen() function, esqlc, 10-40
ifx_var_isnull() function, esqlc, 10-41
ifx_var_setdata() function, esqlc, 10-42
ifx_var_setlen() function, esqlc, 10-44
ifx_var_setnull() function, esqlc, 10-46
inserting from, esqlc, 10-15
selecting into, esqlc, 10-16
using, esqlc, 10-14
See also LVARCHAR data type.,
selecting into, fixed size, esqlc, 10-14
setting to null, esqlc, 10-13
truncation, fixed size, esqlc, 3-10
using, esqlc, 10-11
with ANSI-compliant database, esqlc, 3-18
with DESCRIBE statement, esqlc, 16-7
LVARCHAR data type, sqls, 1-862, 1-863, sqlt, 9-22, dbdkug, 2-7
casting from, extend, 5-17
casting to, extend, 5-17
code-set conversion, gls, 4-7
corresponding ESQL/C data type, esqlc, 2-5, 2-12
defined constant, esqlc, 2-9
definition of, extend, 6-6
distinct-bit constant, esqlc, 15-32
distinct-bit macro, esqlc, 15-32
greater than condition, sqls, 1-1020
in INSERT, sqls, 1-502
locale-sensitive data, extend, 6-24
parameter to input function, extend, 5-16
return value of output function, extend, 5-16
See also lvarchar data type.,
See Character; Character string.,
-lw preprocessor option, esqlc, 1-58


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