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 ]

L

Label, sqlt, 3-43, 2-48

Labels on column charts, vis_ug, 5-21

LANG environment variable, instll32, 29

Language,

supported,

sysroutinelangs information, sqlr, 1-51

Language environment,

DBLANG, sqlr, 3-28

setting with DBLANG, sqlr, 3-28

Large object, sqlr, 2-16, sqls, 1-869, sqlt, 9-24 to

attaching tables, sqls, 1-36

character, sqlr, 2-38

constraints, sqls, 1-229

definition of, sqlr, Glossary-11

fragmentation with, sqls, 1-36

See also Simple large object ; Smart large object.,

Launching,

query wizards, vis_ug, 3-6

Visionary Viewer, vis_ug, 14-4 to

Layering. See Layers.,

Layers, vis_ug, 1-4

and event band charts, vis_ug, 5-5

and the threshold band symbol, vis_ug, 5-22

creating, vis_ug, 5-24, 5-26

description of, vis_ug, 5-24

example of, vis_ug, 2-5, 5-25

illustration of, vis_ug, 5-25, 5-27

layouts that allow, vis_ug, 5-25

order of drawing, vis_ug, 5-25

selecting objects to insert into, vis_ug, 5-27

Layout wizard, vis_ug, 5-10, 1-21

illustration of, vis_ug, 5-12

restrictions, vis_ug, 5-10

uses for, vis_ug, 5-9

Layouts,

about modifying, vis_ug, 5-18

and Visionary building blocks, vis_ug, 1-4

basic steps to creating, vis_ug, 5-9

categories of, vis_ug, 5-4

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

empty, vis_ug, 5-10

example of inserting, vis_ug, 5-10

example of modifying, vis_ug, 5-18

illustration of, vis_ug, 5-13

in scenes, vis_ug, 4-3

inserting, vis_ug, 5-9

introduction to, vis_ug, 5-3

list of empty, vis_ug, 5-16

modifying, vis_ug, 5-13, 5-14, 5-18

objects to insert into, vis_ug, 5-9

positioning, vis_ug, 5-9

selecting, vis_ug, 5-11

styles of, vis_ug, 5-5

that allow layers, vis_ug, 5-25

tools for creating, vis_ug, 5-9

typical properties of, vis_ug, 5-18

using multiple data sources in, vis_ug, 5-25

viewing finished, vis_ug, 5-12

Layouts panel, vis_ug, 1-12

LC_COLLATE environment variable, instll32, 29

LC_CTYPE environment variable, instll32, 30

LC_MONETARY environment variable, instll32, 30

LC_NUMERIC environment variable, instll32, 30

LC_TIME environment variable, instll32, 30

LENGTH field,

and TYPE field, sqls, 1-709

with DATETIME and INTERVAL types, sqls, 1-710

with DECIMAL and MONEY types, sqls, 1-710

with DESCRIBE, sqls, 1-709, 1-342

with SET DESCRIPTOR, sqls, 1-709

LENGTH function, sqls, 1-921, sqlt, 2-60

Length functions, sqls, 1-920

lessthan() operator function, sqls, 1-1020

lessthanorequal() operator function, sqls, 1-1020

LET statement, sqlt, 14-26

syntax, sqls, 2-39

Levels of detail,

about, vis_ug, 8-6

adding to a scene, vis_ug, 8-8

adding to data elements, vis_ug, 5-31

and navigation features, vis_ug, 1-7

and simple forms, vis_ug, 5-6

and Visionary building blocks, vis_ug, 1-4

default transition point for, vis_ug, 5-31

definition of, vis_ug, 8-3

example in data element, vis_ug, 5-31

example of, vis_ug, 2-5

illustration of, vis_ug, 8-7, 8-8

in a data element, vis_ug, 8-7

in object hierarchy, vis_ug, 7-8

modifying transitions in, vis_ug, 8-9

transition points, vis_ug, 8-9, 5-31

Library, sqlr, Glossary-11

shared, sqlr, Glossary-17, sqls, 1-922

like() operator function, sqls, 1-847

Line object properties, vis_ug, A-37

Linear maps,

description of, vis_ug, 5-7

properties of, vis_ug, A-38

uses of, vis_ug, 5-4

Link, sqlr, Glossary-11

Linking data to objects, vis_ug, 5-3

Links. See Connectors.,

LIST, sqlr, Glossary-11, sqlt, 10-18

LIST data type, sqlr, 2-51

deleting elements, sqls, 1-332

deleting elements from, sqls, 1-333, 1-329

selecting one element from, sqls, 1-614

syscolumns coltype code for, sqlr, 1-24

unloading, sqls, 1-770

updating elements, sqls, 1-791, 1-797, 1-798

updating elements in, sqls, 1-803

Literal, sqlr, Glossary-11

Collection, sqls, 1-990 to

expression with, sqls, 1-899

nested example, sqls, 1-993

quotation marks with, sqls, 1-993

syntax for non-collection elements, sqls, 1-991

DATETIME, sqls, 1-996 to

current date, sqls, 1-897

quoted string as, sqls, 1-1017

INSERT with, sqls, 1-501

INTERVAL, sqls, 1-999 to

