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 ]

D

, cast operator.,

Data,

accessing in fragmented tables, sqlt, 9-52

blocks in query diagrams, vis_ug, 3-30

displaying, vis_ug, 5-3

inserting values, sqls, 1-499

loading into database, sqls, 1-515

mapping layouts to, vis_ug, 5-17

mapping object properties to, vis_ug, 7-9

See also Data elements; Data sources.,

showing relationships in, vis_ug, 5-4

unloading from database, sqls, 1-769

Data conversion. See Data type, conversion.,

Data definition language statements, sqls, 1-16, sqlt, 5-34

Data distribution, sqlr, Glossary-5

Data distributions,

confidence, sqls, 1-814

disk space for (DBUPSPACE), sqlr, 3-41

on temporary tables, sqls, 1-811

RESOLUTION, sqls, 1-814

UPDATE STATISTICS (HIGH), sqls, 1-814

UPDATE STATISTICS (MEDIUM), sqls, 1-814

sysdistrib information, sqlr, 1-32

Data Element Editor, vis_ug, 1-16, 1-7

description of, vis_ug, 5-9

illustration of, vis_ug, 1-16, 7-17

printing from, vis_ug, 12-5

Data elements, vis_ug, 1-4

about modifying, vis_ug, 5-18

adding levels of detail to, vis_ug, 5-31

child objects of, vis_ug, 5-16

definition of, vis_ug, 1-5, 5-4

initial, vis_ug, 5-10

inserting, vis_ug, 5-24

introduction to, vis_ug, 1-16

levels of detail in, vis_ug, 5-31

modifying, vis_ug, 5-19, 11-9, 5-15, 5-9

multiple, vis_ug, 5-24

opening, vis_ug, 5-20

properties of, vis_ug, A-22

viewing, vis_ug, 5-15

visibility of, vis_ug, 5-19

DATA field,

and INDICATOR field, sqls, 1-710

and TYPE field, sqls, 1-709

syntax, sqls, 1-433

with DATETIME and INTERVAL types, sqls, 1-710

with DESCRIBE, sqls, 1-342

with SET DESCRIPTOR, sqls, 1-709

Data integrity, sqlt, 4-19, 4-27 to

definition of, sqlr, Glossary-5

object modes, sqls, 1-669

object modes with, sqls, 1-663 to

statements, sqlr, Glossary-5, sqls, 1-17

Data layers. See Layers.,

Data manipulation language,

SQL statements for, sqls, 1-17

Data manipulation statements, sqlr, Glossary-5

object modes with, sqls, 1-657 to

Data model,

attribute, sqlt, 8-17

building, sqlt, 8-3 to

defining relationships, sqlt, 8-9

description of, sqlt, 1-3, 8-3

entity relationship, sqlt, 8-5

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

one-to-many relationship, sqlt, 8-13

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

See also Relational model.,

telephone-directory example, sqlt, 8-7

Data page,

illustration of, vis_ug, 1-11

of the World Manager, vis_ug, 1-9

Data points,

modifying, vis_ug, 5-9

representing, vis_ug, 5-20

See also Data symbols.,

visually linking, vis_ug, 5-23

Data replication, sqlr, Glossary-6

Data Sheet view, vis_ug, 1-14

about, vis_ug, 3-29

opening multiple windows for, vis_ug, 3-41

uses for, vis_ug, 3-6

viewing results in, vis_ug, 3-39, 3-28, 3-40, 3-15

Data sources,

about, vis_ug, 3-3

about parameters in, vis_ug, 3-41

adding, vis_ug, 3-8

aliasing columns when creating, vis_ug, 3-14

and scenes, vis_ug, 4-3

and the Advanced Query wizard, vis_ug, 3-15

and the Query Editor, vis_ug, 1-14

changing, vis_ug, 5-19

choosing columns for, vis_ug, 3-10

choosing functions for, vis_ug, 3-9

creating, vis_ug, 3-7

defining output from, vis_ug, 3-14

definition of, vis_ug, 1-5

displaying multiple, vis_ug, 5-25

examples of, vis_ug, 2-5

inserting, vis_ug, 3-8, 3-16

inserting query parameters in, vis_ug, 3-43

mapping, vis_ug, 5-12, 5-9

query diagrams and, vis_ug, 3-29

