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.,

Underscore. See _, underscore.,

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

UNIX,

authorization for connecting to database, sqls, 1-111

BSD, default print capability, sqlr, 3-34

directories for intermediate writes, sqlr, 3-60

environment variables, sqlr, 3-5

PATH environment variable, sqlr, 3-58

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

UNKNOWN truth values, sqls, 1-854

UNLOAD statement,

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 type, sqlr, 2-67, sqls, 1-875, sqlt, 10-13 to

definition of, sqlr, Glossary-22

field definition, sqls, 1-876

restrictions on, sqlt, 10-14

unloading, sqls, 1-771, 1-775

Untyped collection variable, sqlr, Glossary-22

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, 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 transactions, sqls, 1-782

collection columns with, sqls, 1-791, 1-795

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

description of, sqlt, 4-13

embedded, sqlt, 6-15 to

FETCH statement with, sqls, 1-421

locking considerations, sqls, 1-783

missing WHERE signalled, sqls, 1-340

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

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

SELECT with, sqls, 1-639

SET clause, sqls, 1-783, sqlt, 4-13, 4-15

single-column SET clause, sqls, 1-784, 1-786

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

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 CURRENT OF clause, sqls, 1-794

with,

SET keyword, sqls, 1-786

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

Upgrading the database server, sqls, 1-810

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-defined base type. See Opaque data type.,

User-defined cast,

casting between data types, sqlt, 13-16

User-defined data type, sqls, 1-872

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 function, sqls, 1-942 to

cursor, sqls, 1-401

in functional index, sqls, 1-144

inserting data with, sqls, 1-509

noncursor, sqls, 1-400

variant, sqls, 1-1031

User-defined function. See User-defined routine; Function.,

User-defined functions, vis_ug, C-16

User-defined procedure,

definition of, sqlr, Glossary-22

User-defined procedure . See User-defined routine; Procedure.,

User-defined routine,

arguments, sqls, 1-170

description of, sqlr, Glossary-22

dropping with DROP ROUTINE, sqls, 1-368

error codes, sqls, 1-444

error messages (syserrors), sqlr, 1-33

inserting data with, sqls, 1-508

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 alsoRoutine; SPL routine; External routine; Function; Proc,

Using correlation names, sqls, 1-274

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