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 ]

U

Opaque type; Extended data type; Cast, user-defined; CREATE TYPE; CREATE CAST; Support functions.,
U.S. English locale. See Default locale.,
UDR. See DataBlade UDR.,
UDR. See User-defined routine.,
udr.c file, dbdkug, A-1, 5-5
undef preprocessor directive, esqlc, 1-61, 1-12, 1-14
Underscore. See _, underscore.,
Unexpected errors, bldmg_ug, 2-12, 3-14
Uninstalling,
client files from the command line, bldmg_ug, 3-13
client files with the GUI, bldmg_ug, 2-11
Union method/routine, dbdkug, 7-10, 6-18
Union of structures, esqlc, 1-38, 8-8
UNION operator,
description of, sqlt, 3-39
display labels with, sqlt, 3-43
Unique,
constraint, sqlr, Glossary-21
index, sqlr, Glossary-21
Unique constraint,
modifying a column with, sqls, 1-78
naming, sqls, 1-84
rules of use, sqls, 1-232, 1-236
shared unique index, sqls, 1-83
Unique key.SeePrimary key.,
UNIQUE keyword,
constraint in CREATE TABLE, sqlt, 9-40
in CREATE INDEX, sqls, 1-139
restrictions in modifiable view, sqlt, 11-29
Unique numeric code,
with SERIAL data type, sqlr, 2-59
with SERIAL8 data type, sqlr, 2-61
Universal Server,
dynamic function manager, udr, 5-13
Universal Server smart-large-object interface, dapi, 3-17, 3-19, 2-6
UNIX,
authorization for connecting to database, sqls, 1-111
BladeManager command line interface, bldmg_ug, 3-3 to
BSD, default print capability, sqlr, 3-34
compiling on, dbdkug, 6-20, 5-38
dbx utility, dbdkug, 8-17
debugger utility, dbdkug, 8-17
default user name, bldmg_ug, 3-8
directories for intermediate writes, sqlr, 3-60
environment variables, sqlr, 3-5
installing DataBlade modules, dbdkug, 8-6, bldmg_ug, 1-4
makefiles, dbdkug, A-1, 6-20, 5-4, 5-5, 5-38
PATH environment variable, sqlr, 3-58
server projects, dbdkug, 6-20
shared object files, dbdkug, 8-4
System V,
default print capability, sqlr, 3-34
terminfo library support, sqlr, 3-52
TERM environment variable, sqlr, 3-63
TERMCAP environment variable, sqlr, 3-63
TERMINFO environment variable, sqlr, 3-64
unresolved symbols when compiling, dbdkug, 5-38
UNIX environment,
default code set, gls_api, 2-10, gls, 1-19
default locale, gls, 1-21
glfiles utility, gls, 1-21
location of message files, gls, 1-49
location of operating-system locales, gls, A-11
setting environment variables, gls, 1-28
supported code-set conversions, gls, 1-46
supported locales, gls, 1-21
UNIX.mak file, dbdkug, A-1, 5-4, 5-5, 5-38
UNKNOWN truth values, sqls, 1-854
Unload file, gls, 3-52
UNLOAD statement, gls, 3-52, 3-49
DELIMITER clause, sqls, 1-775
exporting data to a file, sqlt, 9-43
privileges, sqls, 1-770
syntax, sqls, 1-769
UNLOAD TO file, sqls, 1-770
unloading CLOB or BLOB columns, sqls, 1-773
unloading collections, sqls, 1-775
unloading row types, sqls, 1-775
unloading TEXT or BYTE columns, sqls, 1-773
unloading VARCHAR columns, sqls, 1-772
UNLOAD TO file, sqls, 1-770
UNLOCK TABLE statement, sqls, 1-777
Unnamed row data type,
updating fields, sqls, 1-803
Unnamed row data types, dbdkug, 3-41
Unnamed row type, sqlr, 2-67, sqls, 1-875, sqlt, 10-13 to
after a DESCRIBE, esqlc, 17-8
definition of, sqlr, Glossary-22
field definition, sqls, 1-876
inserting into, esqlc, 9-71
literal values, esqlc, 9-75
restrictions on, sqlt, 10-14
See also Named row type; Row type (SQL).,
unloading, sqls, 1-771, 1-775
updating, esqlc, 9-71
unregister command, bldmg_ug, 3-19
Unregistering a DataBlade module, overview, 2-6
Unregistering DataBlade modules,
BladeManager command line, using, bldmg_ug, 3-11
BladeManager GUI, using, bldmg_ug, 2-9
log file for from the command line, bldmg_ug, 3-12
log file for on the GUI, bldmg_ug, 2-9
problems with, bldmg_ug, A-3
Unresolved symbols,
in shared object files, dbdkug, 8-5
UNIX, dbdkug, 5-38
Untyped collection variable, sqlr, Glossary-22
allocating memory for, esqlc, 9-11
deallocating memory for, esqlc, 9-11
declaring, esqlc, 9-9
operating on, esqlc, 9-13
Untyped row variable,
allocating memory for, esqlc, 9-57
deallocating memory for, esqlc, 9-57
declaring, esqlc, 9-52
operating on, esqlc, 9-58
Untyped table,
converting to a typed table, sqlt, 10-9
Untyped table. SeeTable.,
Updatable view, sqls, 1-293
Update cursor, sqls, 1-794, 1-310, esqlc, 9-27, 14-15, sqlt, 7-10, 6-15
definition of, sqlt, 6-15
opening, sqls, 1-530
use in DELETE, sqls, 1-331
use in UPDATE, sqls, 1-794
with collection variable, sqls, 1-332, 1-797
Update lock. See Lock, update.,
Update privilege,
column level, sqlt, 11-10
definition of, sqlt, 11-8
with a view, sqls, 1-781
UPDATE statement, sqlt, 4-13 to
and NOT FOUND condition, esqlc, 11-21, 11-36
and transactions, sqls, 1-782
collection columns, esqlc, 9-40, 9-41
collection columns with, sqls, 1-791, 1-795
collection data, esqlc, 9-29
Collection Derived Table clause, esqlc, 9-66, 9-29
collection derived table with, sqls, 1-798, 1-833
collection variables with, sqls, 1-797, 1-798, 1-833
column restrictions, sqls, 1-313
cursor example, sqls, 1-326
cursor with, sqls, 1-794, 1-311
defined statement constant, esqlc, 15-17, 15-18
description of, sqlt, 4-13
determining estimated cost of, esqlc, 11-30
determining number of rows updated, esqlc, 11-30, 11-8
determining rowid, esqlc, 11-30
dynamic, esqlc, 14-40, 14-52, 15-26
embedded, sqlt, 6-15 to
embedded SELECT, gls, 3-50
era-based dates, gls, 3-50
failing to access rows, esqlc, 11-29
FETCH statement with, sqls, 1-421
GLS considerations, gls, 3-49
in ANSI-compliant database, esqlc, 3-18
interrupting, esqlc, 12-52, 12-34
known at compile time, esqlc, 14-40, 14-52
locking considerations, sqls, 1-783
missing WHERE signalled, sqls, 1-340
not known at compile time, esqlc, 15-26
NULL with, sqls, 1-788
number of rows, sqls, 1-450, 1-915, sqlt, 5-10
object modes with, sqls, 1-657
opaque-type columns, sqls, 1-793
parameterized, esqlc, 17-43, 14-52, 16-46, 15-27
preparing, sqlt, 5-31
privilege for, sqlt, 11-5, 11-8
privileges for See Privilege, table-level. 71,
rolling back updates, sqls, 1-782
row types, sqls, 1-789
row-type columns, esqlc, 9-74, 9-71
row-type data, esqlc, 9-66
SELECT with, sqls, 1-639
SET clause, sqls, 1-783, esqlc, 1-37, 14-52, sqlt, 4-13, 4-15, gls, 3-50
single-column SET clause, sqls, 1-784, 1-786
smart large object, dapi, 3-18, 3-73, 3-55
smart large objects with, sqls, 1-890
subquery restrictions, sqlt, 4-15
syntax, sqls, 1-780
trigger, sqls, 1-260, 1-262
updating fields of a row type, sqls, 1-789, 1-803
updating smart large-object data, esqlc, 7-17
use of expressions, sqls, 1-784
view with, sqls, 1-781, sqlt, 11-29
WHERE clause, sqls, 1-793
checking for, sqls, 1-340
WHERE clause conditions, gls, 3-50
WHERE CURRENT OF clause, sqls, 1-794, esqlc, 14-19
with DESCRIBE, esqlc, 15-23, 15-16
with,
SET keyword, sqls, 1-786
without WHERE clause, esqlc, 15-23, 11-31, 11-23, 15-18, 11-15
UPDATE STATISTICS statement, sqls, 1-806 to
disk space for (DBUPSPACE), sqlr, 3-41
distribution bins, sqls, 1-810
dropping data distributions, sqls, 1-813
index pages, sqls, 1-815
LOW distribution, sqls, 1-812
only one table in hierarchy, sqls, 1-812
optimizing search strategies, sqls, 1-809, 1-817
recommended procedure for using, sqls, 1-817
specifying distributions only, sqls, 1-815
sysdistrib results from, sqlr, 1-32
sysindices (index statistics), sqlr, 1-39
temporary tables, sqls, 1-811
update system catalog, sqlr, 1-11
when to execute, sqls, 1-810
updcd_me sample program, esqlc, 8-17
updcd_nf sample program, esqlc, 8-28
updcd_of sample program, esqlc, 8-23
Upgrading,
log file for, bldmg_ug, 3-11, 2-9
Upgrading a DataBlade module, overview, 2-6
Upgrading DataBlade modules,
BladeManager command line, using, bldmg_ug, 3-10
BladeManager GUI, using, bldmg_ug, 2-8
problems with, bldmg_ug, A-3
Upgrading the database server, sqls, 1-810
Upper class, gls_api, 4-133, 2-11, 4-109, 2-13
Uppercase character,
converting from lowercase, gls_api, 4-188, 4-193, 2-15
converting to lowercase, gls_api, 4-185, 4-191, 2-15
description of, gls_api, 2-11
testing for, gls_api, 4-133, 4-109, 2-13
USER function, sqls, 1-895, 1-844, sqlt, 2-60
ANSI compliance with, sqls, 1-895
CREATE TABLE with, sqls, 1-223
example, sqls, 1-506
examples, sqlt, 3-18
User name,
default for UNIX, bldmg_ug, 3-8
default for Windows, bldmg_ug, 3-8
setting from the command line, bldmg_ug, 3-8
USER network parameter, esqlc, 1-107, 12-14
user() built-in function, extend, 2-8
User-defined base type. See Opaque data type.,
User-defined cast,
casting between data types, sqlt, 13-16
casting function, extend, 3-9
creating, extend, 3-5
definition of, extend, 3-3
dropping, extend, 3-13
explicit. See Explicit cast.,
implicit. See Implicit cast.,
kinds of, extend, 3-6
See also Cast.,
straight, extend, 3-8
User-defined data type, sqls, 1-872, extend, 1-12
cast for, sqlt, 13-5
definition of, sqlr, Glossary-22
kinds of, sqlr, 2-20
privileges, sqls, 1-471
revoking, sqls, 1-582
privileges,
sysxtdtypeauth, sqlr, 1-63
See alsoDistinct type 71,
sysxtddesc (extended type) information, sqlr, 1-62
sysxtdtypes information about, sqlr, 1-64
User-defined data type. See Distinct data type; Opaque data type.,
User-defined function, sqls, 1-942 to , gls, 4-17
arguments, esqlc, 14-45
compared with procedure, esqlc, 14-46
creating, esqlc, 14-46
cursor, sqls, 1-401, esqlc, 14-50, 16-4, 14-48, 17-4
definition, esqlc, 14-46
determining return values dynamically, esqlc, 15-27
dropping, esqlc, 14-46
executing, esqlc, 14-46, 14-48
executing dynamically, esqlc, 14-46, 14-48
in functional index, sqls, 1-144
inserting data with, sqls, 1-509
known at compile time, esqlc, 14-46
noncursor, sqls, 1-400, esqlc, 16-12, 14-45, 16-4, 14-48, 17-4, 14-49
not known at compile time, esqlc, 15-27
parameterized, esqlc, 17-42, 14-52, 16-44, 14-54, 14-45
See also Cursor function; External function; Noncursor function; SPL function; User-defined routine.,
variant, sqls, 1-1031
with sqlda structure, esqlc, 17-26
with system-descriptor area, esqlc, 16-22
User-defined function. See User-defined routine; Function.,
User-defined procedure, gls, 4-18
arguments, esqlc, 14-45
compared with function, esqlc, 14-46
creating, esqlc, 14-46
definition, esqlc, 14-46
definition of, sqlr, Glossary-22
dropping, esqlc, 14-46
executing, esqlc, 14-46, 14-47
executing dynamically, esqlc, 14-47
parameterized, esqlc, 17-42, 14-52, 16-45, 14-45
See also External procedure; SPL procedure; User-defined routine.,
User-defined procedure . See User-defined routine; Procedure.,
User-defined routine,
arguments, sqls, 1-170
definition, esqlc, 14-46
description of, sqlr, Glossary-22
dropping with DROP ROUTINE, sqls, 1-368
error codes, sqls, 1-444
error messages, esqlc, 11-18, 11-25
error messages (syserrors), sqlr, 1-33
inserting data with, sqls, 1-508
languages supported, esqlc, 14-47
privileges,
ANSI-compliancy, sqls, 1-474
revoking, sqls, 1-583
sysprocauth, sqlr, 1-44
REFERENCES keyword with BYTE or TEXT data type, sqls, 2-18
See also User-defined function; User-defined procedure.,
See alsoRoutine; SPL routine; External routine; Function; Proc,
warning messages, esqlc, 11-22, 11-15
User-defined routine (UDR),
description of, udr, 1-3
invoking, udr, 4-3
routine overloading, description of, udr, 3-4
routine resolution, udr, 2-7
User-defined routine. See DataBlade UDR.,
User-defined routines,
argument restrictions, dbdkug, 3-26
behavior, dbdkug, 3-29
C language name, dbdkug, 3-28
code generated for, dbdkug, 5-35
cost of, dbdkug, 3-30
defining in BladeSmith, dbdkug, 3-22
described, overview, 1-23
functions declarations in C source code, dbdkug, 5-5
implemented in server or client, dbdkug, 2-11
in DataBlade module design, dbdkug, 2-14
internal, dbdkug, 3-24
iterators, dbdkug, 3-24
language for, dbdkug, 3-23
MI_FPARAM structure, using, dbdkug, 5-8
modal, dbdkug, 2-24
naming, dbdkug, 2-23, 3-26
nonvariant, dbdkug, 3-27
null value handling, dbdkug, 3-23
number of arguments, dbdkug, 2-24
optimizing with related routines, dbdkug, 3-30
OUT parameters, using, dbdkug, 3-27
overloading existing, dbdkug, 3-26
parallelizable, dbdkug, 3-28
poorly behaved, dbdkug, 4-7
properties of, dbdkug, 3-23
return type for, dbdkug, 3-23
shared object file path, dbdkug, 3-24
stack size requirement, dbdkug, 3-29
Statement Local Variables, using, dbdkug, 3-27
test data, adding for, dbdkug, 3-43
test scripts for, dbdkug, 8-10
tests for, overview, 1-26
used in SQL statements, dbdkug, 2-11
user-defined virtual processor, assigning to, dbdkug, 3-29
variant, dbdkug, 3-27
virtual processor class name, dbdkug, 3-29
yielding, dbdkug, 4-14
User-defined virtual processors,
class name, dbdkug, 3-29
creating a class for, dbdkug, 4-8
defined, dbdkug, 4-7
instances, setting number of, dbdkug, 4-9
nonyielding class, dbdkug, 4-7
noyield option, dbdkug, 4-9
routines, assigning to, dbdkug, 3-29
See also Virtual processors.,
system calls, using, dbdkug, 4-10
Using correlation names, sqls, 1-274
USING DESCRIPTOR clause,
of EXECUTE statement, esqlc, 17-41, 17-31, 17-43, 17-14, 17-4
of FETCH statement, esqlc, 17-14, 17-4
of OPEN statement, esqlc, 17-14, 17-4
of PUT statement, esqlc, 17-31, 17-14, 17-4
with a fetch array, esqlc, 15-35
USING host_var clause,
of EXECUTE statement, esqlc, 14-52
of OPEN statement, esqlc, 14-54
USING SQL DESCRIPTOR clause,
of DESCRIBE statement, esqlc, 16-14, 16-4, 16-29, 16-6
of EXECUTE statement, esqlc, 16-30, 16-11, 16-4
of FETCH statement, esqlc, 16-11, 16-14, 16-4
of OPEN statement, esqlc, 16-11, 16-4
of PUT statement, esqlc, 16-11, 16-35, 16-5
Utility,
chkenv, gls, 5-10, 4-11
database server, gls, 1-6
DB-Access, gls, 1-6
dbaccess, gls, 5-10, 4-10, 6-9
dbexport, gls, 5-10, 1-7, 4-11, 6-9
dbimport, gls, 5-10, 4-11, 6-9
dbload, gls, 5-10, 4-11, 6-9
dbschema, gls, 5-10, 4-11, 6-9
finderr, esqlc, 1-6
glfiles, gls, 1-21, A-21, 1-46
ILogin, esqlc, 1-6
INFORMIX FIND ERROR, esqlc, 1-6
INFORMIX-Universal Server utilities, gls, 4-8
onaudit, gls, 4-10, 5-9
oncheck, gls, 4-10, 5-9
OnLine utilities, gls, 5-8
onload, gls, 4-10, 5-9
onlog, gls, 4-10, 5-9
onmode, gls, 5-10, 1-7
onshowaudit, gls, 4-10, 5-9
onspaces, gls, 4-10, 5-9
onstat, gls, 4-10, 5-9
onunload, gls, 4-10, 5-9
regcopy, esqlc, 1-6
SE utilities, gls, 6-8
secheck, gls, 6-9
selog, gls, 6-9
Setnet32, esqlc, 1-6
SQL utilities, gls, 5-10, 4-11, 6-9
supporting multibyte characters, gls, 4-8, 5-8, 6-8, 6-9
Utility functions,
Gen_IsMMXMachine(), dbdkug, 5-19, 5-20
Gen_LoadLOFromFile(), dbdkug, 5-19, 5-27, 5-29
Gen_nstrwords(), dbdkug, 5-19
Gen_sscanf(), dbdkug, 5-19, 5-20, 5-23
Gen_StoreLOToFile(), dbdkug, 5-19, 5-29
Gen_Trace(), dbdkug, 5-19, 5-11
Utility program,
chkenv, sqlr, 3-10
dbload, sqlt, 9-44
dbschema, sqlt, 9-42
onload, sqlt, 4-31
onunload, sqlt, 4-31
onunload utility, sqlt, 9-44


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