selecting, vis_ug, 5-11, 5-9

selecting in the Layout wizard, vis_ug, 5-11

using the Query Editor to create, vis_ug, 3-29

viewing, vis_ug, 3-39, 3-40, 3-15

viewing SQL query text for, vis_ug, 3-38

Visionary building blocks and, vis_ug, 1-4

Data Sources panel,

and query parameters, vis_ug, 3-44

illustration of, vis_ug, 1-10

viewing data sources in, vis_ug, 3-15

Data symbols,

adding to a scene, vis_ug, 6-6

definition of, vis_ug, 6-6

description of, vis_ug, 5-20

example of inserting, vis_ug, 5-22

list of, vis_ug, 5-21

Data Symbols panel, vis_ug, 1-12

Data type, sqls, 1-860 to

approximate, sqlr, 1-68

automatic conversions, sqlt, 5-16

casting, sqlr, 2-25 to , sqls, 1-112, 1-885

changing with ALTER TABLE, sqls, 1-79, sqlt, 9-33

character, sqlt, 9-20 to

choosing, sqlt, 9-5 to

referential constraint considerations, sqlt, 9-6

chronological, sqlt, 9-15 to

collection, sqls, 1-876

complex, sqls, 1-874

constructing an instance of, sqls, 1-900

conversion, sqlt, 4-9

date and time, sqlt, 9-15

definition of, sqlr, Glossary-6

determining dynamically, sqls, 1-341

distinct, sqls, 1-873

duration interval, sqlt, 9-17

exact numeric, sqlr, 1-68

execution time, sqlt, 9-23

extended, sqlr, 2-71, 2-20

fixed-point, sqlt, 9-13

floating-point, sqlr, 2-47, sqlt, 9-12

for code, sqlt, 9-9

for counter, sqlt, 9-9

for sequential integer, sqlr, 2-61, 2-59

for unique numeric code, sqlr, 2-61, 2-59

formatting loaded values, sqls, 1-517

INSERT considerations, sqls, 1-1018, 1-502

INT, sqlr, 2-47

numeric, sqlt, 9-9 to

opaque, sqls, 1-167

referential constraints rules, sqls, 1-71

See also each data type listed under its own name.,

simple large object, sqlr, 2-19, sqls, 1-870

smart large object, sqlr, 2-17

summary table, sqlr, 2-7

varying length, sqlt, 9-22 to

view inherits, sqls, 1-290

Data Type segment, sqls, 1-860

Data types, vis_ug, B-2

and cast functions, vis_ug, 7-14

and global parameters, vis_ug, 11-9

and scene parameters, vis_ug, 4-7

casting functions for, vis_ug, B-7

casting in queries, vis_ug, 3-44

enumerated, vis_ug, B-5

in property expressions, vis_ug, 7-13

support syntax for, vis_ug, B-3

Data-bound objects,

adding, vis_ug, 5-34

and empty layouts, vis_ug, 5-17

and the simple form layout, vis_ug, 5-6

definition of, vis_ug, 5-3, 5-34

inserting, vis_ug, 5-35

Database,

access control. See Privilege, database-level.,

ANSI-compliant, sqlt, 1-17

archiving, sqlt, 1-9

closing with CLOSE DATABASE, sqls, 1-97

concurrent use, sqlt, 1-8

creating with CREATE DATABASE, sqls, 1-118

data types, sqlr, 2-33

default isolation levels, sqls, 1-746, 1-725

defined, sqlr, Glossary-6

dropping with DROP DATABASE, sqls, 1-352

exception codes, sqls, 1-442

GLS, sqlt, 1-17

loading data into, sqls, 1-515

lock, sqls, 1-296

management of, sqlt, 1-8

map of,

stores7, sqlr, A-8

mission-critical, sqlt, 1-9

naming conventions, sqls, 1-858

naming unique to database server, sqlt, 9-38

naming with variable, sqls, 1-859

object-relational, description of, sqlt, 1-10

opening in exclusive mode, sqls, 1-296

optimizing queries, sqls, 1-809

populating new tables, sqlt, 9-43

privileges. See Privilege, database-level.,

remote, sqls, 1-859

renaming, sqls, 1-571

script for creating, sqlt, 9-42

server, sqlt, 1-8

stores7 description of, sqlr, A-1

