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 ]

A

ABS function, sqls, 1-908

Access,

restricting to columns or rows, sqlt, 11-23

restricting to view, sqlt, 11-32

restricting with SPL routine, sqlt, 11-19

Access control. See Privilege, database-level, Connect.,

Access method,

CREATE TABLE option, sqls, 1-255

CREATE TABLE with, sqls, 1-255

definition of, sqlr, Glossary-1

index, sqls, 1-138

name clause, sqls, 1-256

primary, sqls, 1-255

secondary, sqls, 1-138

SQL statements for, sqls, 1-14

sysams information about, sqlr, 1-12

Access mode, sqlt, 7-17

Access privilege, sqlr, Glossary-1

Accessing query wizards, vis_ug, 3-6

ACOS function, sqls, 1-937, 1-939

Actions, vis_ug, D-7

Active set,

constructing with OPEN, sqls, 1-530, 1-531

cursor, sqlt, 5-24 to

deallocating, sqls, 1-94

of sequential cursor, sqls, 1-414

retrieving data with FETCH, sqls, 1-411

scroll cursor, sqls, 1-416, 1-317

sequential cursor, sqls, 1-316

ActiveX Control Pad, vis_ug, 14-7

ActiveX controls, vis_ug, 1-4

about, vis_ug, 10-3

ActiveMovie description, vis_ug, 10-4

ActiveMovie properties, vis_ug, A-4

ActiveMovie requirements, vis_ug, Intro-5

adding, vis_ug, 10-4

required properties, vis_ug, 10-5

RichTextBox description, vis_ug, 10-4

supported by Visionary, vis_ug, 10-4

Visionary Viewer deployed as, vis_ug, 14-3, 1-22

WebBrowser description, vis_ug, 10-4

Adding,

ActiveX controls, vis_ug, 10-4

alignment panels, vis_ug, 6-10, 6-9

axes, vis_ug, 5-18

connectors, vis_ug, 6-7

data elements, vis_ug, 5-24

data sources, vis_ug, 3-8, 3-16

data symbols, vis_ug, 5-22, 6-6

data-bound objects, vis_ug, 5-34

event actions, vis_ug, 9-4

global parameters, vis_ug, 11-8

layers, vis_ug, 5-24, 5-26

layouts, vis_ug, 5-9 to

levels of detail to a data element, vis_ug, 5-31

levels of detail to a scene, vis_ug, 8-8

parameterized wormholes, vis_ug, 8-12

primitives, vis_ug, 6-5

query parameters, vis_ug, 3-43

resources, vis_ug, 11-5

scene parameters, vis_ug, 4-6

scenes, vis_ug, 4-5

simple wormholes, vis_ug, 8-11

static objects, vis_ug, 6-4

stock images, vis_ug, 11-5

viewpoints, vis_ug, 8-5

Advanced Query wizard,

choosing related column fields in, vis_ug, 3-21

defining column relationships in, vis_ug, 3-19

defining filters in, vis_ug, 3-24

for multiple tables, vis_ug, 3-17

launching, vis_ug, 3-6, 3-16

specifying parameters in, vis_ug, 3-25

SQL format for, vis_ug, 3-15

uses for, vis_ug, 3-5

using, vis_ug, 3-6, 3-15

viewing results, vis_ug, 3-28

Aggregate expression. See Aggregate function;Expression segment.,

Aggregate function,

and GROUP BY clause, sqlt, 3-5

behavior of, example, sqls, 1-956

error checking with external (ESQL) function, sqls, 1-958

error checking,

counting selected rows with COUNT, sqls, 1-958

empty rows (indicator variable), sqls, 1-958

in ESQL, sqlt, 5-14

in subquery, sqlt, 3-32

restrictions, sqls, 1-948

restrictions in modifiable view, sqlt, 11-29

restrictions with GROUP BY, sqls, 1-631

rowid not allowed with, sqls, 1-890

Aggregate functions, sqls, 1-946 to

Aggregates, defining queries with, vis_ug, 3-7, 3-12

Algebraic functions, sqls, 1-905 to

Algorithm,

for adding columns to tables, sqls, 1-59

Alias,

SELECT with, sqls, 1-610, 1-599

SELECT...AS with, sqls, 1-613

SELECT...FROM with, sqlt, 2-74

table name replacement, sqlt, 2-74

to assign column names in temporary table, sqlt, 3-13

typed table with, sqlt, 12-6

use before define, sqlt, 2-74

use with GROUP BY clause, sqls, 1-630, 1-634

Alignment of axes, vis_ug, 5-19

Alignment panels,

adding, vis_ug, 6-10, 6-9

and layers, vis_ug, 5-26

example of using, vis_ug, 5-34

grouping objects with, vis_ug, 6-9 to

mapping values to location of, vis_ug, 5-33

modifying, vis_ug, 5-16

properties of, vis_ug, A-6

uses of, vis_ug, 6-3, 6-8

using, vis_ug, 6-8

when to use, vis_ug, 5-23

ALLOCATE DESCRIPTOR statement, sqls, 1-27

syntax, sqls, 1-22

WITH MAX clause, sqls, 1-25

Allocating memory,

with ALLOCATE COLLECTION, sqls, 1-22

ALS. See Asian Language Support.,

ALTER FRAGMENT statement,

ADD Clause, sqls, 1-46

ATTACH clause, sqls, 1-32 to

example, sqls, 1-36

DETACH clause, sqls, 1-37

