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 ]

O

.o file extension, esqlc, 1-87, 1-76, gls, 8-11

-o preprocessor option, esqlc, 1-80, 1-50, 1-85, 1-76, 1-77, 1-55

.obj file extension, esqlc, 1-80, 1-81

Object Interface for C++, overview, 1-11

Object mode, sqlr, Glossary-13

adding objects examples, sqls, 1-665

benefits of, sqls, 1-670 to

data manipulation statements (INSERT, UPDATE, DELETE) with, sqls, 1-657

disabled, sqls, 1-658

duplicate index, sqls, 1-655

enabled, sqls, 1-657

benefits of, sqls, 1-671

examples, sqls, 1-659

filtering, sqls, 1-658

benefits of, sqls, 1-671

error options in SET, sqls, 1-652

privileges required for changing, sqls, 1-649

See also Trigger; Constraint; Index;SET statement,

setting with SET, sqls, 1-648

sysobjstate information, sqlr, 1-40

terminology, sqls, 1-648

trigger, sqls, 1-286, 1-655

Object persistence, dbdkug, 6-5, 7-5

Object prefix, dbdkug, 1-11

Object See database object.,

Object-relational database, sqlr, Glossary-13

Object-relational database, description of, sqlt, 1-10

Object-relational model,

description of, sqlt, 1-10

objects.sql generated script, dbdkug, 3-52

OCTET_LENGTH function, sqls, 1-921, gls, 3-43

octet_length() built-in function, extend, 2-8

ON EXCEPTION statement,

placement of, sqls, 2-45

scope of control, sqlt, 14-85

SET LOCK MODE with, sqls, 1-984

SET statement with, sqls, 1-984

syntax, sqls, 2-43

trapping errors, sqlt, 14-84

user-generated errors, sqlt, 14-87

ON keyword,

in CREATE INDEX, sqls, 1-139

ON-Archive configuration file (ARC_DEFAULT), sqlr, 3-16

On-line help, udr, Intro-9, bldmg_ug, Intro-10

BladePack, dbdkug, 10-5

BladeSmith, dbdkug, 3-56

On-line manuals, sqlr, Intro-14, sqls, Intro-19, esqlc, Intro-13, sqlt, Intro-11, dapi, Intro-8, gls, Intro-15, extend, Intro-9, udr, Intro-8

onaudit utility, gls, 4-10, 5-9

oncheck utility, gls, 4-10, 5-9

ONCONFIG environment variable, sqlr, 3-56, dbdkug, 8-4

ONCONFIG parameter,

DBSPACETEMP, sqls, 1-643

One-to-many relationship, sqlt, 8-10, 8-13

One-to-one relationship, sqlt, 8-10, 8-13

oninit server process, dbdkug, 9-11

OnLine database server. See INFORMIX-OnLine Dynamic Server.,

onload utility, sqlt, 4-31, gls, 4-10, 5-9

onlog utility, gls, 4-10, 5-9

onlycp preprocessor option, esqlc, 1-50

onmode utility, gls, 5-10, 1-7

onshowaudit utility, gls, 4-10, 5-9

onspaces database utility, esqlc, 7-13, dapi, 3-42

onspaces utility, gls, 4-10, 5-9

onstat utility, gls, 4-10, 5-9

onunload utility, sqlt, 9-44, 4-31, gls, 4-10, 5-9

Opaque data type, sqlr, 2-58, sqls, 1-873, sqlt, 9-4, gls, 4-17

after a DESCRIBE, esqlc, 17-8

alignment of, sqls, 1-170

as argument, sqls, 1-170

as element type of collection, esqlc, 9-6

as field type of row, esqlc, 9-50

as parameter, extend, 5-13

bit-hashable, extend, 6-23, 5-23, 5-24

cast for, sqlt, 13-5

casts for, extend, 3-4

comparing, extend, 6-22, 5-22

constraints on, extend, 5-23

contents of, dapi, 3-16