tables in (systables), sqlr, 1-54

unloading data from, sqls, 1-769

Database Administration Kit,

component descriptions, instll32, 12

documentation for, instll32, 2

Database administrator (DBA), sqlr, Glossary-6, sqlt, 11-7

privileges,

granting, sqls, 1-462

list of, sqls, 1-464

revoking, sqls, 1-577

Database application, sqlr, Glossary-6

Database Contents panel, vis_ug, 3-6, 1-11

Database environment, sqlr, Glossary-6

Database locale, setting language features, instll32, 29

Database lock, sqlt, 7-8

Database management system (DBMS), sqlr, Glossary-6

Database Name segment,

for remote database, sqls, 1-859

naming conventions, sqls, 1-857

naming with variable, sqls, 1-859

syntax, sqls, 1-857

Database object, sqlr, Glossary-6

constraints as a, sqlt, 4-25

creating,

revoking privileges for, sqls, 1-578

index as a, sqlt, 4-25

object modes, sqlt, 4-25

state of (sysobjstate), sqlr, 1-40

trigger as a, sqlt, 4-25

violation detection, sqlt, 4-25

Database server,

archiving, sqlt, 4-31

attributes in Information Schema view, sqlr, 1-70

default, instll32, 29

default for connection (INFORMIXSERVER), sqlr, 3-49

identifying, instll32, 28

setting parameters, instll32, 20

database server name,

function name qualifier, sqls, 1-965

DATABASE statement,

determining database type, sqls, 1-296

exclusive mode, sqls, 1-296, sqlt, 7-8

locking, sqlt, 7-8

specifying current database, sqls, 1-295

SQLWARN after, sqls, 1-296, sqlt, 5-12

syntax, sqls, 1-295

Database, stores 7, sqlr, A-1

Databases,

connecting to, vis_ug, 1-20

logging option for, vis_ug, 1-20, Intro-5

Datablade,

message information (syserrors), sqlr, 1-33

DataBlade API, sqlr, Glossary-6

DataBlade Developers Kit,

component descriptions, instll32, 11

documentation for, instll32, 2

DataBlade module, sqlr, Glossary-6

DataBlade modules, vis_ug, Intro-5, sqlt, 1-10

Dataskip,

skipping unavailable dbspaces, sqls, 1-692

DATE data type, instll32, 27, sqlr, 2-39, sqls, 1-871, sqlt, 9-15

casting to integer, sqlr, 2-28

converting to DATETIME, sqlr, 2-28

DATETIME, INTERVAL with, sqlr, 2-10, 2-13

format for (DBDATE), sqlr, 3-23

functions in, sqls, 1-932

greater than condition, sqls, 1-1020

international date formats, sqlr, 2-40, sqlt, 1-17

ORDER BY sequence, sqlt, 2-13

source data, sqlr, 2-14

syscolumns coltype code for, sqlr, 1-24

two-digit year values and DBCENTURY variable, sqlr, 2-40

unloading, sqls, 1-770

year digits for (DBCENTURY), sqlr, 3-20

DATE function, sqls, 1-932, 1-933, sqlt, 2-58

Dates,

example of formatting, vis_ug, 7-14

formatting in property expressions, vis_ug, 7-12

DATETIME data type, instll32, 28, sqlr, 2-40, sqls, 1-871, sqlt, 9-16

character string values, sqlr, 2-43

converting to DATE, sqlr, 2-28

converting to integer, sqlr, 2-28

DATE function with, sqlt, 2-58

DATE INTERVAL with, sqlr, 2-10 to

EXTEND function with, sqlr, 2-13, sqlt, 2-58

extending fields in, sqlr, 2-11

field qualifiers, sqlr, 2-41, sqls, 1-879

format, sqlt, 9-18

format for, sqlt, 2-58

format for (DBTIME), sqlr, 3-38

functions on, sqls, 1-932

greater than condition, sqls, 1-1020

international formats, sqlr, 2-44, sqlt, 9-19

length (syscolumns), sqlr, 1-28

ORDER BY sequence with, sqlt, 2-13

source data, sqlr, 2-14

syscolumns coltype code for, sqlr, 1-24

two-digit year values and DBDATE variable, sqlr, 2-43

unloading, sqls, 1-772

with SET DESCRIPTOR, sqls, 1-710