DROP clause, sqls, 1-48

effects on large objects, triggers, constraints, indexes, sqls, 1-33

example, sqlt, 9-49

INIT clause, sqls, 1-38, sqlt, 9-50, 9-53

logging, sqls, 1-31

MODIFY clause, sqls, 1-49

privileges, sqls, 1-30

ALTER INDEX, sqls, 1-52

ALTER INDEX statement,

creating clustered index, sqls, 1-52

dropping clustered index, sqls, 1-53

TO CLUSTER clause, sqls, 1-53

ALTER TABLE,

DEFAULT clause, sqls, 1-61

ALTER TABLE statement,

ADD clause, sqls, 1-58

ADD CONSTRAINT clause, sqls, 1-81

ADD ROWIDS clause, sqlt, 9-53

ADD TYPE clause, sqls, 1-86

BEFORE option, sqls, 1-74

casting effects, sqlr, 2-26

CHECK clause, sqls, 1-73

constraint mode definition, sqls, 1-65

DROP clause, sqls, 1-75

DROP CONSTRAINT clause, sqls, 1-85

DROP ROWIDS clause, sqlt, 9-53

LOCK MODE clause, sqls, 1-88

MODIFY NEXT SIZE clause, sqlr, 1-10

ON DELETE CASCADE option, sqls, 1-71

PAGE keyword, sqls, 1-88

privileges for See Privilege, table-level.,

REFERENCES clause, sqls, 1-68

ROW keyword, sqls, 1-88

ROWIDS clause, sqls, 1-88

setting columns NOT NULL, sqls, 1-64

American National Standards Institute. See ANSI.,

AND logical operator, sqls, 1-853

ANSI, sqlt, 1-16

ANSI compliance,

-ansi flag, sqlr, 3-17, sqls, 1-214, 1-206, 1-291, Intro-14

checking for (DBANSIWARN), sqlr, 3-18

DBANSIWARN environment variable, sqlr, 3-17

icon, sqlr, Intro-10, sqls, Intro-12

Informix SQL solution, sqlt, 1-16

level, sqlr, Intro-16, sqls, Intro-21, sqlt, Intro-13

reserved words, sqls, 1-968

SQL statements, sqls, 1-19

SQLSTATE variable, sqls, 1-444

table naming, sqls, 1-572

updating rows, sqls, 1-782

ANSI-compliant database,

BEGIN WORK with, sqls, 1-92

CHARACTER VARYING data type, sqls, 1-863

constraint naming, sqls, 1-855

criteria for, sqls, 1-118

cursor in, sqls, 1-310, 1-311, 1-313

FOR UPDATE not required in, sqlt, 6-16

function naming, sqls, 1-1009, 1-964

index naming, sqls, 1-985

logging restrictions, sqlt, 9-40

opaque-type naming, sqls, 1-168

operator-class naming, sqls, 1-175

procedure name, sqls, 1-472, 1-583, 1-816

SQLNOTFOUND, sqls, 1-396

SQLWARN flag, sqlt, 5-12

synonym naming, sqls, 1-1047

table name with, sqls, 1-1049

table privileges, sqls, 1-221, sqlt, 11-8

USER function, sqls, 1-895

view naming, sqls, 1-1052

API.See Application programming interface (API).,

Application,

design of order-entry, sqlt, 4-27

handling errors, sqlt, 5-17

process, sqlr, Glossary-1

program, sqlr, Glossary-1

single-threaded, sqls, 1-687

thread-safe, sqls, 1-687, 1-690

Application programming interface (API), sqlr, Glossary-1

Arbitrary rule, sqls, 1-160

ARC_DEFAULT environment variable, sqlr, 3-16

ARC_KEYPAD environment variable, sqlr, 3-16

Archiving,

description of, sqlt, 4-31, 1-9

personal default qualifier file (ARC_DEFAULT), sqlr, 3-16

remote shell for (DBREMOTECMD), sqlr, 3-35

tctermcap file for (ARC_KEYPAD), sqlr, 3-16

Argument, sqlr, Glossary-1, sqls, 1-829 to

Arithmetic functions. See Algebraic functions.,

Arithmetic operator,

binary, sqls, 1-959

expression with, sqls, 1-959

SELECT with, sqlt, 2-45

unary, sqls, 1-960

Array,

definition of, sqlr, Glossary-2

moving rows into with FETCH, sqls, 1-418

Arrays, displaying. See Matrix patterns.,

ASCII code set, sqls, 1-1022

ASCII files, vis_ug, 10-4

ASIN function, sqls, 1-939

Assign support function, sqls, 1-793, 1-523, 1-503, 1-518, 1-172

ATAN function, sqls, 1-939

ATAN, ATAN2 functions, sqls, 1-939

ATAN2 function, sqls, 1-939

Attached index, sqlr, Glossary-2

Attribute,

identifying, sqlt, 8-17

important qualities of, sqlt, 8-17

nondecomposable, sqlt, 8-17

AUTOFREE feature, sqls, 1-677

Automatic type conversion. See Data type conversion.,

Auxiliary statements, sqlr, Glossary-2

AVG function, sqls, 1-953

AVI files, vis_ug, 10-4

Axes,

adding, vis_ug, 5-18

modifying alignment of, vis_ug, 5-19

modifying scaling for, vis_ug, 5-19

properties of, vis_ug, A-7

selecting, vis_ug, 5-19

Axis Selector bar, vis_ug, 5-19