corresponding ESQL/C data type, esqlc, 2-5, 2-13

creating with CREATE OPAQUE TYPE, sqls, 1-167

defined constant, esqlc, 2-9

definition of, esqlc, 10-3, dapi, 3-16, extend, 5-3, 1-13

DESCRIBE with, sqls, 1-438

description of, sqlr, Glossary-13

dropping, extend, 5-28

dropping with DROP TYPE, sqls, 1-381

dynamically executing, esqlc, 15-28

extended identifier, sqls, 1-711, 1-438, esqlc, 15-13, 15-9, extend, 5-15

fetching, dapi, 3-17

fixed length, sqls, 1-169

fixed-length, sqls, 1-169, extend, 5-10, 5-4

GET DESCRIPTOR with, sqls, 1-438

in DELETE, sqls, 1-329

in DROP TABLE, sqls, 1-377

in dynamic SQL, sqls, 1-711, esqlc, 15-13

in INSERT, sqls, 1-503

in LOAD, sqls, 1-522

in sysxtdtypeauth table, extend, 5-19

in UPDATE, sqls, 1-793

indexes on, extend, 5-25

inserting, esqlc, 15-29, dapi, 3-18

internal structure, extend, 5-4

loading, sqls, 1-522, 1-518

locale-specific data, extend, 6-23

memory alignment of, extend, 5-11

modifiers, sqls, 1-169

name of, sqls, 1-711, 1-438, esqlc, 15-14, 15-9

naming, sqls, 1-168

owner name, sqls, 1-711, 1-439

owner of, esqlc, 15-14, 15-9

pass by reference, extend, 6-7, 6-9

pass by value, extend, 6-7, 6-9

predefined, esqlc, 10-48

privileges, sqls, 1-168, extend, 5-28, 5-18

registering, extend, 5-14

row field literal, sqls, 1-1008

See also Fixed-length opaque data type; Varying-length opaque data type.,

sizing, sqls, 1-168

smart large object in, dapi, 3-16

smart large objects in, dapi, 12-251, 12-231

smart large objects with, sqlr, 2-17

storage of, sqlr, 2-53

structure size, extend, 5-10

support functions, sqls, 1-171

syscolumns coltype code for, sqlr, 1-24

system catalog table, extend, 5-19

sysxtddesc contents for, sqlr, 1-62

truncation of data, esqlc, 15-31

unloading, sqls, 1-772

updating, dapi, 3-18

varying length, sqls, 1-169

varying-length, sqls, 1-169, extend, 5-11

with SET DESCRIPTOR, sqls, 1-711

Opaque data types, dbdkug, 2-6

accessor methods, dbdkug, 6-10, 3-34

ActiveX value objects, implemented as, overview, 1-27

client implementation language, dbdkug, 3-34

creating in BladeSmith, dbdkug, 3-33, 6-9

defined, overview, 1-15

defining for ActiveX, dbdkug, 6-9

example of, overview, B-2, B-4, B-9

external representation of, dbdkug, 5-22

fixed size, dbdkug, 6-8, 3-36

illustrated, overview, 1-16

internal structure of, dbdkug, 6-10, 6-8, 3-36

maximum allocated length, dbdkug, 3-37

members, dbdkug, 6-10, 3-36

memory alignment, dbdkug, 3-37

name, dbdkug, 3-34

properties, dbdkug, 3-34

rich media data, using for, overview, 1-17

routines for ActiveX custom methods, dbdkug, 6-8

rules for ActiveX use, dbdkug, 6-8

server implementation language, dbdkug, 6-5, 3-34

support functions for, overview, 1-26, 1-23

support routines for, dbdkug, 6-10, 5-21, 6-17, 3-38

test data, adding for, dbdkug, 3-43

test scripts for, dbdkug, 8-10

variable size, dbdkug, 3-36

Opaque type,

cast matrix, sqlr, 2-32

Opaque variable,

inserting, sqls, 1-503

Opaque-type support function,