year digits for (DBCENTURY), sqlr, 3-20

DATETIME Field Qualifier, sqls, 1-879

DATETIME function,

CREATE TABLE with, sqls, 1-223

DAY function, sqls, 1-932, 1-934

DB-Access,

creating database with, sqlt, 9-42, 5-34

Modify option, sqlt, 14-80

syntax error, sqlt, 14-80

UNLOAD statement, sqlt, 9-44

DB_LOCALE environment variable, instll32, 25

DBA See Database administrator (DBA); Privilege,

database-level.,

dbaccessdemo7 script, vis_ug, 1-26, sqlr, Intro-6, sqls, Intro-6, sqlt, Intro-7

DBALSBC environment variable, instll32, 25

DBANSIWARN environment variable, instll32, 25, sqlr, 3-17, sqls, 1-206, 1-291, 1-969

DBAPICODE environment variable, instll32, 26

DBASCIIBC environment variable, instll32, 26

DBBLOBBUF environment variable, sqlr, 3-19, sqls, 1-773

LOAD with, sqls, 1-521

DBCENTURY environment variable, instll32, 26, sqlr, 3-20

date value interpretation, sqls, 1-1045

DBDATE with, sqlr, 3-25

LOAD with, sqls, 1-517

DBCONNECT environment variable, instll32, 26

DBCSCONV environment variable, instll32, 26

DBCSOVERRIDE environment variable, instll32, 26

DBCSWIDTH environment variable, instll32, 27

DBDATE environment variable, instll32, 27, sqlr, 3-23, sqls, 1-770, 1-933, sqlt, 9-16, 4-9

DBDELIMITER environment variable, sqlr, 3-26, sqls, 1-775

LOAD with, sqls, 1-523

DBEDIT environment variable, sqlr, 3-26

DBFLTMASK environment variable, instll32, 27, sqlr, 3-27

DBINFO function, sqls, 1-912

sessionid option with, sqls, 1-915

DBLANG environment variable, instll32, 27, sqlr, 3-28

DBMONEY environment variable, instll32, 27, sqlr, 3-29, sqls, 1-771, sqlt, 9-15

DBMONEYSCALE environment variable, instll32, 27

DBMS. See Database management system.,

DBNLS environment variable, instll32, 28

DBONPLOAD environment variable, sqlr, 3-31

DBPATH environment variable, instll32, 28, sqlr, 3-31

DBPRINT environment variable, sqlr, 3-34

DBREMOTECMD environment variable, sqlr, 3-35

dbschema utility, sqlt, 9-42

DBSERVERNAME function, sqls, 1-895

CREATE TABLE with, sqls, 1-223

example, sqlt, 3-19

dbspace,

ALTER FRAGMENT to add, sqlt, 9-50

CREATE DATABASE with, sqlt, 9-39

DBINFO function with, sqls, 1-914

default, sqls, 1-118

definition of, sqlr, Glossary-6

INFO statement with, sqls, 1-492

name, sqls, 1-914

round robin distribution, sqls, 1-44

setting with CREATE TABLE, sqls, 1-246

skipping if unavailable, sqls, 1-692

temporary tables in, sqls, 1-246, 1-643

dbspaces,

size and location, sqlr, 1-18

DBSPACETEMP configuration parameter,

CREATE TEMP TABLE with, sqls, 1-219

DBSPACETEMP environment variable, sqlr, 3-36, sqls, 1-643

CREATE TEMP TABLE with, sqls, 1-219

DBSS2 environment variable, instll32, 28

DBSS3 environment variable, instll32, 28

DBTEMP environment variable, instll32, 28, sqlr, 3-37

DBTIME environment variable, instll32, 28, sqlr, 3-38, sqls, 1-772, sqlt, 9-19

DBUPSPACE environment variable, sqlr, 3-41

DDL.See Data definition language.,

Deadlock detection, sqls, 1-729, sqlt, 7-19

DEALLOCATE COLLECTION statement, sqls, 1-297

DEALLOCATE DESCRIPTOR statement, sqls, 1-299

DEALLOCATE ROW statement, sqls, 1-301

DEC data type. See DECIMAL data type.,

DECIMAL data type, sqls, 1-866

casts for, sqlr, 2-27

description of, sqlr, 2-45