expression with, sqls, 1-898

quoted string as, sqls, 1-1017

Number, sqls, 1-1002

expression with, sqls, 1-896

Row, sqls, 1-1004 to

expression with, sqls, 1-900

literal collection with, sqls, 1-993

nested row containing, sqls, 1-1007

Literal Collection segment, sqls, 1-990

Literal DATETIME segment, sqls, 1-996

Literal Row segment, sqls, 1-1004

LOAD FROM file, sqls, 1-517

LOAD statement, sqls, 1-515

DELIMITER clause, sqls, 1-523

format requirements, sqls, 1-517

INSERT INTO clause, sqls, 1-524

LOAD FROM file, sqls, 1-517

loading CHAR and VARCHAR data types, sqls, 1-520

loading CLOB or BLOB columns, sqls, 1-521

loading collections, sqls, 1-522

loading row types, sqls, 1-522

loading TEXT or BYTE columns, sqls, 1-521

opaque-type columns, sqls, 1-522

privileges, sqls, 1-516

specifying the table to load into, sqls, 1-524

Local Parameters folder, vis_ug, 7-5

Local variable, sqlr, Glossary-11

local variable,

defined, sqlt, 14-15

Locale, sqlr, Intro-5, sqls, Intro-6, sqlt, 1-17, Intro-6

Location,

modifying, vis_ug, 7-10

using functions to specify, vis_ug, 7-14

Lock, sqlr, Glossary-12

database, sqlt, 7-8

exclusive, sqls, 1-239, sqlt, 7-10, 7-7

granularity, sqlt, 7-7

key, sqlt, 7-9

page, sqls, 1-254, sqlt, 7-9

promotable, sqls, 1-312, sqlt, 7-10, 7-7

row, sqls, 1-254, sqlt, 7-9

scope of, sqlt, 7-7

setting with SET LOCK MODE, sqls, 1-728

shared lock, sqlt, 7-7

table,

changing mode, sqls, 1-88

creating with ALTER INDEX, sqls, 1-53

explicit, sqlt, 7-9

implicit, sqlt, 7-8

LOCK TABLE statement, sqls, 1-525

unlocking, sqls, 1-777

update, sqls, 1-783

Lock mode, sqlr, Glossary-12

altering with ALTER TABLE, sqls, 1-88

setting, sqlt, 7-9

LOCK TABLE statement, sqlt, 7-9

reversing with UNLOCK TABLE, sqls, 1-777

with transactions, sqls, 1-526

without transactions, sqls, 1-527

Locking, sqlr, Glossary-12

and concurrency, sqlt, 4-32

and integrity, sqlt, 7-3

cursors, effect on, sqls, 1-312

deadlock, sqlt, 7-19

default table locking, sqls, 1-254

DELETE statement with, sqlt, 6-4

description of, sqlt, 7-6

during,

delete, sqls, 1-328

updates, sqls, 1-783

FETCH statement and, sqls, 1-421

lock duration, sqlt, 7-10

lock mode, sqlt, 7-18

not wait, sqlt, 7-18

wait, sqlt, 7-18

locks released at end of transaction, sqlt, 7-23

modifying data with, sqlt, 7-10

overriding row-level, sqls, 1-526

releasing with COMMIT WORK, sqls, 1-99

releasing with ROLLBACK WORK, sqls, 1-594

SET ISOLATION with, sqls, 1-722

setting lock mode, sqlt, 7-18

transactions with, sqls, 1-91

types of locks,

database lock, sqlt, 7-8

waiting period, sqls, 1-729

Locking granularity, sqlr, Glossary-12

LOCOPY function, sqlr, 2-38, 2-33, sqls, 1-930

LOD objects. See Levels of detail.,

LOG10 function, sqls, 1-919

Logarithmic functions, sqls, 1-918

Logging,

ANSI-compliant database with, sqls, 1-119

buffered, sqlt, 9-40

buffered versus unbuffered, sqls, 1-731

buffered,

changing to with SET BUFFERED LOG, sqls, 1-731

setting with CREATE DATABASE, sqls, 1-119

cascading deletes, sqls, 1-240

database creation, sqls, 1-119

types of, sqlt, 9-39

unbuffered, sqlt, 9-39

unbuffered,

changing to with SET LOG, sqls, 1-731

with triggers, sqls, 1-285

Logical log, sqlt, 4-31

Logical operator,

AND, sqls, 1-853

condition with, sqls, 1-853

NOT, sqls, 1-837

OR, sqls, 1-853

unknown values, sqls, 1-854, 1-837

Logical operators in SQL queries, vis_ug, 3-26

LOGN function, sqls, 1-919

Lohandles support function, sqls, 1-173

.lok extension, sqls, 1-729

.lok file extension, sqls, 1-729

Loop,

exiting with RAISE exception, sqlt, 14-88

indefinite with WHILE, sqls, 2-61

LOTOFILE function, sqlr, 2-38, 2-33, sqls, 1-928

LVARCHAR, sqlr, Glossary-12

LVARCHAR data type, sqls, 1-862, 1-863, sqlt, 9-22

greater than condition, sqls, 1-1020

in INSERT, sqls, 1-502