assign(), dapi, 12-294, 12-231, 3-81, 12-267, 12-227

destroy(), dapi, 3-81, 12-277, 12-224

export, dapi, 12-251

import, dapi, 12-267

lohandles(), dapi, 12-365, 12-299

Opclass. SeeOperator class.,

OPEN statement, sqls, 1-528 to

activating a cursor, sqlt, 5-21

and deferred PREPARE, esqlc, 14-34

collection cursor, sqls, 1-533

constructing the active set, sqls, 1-530

cursors for data manipulation, sqls, 1-530

Deferred-PREPARE feature with, sqls, 1-698

executing a cursor, esqlc, 14-15, 14-18

executing with PREPARE, esqlc, 14-30

FREE statement with, sqls, 1-538

function cursor, sqls, 1-531

insert cursor, sqls, 1-532

interrupting, esqlc, 12-34

opening select or update cursors, sqlt, 5-21

optimizing, esqlc, 14-35

reopening a cursor, sqls, 1-684, 1-532, 1-537

role in dynamic SQL, esqlc, 14-10

substituting values for ? parameters, sqls, 1-533

USING clause, sqls, 1-534

USING DESCRIPTOR clause, sqls, 1-535, esqlc, 17-42, 17-34, 17-14, 17-4

USING host_var clause, esqlc, 14-54

USING SQL DESCRIPTOR clause, esqlc, 16-44, 16-11, 16-37, 16-4

with a SELECT statement, esqlc, 14-15

with an EXECUTE FUNCTION statement, esqlc, 17-28, 16-28, 14-15

with an INSERT statement, esqlc, 14-18

with deferred PREPARE, esqlc, 14-30

with OPTOFC and Deferred PREPARE features, esqlc, 14-38

WITH REOPTIMIZATION clause, sqls, 1-536

open() system call, esqlc, 8-19

OPEN, FETCH, and CLOSE (OPTOFC) feature,

restrictions, esqlc, 14-36

Operating system,

8-bit clean, gls, 4-5, 6-4, 5-5, 7-5, 2-24

character encoding, gls, 1-43

compatible locale files, gls, A-11

limitations, gls, 7-4

locales, gls, A-24

need for code-set conversion, gls, 1-43

saving disk space, gls, A-20

Operating system signals, dbdkug, 4-13

operating-system file access, dapi, 11-7

Operation,

aggregate function, extend, 2-10

built-in function, extend, 2-8

casting function. See Cast.,

definition of, extend, 2-4, 1-9

end-user routine, extend, 2-10

extending for existing data types, extend, 2-11, 1-11

extending for new data types, extend, 1-16

operator, extend, 2-4

operator function, extend, 2-4

Operator, sqlr, Glossary-13

arithmetic, extend, 2-5

binding, sqlr, Glossary-13

definition of, extend, 2-4, 1-9

function, sqlr, Glossary-13

relational, extend, 2-6

See Arithmetic operator; Cast operator; Logical operator; Relational operator.,

text, extend, 2-6

Operator binding, extend, 2-4

Operator class, gls, 4-18, dbdkug, 2-20

btree_ops, sqls, 1-179

creating with CREATE OPCLASS, sqls, 1-174

default, sqls, 1-179

default for B-Tree, sqls, 1-179

definition, sqlr, Glossary-13, sqls, 1-175, 1-145, udr, 1-8

definition of, extend, 4-3, 4-6, 1-9

dropping, extend, 4-27

dropping with DROP OPCLASS, sqls, 1-360

extending for existing data types, extend, 1-11

extending for new data types, extend, 1-17

privileges on, extend, 4-19

rtree_ops, sqls, 1-179

specifying with CREATE INDEX, sqls, 1-142, 1-145

sysopclasses information, sqlr, 1-42

Operator class support functions, documentation of, overview, A-7

Operator function,

arithmetic, extend, 5-20

concat(), sqls, 1-884

definition of, extend, 2-4, 1-9

divide(), sqls, 1-959