disk storage, sqlr, 2-45

fixed-point, sqlr, 2-45, sqlt, 9-13

floating-point, sqlr, 2-44, sqlt, 9-12

GET DESCRIPTOR with, sqls, 1-437

length (syscolumns), sqlr, 1-27

precision and scale, sqls, 1-437

syscolumns coltype code for, sqlr, 1-24

unloading, sqls, 1-771

with SET DESCRIPTOR, sqls, 1-710

Decimal digits, display of, sqlr, 3-27

Decimal point (.),

as delimiter in INTERVAL, sqlr, 2-50

Decimal point. See \xfa , decimal point.,

DECLARE statement, sqls, 1-303 to

collection derived table with, sqls, 1-833

collection variables with, sqls, 1-833

CURSOR FOR keyword, sqlt, 5-21

CURSOR keyword, sqls, 1-316

cursors with prepared statements, sqls, 1-319

FOR INSERT clause, sqlt, 6-9

FOR READ ONLY option, sqls, 1-310

FOR UPDATE, sqlt, 6-15

FOR UPDATE column list, sqls, 1-312

FOR UPDATE option, sqls, 1-310

restrictions with SELECT with ORDER BY, sqls, 1-638

SCROLL keyword, sqls, 1-317, sqlt, 5-24

SELECT with, sqls, 1-608

transactions with, sqls, 1-325

WHERE CURRENT OF clause, sqls, 1-311

WITH HOLD clause, sqlt, 7-24

WITH HOLD keywords, sqls, 1-318

DEFAULT keyword,

in CONNECT statement, sqls, 1-103

Default locale, sqlr, Intro-5, sqls, Intro-6, sqlt, Intro-6

Default value, sqlr, Glossary-7, sqlt, 9-34

CREATE TABLE limitations, sqls, 1-225

CREATE TABLE syntax for, sqls, 1-223

sysdefaults information, sqlr, 1-30

Defaults,

for color sequences, vis_ug, 11-4

for global parameters, vis_ug, 11-8

for level of detail transition points, vis_ug, 5-31

for viewer classes, vis_ug, 11-4

Deferred-PREPARE feature, sqls, 1-698

DEFINE statement, sqls, 2-8

placement of, sqls, 2-10

Delete privilege, sqlt, 11-8

DELETE statement, sqls, 1-327 to

all rows of table, sqlt, 4-4

cascading, sqls, 1-330

collection columns with, sqls, 1-329

Collection derived table clause, sqls, 1-333, 1-337

collection derived table with, sqls, 1-833

collection variables with, sqls, 1-332, 1-333, 1-833

coordinated deletes, sqlt, 6-6

count of rows, sqls, 1-450, 1-915, sqlt, 6-4

cursor with, sqls, 1-311

description of, sqlt, 4-4

embedded, sqlt, 5-6, 6-3 to

missing WHERE signalled, sqls, 1-340

number of rows, sqlt, 5-10

object modes with, sqls, 1-657

preparing, sqlt, 5-31

privilege for, sqlt, 11-5, 11-8

privilege for See Privilege, table-level.,

row variables with, sqls, 1-337

transactions with, sqlt, 6-5

trigger, sqls, 1-260

using subquery, sqlt, 4-6

view with, sqlt, 11-29

WHERE clause, sqls, 1-330

checking for, sqls, 1-340

WHERE clause restricted, sqlt, 4-7

WHERE CURRENT OF clause, sqls, 1-331

with cursor, sqlt, 6-7

with SELECT...FOR UPDATE, sqls, 1-639

with update cursor, sqls, 1-331

within a transaction, sqls, 1-328

Deleting,

objects, vis_ug, 12-7

worlds, vis_ug, 12-6

DELIMIDENT environment variable, instll32, 28, sqlr, 3-42, sqls, 1-972

variable name 'global' with, sqls, 1-983

Delimited identifier, instll32, 28

Delimiter,

for DATETIME values, sqlr, 2-42

for INTERVAL values, sqlr, 2-50

specifying with LOAD, sqls, 1-523

specifying with UNLOAD, sqls, 1-775

DELIMITER keyword,

in UNLOAD, sqls, 1-775

Demonstration database, sqlr, Intro-6, sqls, Intro-6, sqlt, Intro-7

map of, sqlr, A-8

