of, sqlr, 2-39
collation, sqlr, 2-39
coltype code for, sqlr, 1-26
copying to a file, sqls, 1-928
copying to a smart large object, sqls, 1-930
creating from a file, sqls, 1-926
definition of, sqlr, Glossary-3
displaying values, sqlt, 2-10
handle values, sqls, 1-890
inserting data, sqlr, 2-39
restrictions,
with GROUP BY, sqlt, 3-6
See also Smart large object.,
SQL restrictions, sqlt, 9-26
syntax, sqls, 1-869
unloading, sqls, 1-771, 1-773
CLOSE DATABASE statement, sqls, 1-97
effect on database locks, sqlt, 7-8
prerequisite actions, sqls, 1-97
CLOSE statement, sqls, 1-93
collection cursor, sqls, 1-95
function cursor, sqls, 1-94
insert cursor, sqls, 1-94
select cursor, sqls, 1-94
Closing worlds, vis_ug, 12-6
Cluster graphs,
description of, vis_ug, 5-6
properties of, vis_ug, A-17
Cluster index, sqlr, Glossary-3
Cluster key, sqlr, Glossary-3
Cluster size, sqlr, Glossary-3
COBOL, sqlt, 5-6
Codd, E. F., sqlt, 8-35, 1-10
Collating sequence. See Collation order.,
Collation,
with CLOB data type, sqlr, 2-39
Collation order, sqlr, Glossary-3
ascending and descending, sqlt, 2-13
NCHAR data type, sqlr, 1-12
non-English data, sqlt, 2-24
See alsoGlobal Language Support (GLS); Guide to GLS Functionality,
with relational operators, sqls, 1-1021
COLLCHAR environment variable, instll32, 25
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
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 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 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
FOREACH statement, sqls, 1-833
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 (:), delimiter in INTERVAL, sqlr, 2-50
Colon. See:, colon; :: , cast operator.,
Color,
functions, vis_ug, 7-14
modifying, vis_ug, 5-20, 7-15
property expression to specify, vis_ug, 7-13
resources, vis_ug, 11-3
Color sequences,
as resources, vis_ug, 1-6
default for, vis_ug, 11-4
description of, vis_ug, 11-3
using, vis_ug, 7-15
Color, setting INFORMIXTERM for, sqlr, 3-52
Colormaps,
as resources, vis_ug, 1-6
description of, vis_ug, 11-3
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 charts,
description of, vis_ug, 5-5
properties of, vis_ug, A-19
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,
aliasing, vis_ug, 3-14
choosing in queries, vis_ug, 3-10
in property expressions, vis_ug, 7-12
mapping object properties to, vis_ug, 7-15 to , 7-9
specifying in parameters, vis_ug, 11-13
typing names in Object Inspector, vis_ug, 7-18
columns Information Schema view, sqlr, 1-68
Command actions, vis_ug, 9-4
Command script file,
comment symbols in, sqls, 1-12
creating database, sqlt, 9-42
defined, sqls, 1-12
Command-line conventions,
elements of, sqlr, Intro-11
example diagram, sqlr, Intro-12
how to read, sqlr, Intro-12
Comment icons, vis_ug, Intro-7, sqlr, Intro-9, sqls, Intro-10, sqlt, Intro-10
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
COMMIT WORK statement,
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
Commutator function, sqlr, Glossary-4
Compare support function, sqls, 1-173
Compiler,
environment variable for C (INFORMIXC), sqlr, 3-44
Complex data type, sqlr, 2-20 to , sqlt, 10-4 to , 9-4
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; Row type.,
Complex relationship, sqlt, 8-30
Compliance,
icons, sqlr, Intro-10, sqls, Intro-12
with industry standards, sqlr, Intro-16, sqls, Intro-21
Compliance, with industry standards, sqlt, Intro-13
Composite index, sqlr, Glossary-4, sqls, 1-153
Composite key, sqlt, 8-26
Compound assignment, sqls, 2-40
Compound query, sqlt, 3-39
concat() operator function, sqls, 1-884
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
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
Configuring,
information, instll32, 6
Informix products, instll32, 17, 19
the environment, instll32, 19
Connect,
component descriptions, instll32, 11
documentation for, instll32, 2
CONNECT DEFAULT statement,
INFORMIXSERVER environment variable effect, sqlr, 3-49
Connect privilege. See Privilege, database-level.,
CONNECT statement, sqls, 1-101 to
connection context, sqls, 1-103
connection identifiers, sqls, 1-103
database environment specification, sqls, 1-106 to
DEFAULT option, sqls, 1-103
implicit connections, sqls, 1-104
switching connections, sqls, 1-105
transactions with, sqls, 1-105
USER clause, sqls, 1-109
WITH CONCURRENT TRANSACTION option, sqls, 1-105
Connecting,
data points, vis_ug, 5-23
query blocks, vis_ug, 3-29
to a database, vis_ug, 13-4, 1-20
Connecting to data,
INFORMIXCONRETRY environment variable, sqlr, 3-45
INFORMIXCONTIME environment variable, sqlr, 3-46
sqlhosts file and sqlexecd daemon, sqls, 1-109
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
setting length of attempt, instll32, 25
setting number of retries, instll32, 25
Connection points,
description of, vis_ug, 5-23
illustration of, vis_ug, 5-23
properties of, vis_ug, A-21
Connectivity in relationship, sqlt, 8-20, 8-10, 8-13
Connectors,
adding to a scene, vis_ug, 6-7
description of, vis_ug, 5-23
example of inserting, vis_ug, 5-24
illustration of, vis_ug, 6-8
in scenes, vis_ug, 6-7
list of, vis_ug, 5-23
using with static objects, vis_ug, 6-7
Connectors panel, vis_ug, 5-24, 1-12
Constant, sqlr, Glossary-5
comparisons, sqls, 1-840
inserting rows of, sqlt, 6-12
UNITS keyword with, sqls, 1-899
Constant blocks, vis_ug, 3-31
Constant expression,
inserting with PUT, sqls, 1-558
restrictions with GROUP BY, sqls, 1-631
Constraint,
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 function, sqls, 1-900
Container application, vis_ug, E-10, 14-3, 14-5, 1-22
sample source code for, vis_ug, 14-5
CONTINUE statement, sqls, 2-7
Controls panel, vis_ug, 1-12
Coordinated deletes, sqlt, 6-6
Copying objects, vis_ug, 12-7
Copying the registry hive, instll32, 24
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
Correlations, displaying, vis_ug, 5-6
COS function, sqls, 1-937, 1-938
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
CREATE CAST statement, sqls, 1-112 to
EXPLICIT keyword, sqls, 1-114
IMPLICIT keyword, sqls, 1-115
WITH clause, sqls, 1-116
CREATE DATABASE statement, sqls, 1-117, sqlt, 9-38
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
CREATE DOMAIN statement,
using, sqlt, 9-35
CREATE FUNCTION statement, sqls, 1-125 to
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
Return clause, sqls, 1-1025, 1-130
WITH LISTING IN clause, sqls, 1-132, sqlt, 14-80
CREATE INDEX statement, sqls, 1-137 to
ASC keyword, sqls, 1-145
CLUSTER keyword, sqls, 1-139
composite indexes, sqls, 1-153
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
USING clause, sqls, 1-151
CREATE OPAQUE TYPE statement, sqls, 1-167 to
ALIGNMENT modifier, sqls, 1-170
CANNOTHASH modifier, sqls, 1-170
INTERNALLENGTH modifier, sqls, 1-168
MAXLEN modifier, sqls, 1-170
Modifier clause, sqls, 1-169
PASSEDBYVALUE modifier, sqls, 1-170
VARIABLE keyword, sqls, 1-169
CREATE OPCLASS statement, sqls, 1-174 to
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
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
WITH LISTING IN clause, sqls, 1-188, sqlt, 14-80
CREATE ROLE statement, sqls, 1-193
CREATE ROUTINE FROM statement, sqls, 1-195
CREATE ROW TYPE statement,
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
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
access method option, sqls, 1-255
cascading deletes, sqls, 1-239
CHECK clause, sqls, 1-233
column definition clause, sqls, 1-222
constraint definition,
column-level, sqls, 1-230
table-level, sqls, 1-231
constraint mode definition, sqls, 1-241
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
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
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
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
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
Creating,
data sources, vis_ug, 3-7, 3-16
event actions, vis_ug, 9-4
global parameters, vis_ug, 11-3
layers, vis_ug, 5-24, 5-26
layouts, vis_ug, 5-10, 5-9
navigation, vis_ug, 8-3 to
resources, vis_ug, 11-3
storyboards, vis_ug, 2-3
wormholes, vis_ug, 8-11 to
Cross data symbols, vis_ug, 5-22
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
Cursor,
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 function, sqlr, Glossary-5, sqls, 2-28
Cursor name,
'execute', 'select', 'with' as, sqls, 1-983
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.,
cust_calls table in stores7 database, columns in, sqlr, A-6
customer table in stores7 database, sqlr, A-2
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.