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

Object behavior,

See also Event actions.,

viewing, vis_ug, 5-9

Object hierarchy, vis_ug, 7-3

example of, vis_ug, 7-5

illustration of, vis_ug, 7-4

levels of detail in, vis_ug, 7-8

viewing, vis_ug, 7-3

Object Inspector, vis_ug, 1-18

and creating layouts, vis_ug, 5-9

description of, vis_ug, 1-7

docking option of the, vis_ug, 7-10

Events page, vis_ug, 9-8, 1-18, 9-5

illustration of, vis_ug, 1-19, 7-11

list box of objects in, vis_ug, 7-9

modifying objects in, vis_ug, 7-8

Properties page, vis_ug, 1-18

query parameters in, vis_ug, 3-42

selecting objects in, vis_ug, 5-16

tabbed pages of, vis_ug, 7-8

using the Scene Editor with, vis_ug, 7-20

viewing, vis_ug, 7-10

Object Interface for C++, instll32, 10

Object Interface for Java, instll32, 10

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

formatting values in, vis_ug, 7-12

mapping columns or parameters to, vis_ug, 7-15 to

modifying, vis_ug, 7-10, 7-12

of query parameters, vis_ug, 3-42

property cells for, vis_ug, 7-9

required data types for, vis_ug, 7-13

specifying dynamic values for, vis_ug, 7-15

specifying global parameters in, vis_ug, 11-9

using columns to define, vis_ug, 7-12

using operators to write expressions for, vis_ug, 7-12

using property functions to modify, vis_ug, 7-14

using resources to modify, vis_ug, 11-5

using StockImage( ) function to modify, vis_ug, 11-7

viewing, vis_ug, 7-10, 5-9

viewing results of changes to, vis_ug, 7-12

writing expressions to modify, vis_ug, 7-12

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,

and Visionary building blocks, vis_ug, 1-4

copying, vis_ug, 12-7

deleting, vis_ug, 12-7

dragging, vis_ug, 12-7

finding, vis_ug, 7-10, 7-3, 7-8

grouping, vis_ug, 6-8

hierarchy of, vis_ug, 7-3

manipulating, vis_ug, 12-7

modifying behavior of, vis_ug, 11-10

moving, vis_ug, 6-11, 12-7

multiple selection of, vis_ug, 12-7

parent and child, vis_ug, 7-3

pasting, vis_ug, 12-7

references to other objects, vis_ug, 12-8

resizing, vis_ug, 6-12

searching for, vis_ug, 12-8

See also Object properties.,

selecting, vis_ug, 7-10, 5-16, 7-9

using scene parameters to modify, vis_ug, 7-18

viewing events specified for, vis_ug, 11-11

ways to modify behavior of, vis_ug, 7-8

OCTET_LENGTH function, sqls, 1-921

ODBC, instll32, 11

ODBC Driver Manager,

installing, instll32, 5

versions of, instll32, 5

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, using, vis_ug, 1-24

On-line manuals, sqlr, Intro-14, sqls, Intro-19, sqlt, Intro-11

On-line notes, location of, instll32, 3

ONCONFIG environment variable, sqlr, 3-56

ONCONFIG parameter,

DBSPACETEMP, sqls, 1-643

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

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

onload utility, sqlt, 4-31

onunload utility, sqlt, 9-44, 4-31

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

alignment of, sqls, 1-170

as argument, sqls, 1-170

cast for, sqlt, 13-5

creating with CREATE OPAQUE TYPE, sqls, 1-167

DESCRIBE with, sqls, 1-438

description of, sqlr, Glossary-13

dropping with DROP TYPE, sqls, 1-381

extended identifier, sqls, 1-711, 1-438

fixed length, sqls, 1-169

fixed-length, sqls, 1-169

GET DESCRIPTOR with, sqls, 1-438

in DELETE, sqls, 1-329

in DROP TABLE, sqls, 1-377

in dynamic SQL, sqls, 1-711

in INSERT, sqls, 1-503

in LOAD, sqls, 1-522

in UPDATE, sqls, 1-793

loading, sqls, 1-522, 1-518

modifiers, sqls, 1-169

name of, sqls, 1-711, 1-438

naming, sqls, 1-168

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

privileges, sqls, 1-168

row field literal, sqls, 1-1008

sizing, sqls, 1-168

smart large objects with, sqlr, 2-17

storage of, sqlr, 2-53

support functions, sqls, 1-171

syscolumns coltype code for, sqlr, 1-24

sysxtddesc contents for, sqlr, 1-62

unloading, sqls, 1-772

varying length, sqls, 1-169

varying-length, sqls, 1-169

with SET DESCRIPTOR, sqls, 1-711

Opaque type,

cast matrix, sqlr, 2-32

Opaque variable,

inserting, sqls, 1-503

Opclass. SeeOperator class.,

OPEN statement, sqls, 1-528 to

activating a cursor, sqlt, 5-21

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

FREE statement with, sqls, 1-538

function cursor, sqls, 1-531

insert cursor, sqls, 1-532

opening select or update cursors, sqlt, 5-21

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

substituting values for ? parameters, sqls, 1-533

USING clause, sqls, 1-534

USING DESCRIPTOR clause, sqls, 1-535

WITH REOPTIMIZATION clause, sqls, 1-536

Opening,

data elements, vis_ug, 5-20

worlds, vis_ug, 12-3

Operator, sqlr, Glossary-13

binding, sqlr, Glossary-13

function, sqlr, Glossary-13

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

Operator class,

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

dropping with DROP OPCLASS, sqls, 1-360

rtree_ops, sqls, 1-179

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

sysopclasses information, sqlr, 1-42

Operator function,

concat(), sqls, 1-884

divide(), sqls, 1-959

equal(), sqls, 1-1020

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

times(), sqls, 1-959

Operators,

in property expressions, vis_ug, 7-12

list of, vis_ug, C-2

OPTCOMPIND environment variable, values, sqlr, 3-57

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

Optimizing spatial queries, vis_ug, 13-6

Optional entity in relationship, sqlt, 8-10

Options,

docking the Object Inspector, vis_ug, 7-10

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

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

Organization charts,

description of, vis_ug, 5-7

properties of, vis_ug, A-45

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

Output window, vis_ug, 1-19, 1-7

Overlap() function, vis_ug, 13-6

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

Ownership, sqlt, 11-7

SET statement,

See also Object mode,