equal(), sqls, 1-1020

for an opaque data type, extend, 5-20

for an opaque type, extend, 5-7

greaterthan(), sqls, 1-1020

greaterthanorequal(), sqls, 1-1020

lessthan(), sqls, 1-1020

lessthanorequal(), sqls, 1-1020

like(), sqls, 1-847

matches(), sqls, 1-848

minus(), sqls, 1-959

negate(), sqls, 1-960

notequal(), sqls, 1-1020

plus(), sqls, 1-959

positive(), sqls, 1-960

relational, extend, 2-6, 5-23

text, extend, 5-20, 2-6

times(), sqls, 1-959

Operator functions, overview, 1-22

OPTCOMPIND environment variable, values, sqlr, 3-57

Optimized message transfers,

enabling, esqlc, 12-43

error handling, esqlc, 12-45

reasons to disable, esqlc, 12-44

restrictions on, esqlc, 12-42

Optimized Message Transfers, esqlc, 12-42

Optimizer,

specifying a high or low level with SET OPTIMIZATION, sqls, 1-733

strategy functions, sqls, 1-176

with UPDATE STATISTICS, sqls, 1-809, 1-817

Optimizing,

a query, sqls, 1-714

across a network, sqls, 1-734

cursor with Deferred-PREPARE feature, sqls, 1-698

cursor with SET AUTOFREE, sqls, 1-676

database server, sqls, 1-733

OPEN, FETCH, and CLOSE statements, esqlc, 14-35

Optimizing user-defined routines, dbdkug, 3-30

Optimizing. See Performance.,

Optional entity in relationship, sqlt, 8-10

OPTIONS network parameter, esqlc, 1-108

OPTMSG environment variable, esqlc, 12-43

setting, esqlc, 12-43

OptMsg global variable, esqlc, 12-43

setting, esqlc, 12-44

OPTOFC environment variable, esqlc, 14-37

client only, esqlc, 14-37

OPTOFC feature,

and static cursors, esqlc, 14-36

enabling, esqlc, 14-37

with AUTOFREE and Deferred PREPARE features, esqlc, 14-39

with Deferred PREPARE feature, esqlc, 14-38

OR logical operator, sqls, 1-853, sqlt, 2-32

ORDER BY clause (SELECT), gls, 3-21, 1-9

ORDER BY keywords,

indexes on ORDER BY columns, sqls, 1-147

relation to GROUP BY, sqlt, 3-7

restrictions with FOR UPDATE, sqlt, 6-8

orders table in stores7 database, columns in, sqlr, A-3

Orthogonality, dbdkug, 2-22

OUT parameter, dbdkug, 3-27, udr, 3-14

reading values of, udr, 3-16

Outer join, forming, sqls, 1-612

OUTPUT statement, sqls, 1-539

PIPE with, sqls, 1-540

Output support function, sqlr, 2-53, sqls, 1-171

as casting function, extend, 3-10, 3-12, 5-17

description of, extend, 5-5, 6-8

locale-sensitive data, extend, 6-24

parameter type, extend, 5-16

return type, extend, 5-16

summary of, extend, 6-3

Overlap method/routine, dbdkug, 7-10, 6-18

Overloading,

aggregates, dbdkug, 3-15

user-defined routines, dbdkug, 3-26

Overloading routines,

about, overview, 1-22

documentation of, overview, A-8

Owner,

ANSI-compliancy, sqls, 1-475, 1-1050

function name qualifier, sqls, 1-964

in Constraint Name segment, sqls, 1-855

in CREATE SYNONYM, sqls, 1-207

in RENAME COLUMN, sqls, 1-569

in RENAME TABLE, sqls, 1-572

index name qualifier, sqls, 1-985

procedure name qualifier, sqls, 1-1009

table-name qualifier, sqls, 1-1050

view name with, sqls, 1-1053

Owner name, gls, 3-8

Ownership, sqlt, 11-7

SET statement,

See also Object mode,