See also stores7 database.,

structure of tables, sqlr, A-2

tables in, sqlr, A-2 to

Dependencies, software, vis_ug, Intro-5

Derived data types, vis_ug, B-2

DESCRIBE statement, sqls, 1-338 to

collection variable with, sqls, 1-344

Deferred-PREPARE feature with, sqls, 1-699

describing statement type, sqlt, 5-33

distinct data type with, sqls, 1-439

GET DESCRIPTOR with, sqls, 1-436

INTO sqlda pointer clause, sqls, 1-343

LENGTH field, sqls, 1-438

opaque data type with, sqls, 1-438

statement type, sqls, 1-339

USING SQL DESCRIPTOR clause, sqls, 1-341

with SET DESCRIPTOR, sqls, 1-712

Descriptor column, sqlt, 8-25

Descriptor. See System-descriptor area.,

Design mode, vis_ug, 1-15, 1-16

Designing worlds, vis_ug, 2-3

Destination scene, vis_ug, 8-10

Destroy support function, sqls, 1-377, 1-329, 1-172

Detached index, sqlr, Glossary-7, sqls, 1-157

Diagnostic area,

message codes in, sqls, 1-442

Diagnostic table,

examples with object mode, sqls, 1-659

many to one relationship to violations table, sqls, 1-663

starting with constraint -mode and index-mode objects, sqls, 1-666

Diagnostics area,

fields of, sqls, 1-452

GET DIAGNOSTICS statement with, sqls, 1-441

number of exceptions, sqls, 1-450

Diagnostics table,

creating with START VIOLATIONS TABLE, sqls, 1-748

examples, sqls, 1-763, 1-765, 1-768

how to stop, sqls, 1-767

privileges on, sqls, 1-761

relationship to target table, sqls, 1-753

relationship to violations table, sqls, 1-753

starting with filtering-mode objects, sqls, 1-653

starting with START VIOLATIONS TABLE, sqls, 1-748

stopping with filtering-mode objects, sqls, 1-654

structure, sqls, 1-760

sysviolations information, sqlr, 1-61

use with SET, sqls, 1-653

Dialog boxes,

Choose Boolean Operator, vis_ug, 3-19

Choose Column, vis_ug, 3-18, 3-10

Choose Function, vis_ug, 3-9

Expression Editor, vis_ug, 3-11, 3-9

Find, vis_ug, 12-9

Help Topics, vis_ug, 1-25

HTML Test Page, vis_ug, 13-5

Insert Parameter, vis_ug, 14-8

Insert Viewpoint, vis_ug, 8-5

Jump To, vis_ug, 14-10, E-10, E-11, 8-5, 1-23

Level of Detail Transition Editor, vis_ug, 8-9

New Data Source, vis_ug, 3-8, 3-16

Object Behavior, vis_ug, 1-18, 11-12, 9-5

Object Behavior (Parameters page), vis_ug, 11-13

Open Database, vis_ug, 13-4, 1-20

Open World, vis_ug, 12-3, 12-6

Page Setup, vis_ug, 12-5

Print, vis_ug, 12-5

Publish World, vis_ug, 13-4

Query Parameter, vis_ug, 3-43, 3-25

Runtime Settings, vis_ug, 14-11, 14-4, E-7, E-13, 14-8, 1-23

Save, vis_ug, 12-4

Viewpoints, vis_ug, 14-4, E-12, E-8

World Database, vis_ug, 13-6

Wormhole Destination, vis_ug, 8-11

Diamond data symbols, vis_ug, 5-22

Dirty Read isolation level (Informix), sqls, 1-724, sqlt, 7-13

Disabled object mode, sqls, 1-658

defined, sqlr, Glossary-7, sqlt, 4-25

DISCONNECT statement, sqls, 1-346 to

ALL keyword, sqls, 1-349

CURRENT keyword, sqls, 1-348

DEFAULT option, sqls, 1-347

transaction with, sqls, 1-348

Disk space,

distribution data size, sqlr, 3-41

Display label,

derived SELECT data, sqlt, 2-48

in ORDER BY clause, sqlt, 2-50

Displaying,

data, vis_ug, 5-3

pictures in a scene, vis_ug, 11-7

Distinct data type, sqls, 1-873

cast for, sqlt, 13-5

casting, sqls, 1-122, sqlt, 13-17

casts, sqlr, 2-31

casts and DROP TYPE, sqls, 1-381

creating with CREATE DISTINCT TYPE, sqls, 1-121

definition of, sqlr, Glossary-7, 2-46

DESCRIBE with, sqls, 1-439

dropping casts on, sqls, 1-351

dropping with DROP TYPE, sqls, 1-381

dynamic SQL with, sqls, 1-439

GET DESCRIPTOR with, sqls, 1-439

in dynamic SQL, sqls, 1-712

privileges, sqls, 1-122

restrictions on source type, sqls, 1-122

source data type, sqls, 1-712, 1-439

sysxtddesc contents for, sqlr, 1-62

with SET DESCRIPTOR, sqls, 1-712

DISTINCT keyword,

in CREATE INDEX, sqls, 1-139

relation to GROUP BY, sqlt, 3-4

restrictions in modifiable view, sqlt, 11-29

use in expression, sqls, 1-948

Distributed deadlock, sqlt, 7-20

Distributions,

dropping with DROP DISTRIBUTIONS clause, sqls, 1-813

MEDIUM or HIGH distribution, sqls, 1-814

privileges required to create, sqls, 1-813

divide() operator function, sqls, 1-959

DML.See Data manipulation language.,

Documentation,

related reading, vis_ug, Intro-9

types of, vis_ug, Intro-9

Documentation conventions,

command-line, sqlr, Intro-10

icon, sqlr, Intro-9, sqls, Intro-10, sqlt, Intro-10

sample-code, sqlr, Intro-13, sqls, Intro-18, sqlt, Intro-11

syntax, sqls, Intro-12

typographical, sqlr, Intro-8, sqls, Intro-9, sqlt, Intro-9

Documentation notes, vis_ug, Intro-9, sqlr, Intro-15, sqls, Intro-20, sqlt, Intro-13

Documentation notes, location of, instll32, 3

Documentation, types of,

documentation notes, sqlr, Intro-15, sqls, Intro-20, sqlt, Intro-13

error message files, sqlr, Intro-15, sqls, Intro-20, sqlt, Intro-12

machine notes, sqlr, Intro-15, sqls, Intro-20, sqlt, Intro-13

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

printed manuals, sqlr, Intro-14, sqls, Intro-19, sqlt, Intro-12

release notes, sqlr, Intro-15, sqls, Intro-20, sqlt, Intro-13

Domain,

definition of, sqlt, 9-35

Dominant table, sqlt, 3-20

Dot notation, sqlt, 12-9

Double colon. See,

,

DOUBLE PRECISION data type, sqlr, 2-47, sqls, 1-868

DOUBLE PRECISION data type. SeeFLOAT data type.,

Double-dash (--) comment symbol, sqls, 1-1045

Dragging objects, vis_ug, 12-7

DROP CAST statement, sqls, 1-350

changing cast for distinct data type, sqlt, 13-19

DROP DATABASE statement, sqls, 1-352

DROP FUNCTION statement, sqls, 1-354

DROP INDEX statement, sqls, 1-358

DROP OPCLASS statement, sqls, 1-360

DROP PROCEDURE statement, sqls, 1-362

DROP ROLE statement, sqls, 1-366

DROP ROUTINE statement, sqls, 1-368

DROP ROW TYPE statement, sqls, 1-372

RESTRICT keyword, sqls, 1-373

DROP SYNONYM statement, sqls, 1-374

DROP TABLE statement, sqls, 1-376

CASCADE keyword, sqls, 1-377

effects of, sqls, 1-376

RESTRICT keyword, sqls, 1-377

DROP TRIGGER statement, sqls, 1-379

DROP TYPE statement, sqls, 1-381

DROP VIEW statement, sqls, 1-383

Duplicate index, sqlr, Glossary-7

Duplicate values,

finding, sqlt, 3-15

querying for, sqls, 1-601

Dynamic management statements, sqls, 1-508

Dynamic routine-name specification, sqlr, Glossary-7

of SPL functions, sqls, 1-402, sqlt, 14-72

of SPL procedures, sqls, 1-410, sqlt, 14-72

rules for, sqlt, 14-74

Dynamic SQL,

description of, sqlt, 5-5, 5-29

freeing prepared statements, sqlt, 5-33