Index

A B C D E F G H I J K L M N O P Q R S T U V W Y Z

Symbols

$AGGMAP property, 6

$AGGREGATE_FROM property, 6

$AGGREGATE_FROMVAR property, 6

$ALLOCMAP property, 6

$COUNTVAR property, 6

$NATRIGGER property

calling recursively

executing simultaneously, 24

$STORETRIGGERVAL property, 6

$VARCACHE property, 6

% wildcard, 3.6.6.1

& operator, 3.8

= command, 21

event, 24, 24, 24

introduced, 2.2

trigger, 24, 24, 24

with QDR, 3.10.3.2

_ wildcard, 3.6.6.1

A

ABS function, 3.6.3.1, 6

accessing

algorithm for composite values, 21

ACQUIRE command, 6

ACROSS command, 6

ACROSS keyword, 21

$AGGREGATE_FROM property, 6, 6

$AGGREGATE_FROMVAR property, 6, 6

= command, 21

FETCH command, 12

FILEREAD command, 13, 22

FILEVIEW command, 13

HEADING command, 14

models, 4.4.5

REPORT command, 20

ROW command, 21

SQL FETCH command, 22

SQL SELECT command, 22

ADD_MONTHS command, 6

adding

definition components, 9

description to a definition, 15, A.15.5

values to partitions, 16

AGGINDEX statement, 6

AGGMAP ADD model command, 6

AGGMAP command, 6

aggmap objects

defining, 10

deleting, 10, 10, 10, 10

AGGMAP property

See $AGGMAP property

AGGMAP REMOVE model command, 6

AGGMAP SET command, 6

AGGMAPINFO command, 7

aggmaps

compiling, 9

defining, 10

models in, 6

AGGREGATE command, 7

introduced, 4.2.1, 4.3.1

AGGREGATE function, 7

introduced, 4.2.1

AGGREGATE_FROM property

See $AGGREGATE_FROM property

AGGREGATE_FROMVAR property

See $AGGREGATE_FROMVAR property

aggregating data

best practice, 4.2.2

between time dimensions, 23

caching, 24

embedded total dimension, 21

formulas to, 7

on-the-fly, 4.2.2, 4.2.2

partitioned variables, 7, 19

precomputing, 4.2.2, 4.2.2

specifying a relation for, 6

AGGREGATION function, 7

aggregation functions, A.7.5

NA values in, 3.9.2.2

aggregation specifications

deleting, 10

alias

analytic workspace

alias dimensions

defining, 10

deleting, 10, 10, 10, 10

limiting, 10

maintaining, 10

populating, 10

aliases

for analytic workspace, 3.2.1

for dimensions, 10

workspace See workspace alias

ALLCOMPILE program, 7

ALLOCATE command, 7

allocating data, 23

between time dimensions, 23

list of related commands, 4.3.1

specifying allocation path, 7

allocation specifications

deleting, 10

ALLOCERRLOGFORMAT option, 7

ALLOCERRLOGHEADER option, 7

ALLOCMAP command, 7

ALLOCMAP property

See $ALLOCMAP property

ALLSTAT command, 7

alphabetic characters

converting, 24

ampersand &(amp;) operator, 3.8

ampersand substitution

avoiding, 3.8

example of, 3.8

prevents compiling, 5.2.2

program arguments and, 5.1.1.2.3

QDR with, 3.10.3.6

using to pass arguments, 5.1.1.2.3, 16

analytic workspace

partitioning, 8

analytic workspace objects

defining, 10

analytic workspaces

alias, 3.2.1

aliases, 8

content summary, displaying, 8

current, 3.2.1

current workspace, 3.2.1

deleting objects, 10

exclusive, 8

exporting, 1.4.6

importing, 1.4.6

name, 3.2.1

objects, defining in a program, 5.2.2

obtaining information about, 8

permission programs, 1.4.1, 8, 19

read-only, 8

read/write, 8

sharing, 8

starting, 8

startup programs, 19

statements for managing, 1.3.1, 1.3.1

updating, 24

waiting to attach, 8

analytic workspaces alias

creating, 8

AND operator, 2.2.2, 2.2.2, 2.2.2

ANTILOG function, 7

ANTILOG10 function, 7

ANY function, 7

arc tangent calculation, 8

ARCCOS function, 7

ARCSIN function, 8

ARCTAN function, 8

ARCTAN2 function, 8

ARG command

See ARGUMENT command

ARG function, 8

ARGCOUNT function, 8

ARGFR function, 8

ARGS function, 8

ARGUMENT command

abbreviation for, 8

placement of, 5.1.1.2

use of, 5.1.1.2

using multiple, 5.1.1.2.1

arguments, 8

in user-defined functions, 5.1.1.1

passing as text, 5.1.1.2.3, 16

passing to a program, 8, 8, 8, 8, 8, 8

using ampersand substitution with, 5.1.1.2.3

arithmetic expressions

See arithmetic operators, numeric expressions

ASCII function, 8

Assign event, 24

assigning values

OLAP DML statements, A.3

SET1, 21

assignment operator

See = command

assignment statement, 21, 21

event, 24, 24, 24

trigger, 24, 24, 24

with QDR, 3.10.3.2

assignment statements

SET1, 21

authentication, 19

encrypting text expressions, 19

within Oracle OLAP, 19

average

calculating, 8

moving, 18

AVERAGE function, 8

AW ALIASLIST command, 8

AW ALLOCATE command, 8

AW ATTACH command, 8

AW command, 8

events, 24

triggers, 24

AW CREATE command, 8

AW DELETE command, 8

AW DETACH command, 8

AW function, 8

AW LIST command, 8

AW SEGMENTSIZE command, 8

AWDESCRIBE program, 8

AWWAITTIME option, 8

B

BACK function, 8

BADLINE option, 5.3.3, 8

base dimensions

finding values of, 15

BASEDIM function, 8

BASEVAL function, 8

batch windows

for aggregation, 4.2.2, 4.2.2

BEGINDATE, 8

BITAND function, 8

bits, adding, 8

BLANK command, 8

blank lines in reports, 8

blanks, 8

stripping from text values, 8

BLANKSTRIP function, 8

BMARGIN option, 8

Boolean constants, 2.1.3, 3.6

Boolean data type, 2.1.3

Boolean expressions

creating, 3.6.1

defined, 3.6

example of, 3.6.1

involving NA values, 3.6.2

operators, 2.2.2, 2.2.2

values, 3.6

Boolean operators

evaluation order, 2.2.2, 2.2.2

table of, 2.2.2, 2.2.2

Boolean values, 18

spelling of false values, 18

spelling of true values, 24

branching in programs, 8, 9, 14, 14, 16, 23

BREAK command, 8

used with SWITCH, 23

bucket numbers

retrieving, 24

build number, 11

byte manipulation functions, 8, 12, 13, 15, 15, 17, 18, 20, 20

bytes, 13

finding location in text expression, 13

functions for, A.5.1, A.5.2, A.5.3

C

CACHE command, 4.2.2, 24

CACHE statement, 6, 6, 6, 6, 6, 6

caches

See OLAP session cache

calculated members

adding to dimension, 16

calculating a linear regression, 12, 20

calculation on-the-fly

typical strategy, 6

calculations

controlling errors during, 3.4.7

CALENDARWEEK option, 8

CALL command, 8

CALLTYPE function, 8, A.15.5

capitalizing strings, 15

carriage return (escape sequence), 2.1.2.2

case conversion

alphabetic characters, 24

case statement in programs, 23

CATEGORIZE function, 8

CDA command, 8

CEIL function, 8

CHANGEBYTES function, 8

CHANGECHARS function, 8

changes

dropping, 21, 21

changing, 9

definition components, 9

name of an object, 20

character values, 8

stripping blank spaces from, 8

characters

capitalizing, 15

converting to uppercase, 24

finding location in text expression, 13

functions for, A.5.1, A.5.2, A.5.3

representing as decimals, 2.1.2.2

representing as hexadecimals, 2.1.2.2

representing as Unicode, 2.1.2.2

retrieving decimal representation, 8

CHARLIST function, 8

CHGDFN command, 9

CHGDIMS function, 9

CHILDLOCK statement, 7

CLEANUP command

See SQL CLEANUP command

CLEAR command, 9

CLOSE command

See SQL CLOSE command

COALESCE function, 9

columns

default width in reports, 9, 15

getting value from a report column, 9

headings in a report, 14

in reports, 9

multiline text, 15, 15, 20, 20

COLVAL function, 9

COLWIDTH function, 9

command sequence

accessing previously executed commands, 20

executing previously executed commands, 20

COMMAS option, 9

in numeric output, 9

comments in programs, 5.1.1

COMMIT command, 9

comparing text data, 15, 16

comparison operators, 2.2.2

compilable objects, 9

creating a cross-reference list for, 19

COMPILE command, 9

example of, 9

in models, 4.4.2

introduction to, 5.2

COMPILEMESSAGE option, 9

COMPILEWARN option, 9

compiling, 9, 9

aggmaps, 9

SQL statements

suppressing error messages, 9

composite values

deleting values of, 16

composites

as output host variables

base dimension values, 15

changing to conjoint dimensions, 9

defining, 10, 10

deleting, 10, 10, 10

index algorithm, 21

limiting dimensions used by, 3.2.4

looping over, 6

maintaining, 16

reporting, 20, 21

rolling up data, 21

showing a value, 21

statements for managing, A.12

testing for a value, 15

unnamed, 10

using commands with, 3.2.4

composities

deleting, 10

computing, 15

internal rate of return, 15

net present value, 18

concat dimensions

defining, 10

deleting, 10, 10

concat partitions, 10

conditional expressions, 3.7, 3.7

conditional operators

defined, 3.7

example of, 3.7

conjoint dimensions

as output host variable

base dimension values, 15

changing to composites, 9

defining, 10

deleting, 10, 10

conjoints

defining, 10

CONSIDER command, 9

CONTEXT command, 5.1.2.6, 9

CONTEXT function, 5.1.2.6, 9

CONTINUE command, 9

controlled sparsity

defined, 10

CONVERT function, 3.1.2, 9

converting

alphabetic characters, 24

data between time dimensions, 23

decimal numbers to integers, 15

values from one data type to another, 9

COPYDFN command, 9

copying definitions, 9

CORRELATION function, 9

COS function, 9

COSH function, 9

cosine calculation, 9

hyperbolic, 9

cost

of program lines, 18

of programs, 23

performance, 18

COUNT function, 9

counting, 18

lines in a text expression, 18

number of true values, 9

COUNTVAR property

See $COUNTVAR property

cross reference for workspace, 19

CUMSUM function, 9

cumulative totals, 9, 21

current

analytic workspace, defined, 3.2.1

status See current status

current analytic workspace

defined, 3.2.1

current directory

defined, 18, 19

current outfile, 11, 19

current status, 15

checking for a dimension value, 15

current status list

defined, 3.10.1

cursors

closing (SQL)

defining (SQL)

importing (SQL)

D

data fetches (SQL)

data types, 23, 23, 23

converting, 3.1.2, 9, 23, 23, 23, A.2

creating a report, 20, 21

date, 2.1.4

determining data type of an object, 19

for variables, 10

numeric, 2.1.1

of expressions, 3.1.1

of numeric expressions, 3.4, 3.4.2

of user-defined function, 5.1.1.1

qualifying data for expressions, 19

restricting access, 19

showing a single value, 21

statements for converting, A.2

text, 2.1.2

transferring from one format to another, 24

data values

accessing variable, 3.2.3

numeric, 3.4

DATABASE command

name change

See AW command

DATABASE function

name change

See AW function

date and time

functions, A.6

date conversion, 23, 23

DATE data type, 2.1.4

DATEFORMAT option, 9

DATEORDER option, 9

dates, 23, 23

comparing with times, 3.6.5

current, 23, 23

functions, A.6

in arithmetic expressions, 3.4.5

in text expressions, 3.5.1

DATETIME data type, 2.1.4, 3.5.1

DAYABBRLEN option, 9

DAYNAMES option, 9

DAYOF function, 9

DBDESCRIBE program

name change

See AWDESCRIBE program

DBGOUTFILE command, 5.3.4, 9

and ECHOPROMPT, 11

DBWAITTIME

See AWWAITTIME option

DBWAITTIME option

name change

DDOF function, 9

DEADLOCK statement, 7

debugging, 8, 9, 11, 12, 17, 17, 19

statements for, A.15.4

debugging programs, 5.3

decimal

marker, 10

places, 10

places (displayed), 10

DECIMAL data type, 2.1.1, 3.6.3.3

decimal data types, comparing, 3.6.3.3

decimal values, 10

decimal marker for output, 10

truncating to an integer, 15

DECIMALCHAR option, 10

DECIMALOVERFLOW option, 3.4.7, 10

DECIMALS option, 3.6.3, 3.6.3.1, 10

DECLARE CURSOR command

See SQL DECLARE CURSOR command

DECODE function, 10

default outfile, 11, 19

default status list

defined, 3.10.1

DEFAULTAWSEGSIZE option, 10

DEFAULTDBFSIZE

See DEFAULTAWSEGSIZE option

DEFAULTDBFSIZE option

name change

DEFINE AGGMAP command, 10, 10

DEFINE command, 10

events, 24

triggers, 24

DEFINE COMPOSITE command, 10

DEFINE DIMENSION ALIASOF command, 10

DEFINE DIMENSION command, 10

DEFINE FORMULA command, 10

DEFINE MODEL command, 10

DEFINE PARTITION TEMPLATE command, 10

DEFINE PROGRAM command, 10

DEFINE RELATION command, 10

DEFINE SURROGATE command, 10, 10

DEFINE VALUESET command, 10

DEFINE VARIABLE command, 10

DEFINE WORKSHEET command

defining

aggmap objects, 10

alias dimensions, 10

analytic workspace objects, 10

dimension alias, 10

dimensions, 10

formulas, 10

partitions, 10

programs, 10

relations, 10

surrogates, 10

valuesets, 10, 10

variables, 10

worksheet objects, 10

definitions, 9

changing components, 9

copying, 9

creating, 10

creating object properties, 19

deleting, 10

listing of, 19

moving within NAME dimension, 18

report of, 11, 13

testing for, 11

DELETE command, 10

event, 24, 24

trigger, 24, 24

Delete event, 24

deleting, 15, A.15.5

aggmap objects, 10

alias dimensions, 10

composite values, 16

composites, 10

definitions, 10

description from a definition, 15, A.15.5

dimension alias, 10

dimension values, 16, 16

dimensions, 10

formulas, 10

models, 10

partition templates, 10

partitions, 10

programs, 10

surrogates, 10

triggers, 24, 24, 24

valuesets, 10

variables

deleting, 10

DEPRDECL function, 11

DEPRDECLSW function, 11

depreciation of assets, 11, 11, 11, 11

DEPRSL function, 11

DEPRSOYD function, 11

DESCRIBE command, 11

descriptions, 15, A.15.5

adding to a definition, 15, A.15.5

DIF files, 14

importing data from, 14

dimension alias

defining, 10

deleting, 10, 10

DIMENSION command, 17

in a model, 17

DIMENSION statement

for aggregation, 6

for allocation, 7

dimension status

effect on expressions, 3.3.2

of dimensions used by composites, 3.2.4

restoring, 3.10.1.2, 5.1.2.2

restoring current, 3.10.1.2

saving current, 3.10.1.2

saving current status, 3.10.1.2, 5.1.2.2

status for managing, A.12

dimension surrogates

assigning values to, 21

dimension value

checking current status list, 22, 22, 22, 22

checking if in status, 15

checking status for a value, 15

counting related values, 23

listing associated objects, 16

listing values, 24

null values, 19

saving the status in a context, 9

sorting the status list, 16, 21

testing for a value, 15

using qualified data reference, 19

using result of LIMIT command, 16

dimension values

checking if in status, 15

comparing, 3.6.4

counting related values, 23

deleting values of, 16, 16

latest value, 22

number of values in status, 22

retrieving current status list, 22

returning first value in status, 22

returning last value in status, 22

setting the status of, 16

dimensionality

changing in an expression, 9

dimension-based equations, 4.4

dimensions

checking status of, 22

comparing values, 3.6.4

defining, 10, 10

defining surrogates for, 10

deleting, 10, 10

in expressions, 3.2

limiting to single value, 3.10.3

looping over values of, 13, 13, 13

maintaining, 16

numeric value of text dimension, 3.4.4

of expression, 3.3, 3.3.1

order in models, 17

QDR with, 3.10.3, 3.10.3.5

restoring previous values, 5.1.2.3

saving current values, 5.1.2.3

See also alias dimensions, concat dimensions, conjoint dimensions, simple dimensions

statements for managing, A.12

directories

current, 18, 19

DIVIDEBYZERO option, 3.4.7, 11

division, 20

by zero, 11

calculating the remainder, 20

DO command, 11, 13

used with FOR, 13

used with SWITCH, 23

used with WHILE, 24

DOEND command, 11

double quotes (escape sequence), 2.1.2.2

DSECONDS option, 11

E

ECHOPROMPT option, 5.3.4, 11

EDIT command, 11

editing, 20

previously executed commands, 20

EIF file, 1.4.6, 12

exporting data from, 12

importing data from, 14

EIFBYTES option, 11

EIFEXTENSIONPATH option, 11

EIFNAMES option, 11

EIFSHORTNAMES option, 11

EIFTYPES option, 11

EIFUPDBYTES option, 11

EIFVERSION option, 11

embedded totals, 21

encryption, 19

END command, 11

ENDDATE function, 11

ENDOF function, 11

EQ command, 11

EQ operator, 2.2.2, 2.2.2, 2.2.2

equations

dimension-based, 4.4

ERRNAMES option, 11

error messages, 21

creating your own, 5.1.3.3

deferring, 5.1.3.1

finding line causing, 8

option holding text of, 11

output destination of, 11

producing without error condition, 21

signaling error condition, 21

suppressing, 5.1.3.2, 9

suppressing during compilation, 9

ERRORLOG statement, 7

ERRORMASK statement, 7

ERRORNAME option, 5.1.3, 11, 21

with SIGNAL, 21

errors

controlling during calculations, 3.4.7

handling, 5.1.3

handling in nested programs, 24, 24

handling in programs, 24

name of first-occurring error, 11

recording line causing, 8

signaling, 5.1.3.3, 24, 24

when comparing numeric data, 3.6.3, 3.6.3.2, 3.6.3.3

ERRORTEXT option, 5.1.3, 11, 21

used with SIGNAL, 21

escape character for LIKE, 15

ESCAPEBASE option, 11

events

Assign, 24, 24

assignment statements, 24

Define, 24

Delete, 24, 24

deleting, 24, 24, 24

identifying, 24

Maintain, 24, 24

Property, 24, 24

Update, 24, 24, 24

EVERSION function, 11

EVERY function, 11

EXISTS function, 11

EXP function, 11

exponential forecasting, 12, 13

exponents

retrieving, 11

EXPORT command, 1.4.6, 12

EXPORT to EIF command, 12

EXPORT to spreadsheet command, 12

exporting data, 11

tracking number of bytes, 11

expressions, 15

ampersand substitution, 3.8

Boolean, 2.2.2, 3.6, 3.7, 3.7

changing dimensionality of, 9

comparing, 18

conditional, 3.7, 3.7

data type of, 3.1.1

dates in, 3.4.5

defined, 3.1

dimensions in, 3.2

dimensions of, 3.3, 3.3.1

formulas in, 3.2

functions in, 3.2

numeric, 3.4

objects in, 3.2

operators, 2.2.2

padding, 16, 21

parsing, 15, 19

relations in, 3.2

retrieving largest, 14

retrieving smallest, 15

saving, 10

substitution, 3.8

text, 3.5

trimming, 16, 21

using qualified data references in, 19

using text dimension in numeric expression, 3.4.4

valuesets in, 3.2

variables in, 3.2

EXPTRACE option, 12

EXTBYTES function, 12

EXTCHARS function, 12

EXTCOLS function, 12

external partitions, 9

EXTLINES function, 12

F

fastest-varying dimension, 10

FCCLOSE command, 12

FCEXEC command, 12

FCOPEN command, 12

FCQUERY command, 12

FCSET command, 12

FETCH command

See also SQL FETCH command

fetching data (SQL)

file I/O, 12, 12, 13, 13, 13, 13, 13

closing, 12, 12, 12

diagnosing errors when processing, 12

forcing a page break, 13

gathering information about, 13

list of open files, 16

opening, 13

processing data from, 13

reading a record, 13

reading data from, 13

reading Oracle OLAP commands from a file, 14, 15

records read, 20

setting attributes, 13

writing, 13

FILECLOSE command, 12

FILECOPY command, 12

FILEDELETE command, 12

FILEERROR function, 12

FILEGET function, 12

FILEMOVE command, 12

FILENEXT function, 13

FILEOPEN function, 13

FILEPAGE command, 13

FILEPUT command, 13

FILEQUERY function, 13

FILEREAD command, 13

files

appending output, 19

saving output in, 19

FILESET command, 13

fileunits, 13, 13

attributes, 13

number of outfile destination, 19

opening, 13, 19

reading data from, 13

setting attributes, 13

FILEVIEW command, 13

FILTERLINES function, 13

financial analysis, scenario modeling, 4.4.1.6

financial functions, A.7.2

FINDBYTES function, 13

FINDCHARS function, 13

FINDLINES function, 13

FINTSCHED function, 13

floating point numbers, comparing, 3.6.3.2

floating-point format

limitations when calculating, 3.4.6

use of, 3.4.6

FLOOR function, 13

FOR command, 13

breaking out of, 8

example of, 13

looping over dimension values, 13, 13, 13

used with BREAK, 8

used with CONTINUE, 9

used with DO and DOEND, 11

used with OKFORLIMIT, 19

used with TEMPSTAT, 23

FORECAST command, 13

forecast statements, A.8.1

forecasting, 15

forecasting context, 12

closing, 12

executing, 12

obtaining information from, 15

opening, 12

querying, 12

setting characteristics of, 12, 12

FORECAST.REPORT program, 13

forecasts

using forecasting context, A.8.2

form feed (escape sequence), 2.1.2.2

format

importing data from other formats, 14

formats, 14

formulas

aggregating data with, 7

compiling, 9, 9

defining, 10, 10

deleting, 10, 10

recursive

specifying new expression, 11

statements used for, A.13

formulas in expressions, 3.2

FPMTSCHED function, 13

FULLDSC program, 13

functions

calling, 8

in expressions, 3.2

user-defined, 5.1.1.1, 5.1.1.1, 5.4, 8, 21

G

GE operator, 2.2.2, 2.2.2, 2.2.2

GET function, 14

GOTO command, 14

GREATEST function, 14

group marker, 23

GROUPINGID command, 14

GROWRATE function, 14

growth rate, 14

GT operator, 2.2.2, 2.2.2, 2.2.2

H

handling errors in programs, 24

hash partitions

defining for analytic workspace, 8

heading, 14

for a report, 14

for output pages, 19

including a page number, 19

producing standard report heading, 23

HEADING command, 14

HIDE command, 14

HIERCHECK program, 14

HIERCHK.LOOPFND variable, 14

HIERCHK.LOOPVALS variable, 14

HIERCHK.XTRADIMS variable, 14

HIERHEIGHT command, 14

HIERHEIGHT function, 14

Holt-Winters forecasting, 12, 13

horizontal tab (escape sequence), 2.1.2.2

hyperbolic cosine calculation, 9

hyperbolic sine calculation, 21

hyperbolic tangent calculation, 23

I

ID data type, 2.1.2

IF command, 14

used with DO and DOEND, 11

IFNONE keyword, 16

IMPORT command, 1.4.6, 14

See also SQL IMPORT command

IMPORT from EIF command, 14

IMPORT from spreadsheet, 14

IMPORT from text command, 14

importing data, 11

controlling update frequency, 11

tracking names of objects, 11

tracking number of bytes, 11

tracking types of objects, 11

IN operator, 2.2.2, 2.2.2, 2.2.2

INCLUDE command, 17, 17

index algorithm, 21

INF_STOP_ON_ERROR option, 15, 15

INFILE command, 15

INFO (FORECAST) function, 15

INFO (MODEL) function, 15

INFO (PARSE) function, 15

INFO (REGRESS) function, 15

INFO function, 15

determining dimensionality with, 3.3.1

DIMENSION keyword, 3.3.1

INITCAP function, 15

INLIST function, 15

in-place variable, 9

input, 14

input file, 9

debugging, 9

finding line causing error, 8

reading from a file, 14, 15

with SNAPI connection, 14

with XCA dialog, 14

INSBYTES function, 15

INSCHARS function, 15

INSCOLS function, 15

INSLINES function, 15

INSTAT function, 15

INSTR function, 15

INSTRB function, 15

INTEGER data type, 2.1.1

integer part of decimal number, 15

interest on loans, 13, 24

internal partitions, 10

internal rate of return, 15

international support, 10

number format, 10, 23

INTPART function, 15

IRR function, 15

ISDATE program, 15

ISVALUE function, 15

J

JOINBYTES function, 15

JOINCHARS function, 15

JOINCOLS function, 15

joining

columns of text, 15

text columns, 15

JOINLINES function, 15

K

KEY function, 15

L

label column width, 15

branching in a program, 14

for error handling in programs, 24

labels, 14

in programs, 5.1.3.5

with IFNONE, 16

LAG function, 3.4.5, 4.4.1.3, 15

LAGABSPCT function, 15

LAGDIF function, 15

LAGPCT function, 15

larger value of two expressions, 16

LARGEST function, 15

largest value of an expression, 15

LAST_DAY function, 15

LCOLWIDTH option, 15

LD command, 15, A.15.5

LE operator, 2.2.2, 2.2.2, 2.2.2

LEAD function, 3.4.5, 4.4.1.3, 15

LEAST function, 15

LIKE operator, 2.2.2, 2.2.2, 2.2.2, 3.6.6.1, 15, 15, 16

LIKECASE option, 15

LIKEESCAPE option, 15

LIKENL option, 16

LIMIT command, 16

using LEVELREL, 16

using NOCONVERT, 16

using parent relation, 16

using POSLIST, 16

using related dimension, 16

using values, 16

with variables with composite, 3.2.4

LIMIT function, 16

limiting

alias dimensions, 10

multidimensional valuesets, 10

LIMITMAPINFO function, 16

LIMIT.SORTREL option, 16

line size for report heading, 16

linefeed (escape sequence), 2.1.2.2

LINENUM option, 16

lines on a page of report output, 19

LINESLEFT option, 16

LISTBY program, 16

LISTFILES command, 16

LISTNAMES program, 16

literals

numeric, 2.1.1

text, 3.5

LOAD command, 16

loading, 21

algorithm for composite values, 21

loans, 13

interest payment on, 13

interest payments on, 24

payment on, 13

payments on, 24

local variables, 24, 24

localization options, 1.2.1.1, 18

LOG command, 16

LOG function, 16

LOG10 function, 16

logical operators, 2.2.2

logs

calculating base 10 logarithm, 16

calculating natural logarithm, 16

LONGINTEGER data type, 2.1.1

LOOP clause

in SQL FETCH command, 22

looping, 13

over dimension status, 13

statements, 5.1.1.3.1

LOWCASE function, 16

lowercase

converting to, 16

LPAD function, 16

LSIZE option, 16

LT operator, 2.2.2, 2.2.2, 2.2.2

LTRIM function, 16

M

MAINTAIN command

event, 24, 24

MAINTAIN ADD, 16

MAINTAIN ADD for DAY, WEEK, MONTH, QUARTER and YEAR values, 16

MAINTAIN ADD for TEXT, ID, and INTEGER values, 16

MAINTAIN ADD SESSION, 16

MAINTAIN DELETE, 16, 16, 16

MAINTAIN MERGE, 16

MAINTAIN MOVE, 16

MAINTAIN RENAME, 16

trigger, 24, 24

Maintain event, 24

maintaining

alias dimensions, 10

composites, 16

dimensions, 16

partition templates, 16

partitions, 16

MAKEDATE function, 16

margins, 8

setting bottom margin, 8

setting top margin, 23

MAX function, 16

MAXBYTES function, 17

MAXCHARS function, 17

MAXFETCH option, 17

maximum values, 18

for each time period in the status, 18

larger of two expressions, 16

MEASUREDIM statement

for aggregation, 6

for allocation, 7

MEDIAN function, 17

median value, 17

messages, error

suppressing, 9

MIN function, 17

minimum value, 18

for each time period in the status, 18

smaller of two expressions, 17

MMOF function, 17

MODDAMP option, 17

MODE function, 17

models

adding to aggmap, 6

compiling, 4.4.2, 17

creating, 17

defined, 4.4

defining, 10

deleting, 10

editing, 17

in aggmap objects, 6

removing from aggmap, 6, 6

running, 4.4.3, 17

scenario, 4.4.1.6

solution variables, 4.4

types of solution blocks, 4.4.2.1

MODEL.XEQRPT program

compiling, 9, 9

debugging, 9, 17, 17

defining, 10, 10

finding line causing error, 8

including, 17

nesting, 17

obtaining information about, 15

options, 17, 17, 17, 17, 17, 17, 17, 17, 17

MODERROR option, 17

MODGAMMA option, 17

MODINPUTORDER option, 17

MODMAXITERS option, 17

MODOVERFLOW option, 17

MODSIMULTYPE option, 17

MODTOLERANCE option, 17

MODTRACE option, 17

module version numbers, 11

MONITOR command, 18

monitoring, 18

cost of program lines, 18

cost of programs, 23

MONTHABBRLEN option, 18

MONTHNAMES option, 18

MONTHS_BETWEEN function, 18

MOVE command, 18

MOVINGAVERAGE function, 18

MOVINGMAX function, 18

MOVINGMIN function, 18

MOVINGTOTAL function, 18

multidimensional valuesets, 10

multiline text

columns, 15, 15, 20, 20

multiline text values, 18

counting lines in, 18

deleting duplicate lines, 24

extracting lines from, 12

filtering lines in, 13

finding lines, 13

inserting lines into, 15

joining, 15

removing lines from, 20

replacing lines in, 20

sorting lines in, 21, 24

testing whether found, 15

MULTIPATHHIER option, 18

N

NA values, 3.9, 18

accepted as numeric input, 18, 18

caching, 24

comparing, 3.6.2

controlling how treated, 3.9.2, 3.9.2

in aggregation functions, 3.9.2.2, 3.9.2.2

in arithmetic operations

in Boolean expression, 3.6.2

permanently replacing, 24

replacing, 18

replacing with strings, 18

retrieving, 9

spelling of, 18

statements for working with, A.4

substituting another value, 18

substituting another value for, 3.9.2.4

triggers, 24, 24

NAFILL function, 3.9.2, 3.9.2, 3.9.2.4, 18

name, 18

changing object name, 20

dimension, 18

listing names of dictionary entries, 18

NAME dimension, 18

names

listing for objects, 16

listing objects by, 16

qualified object, 3.2.1

NASKIP option, 3.9.2, 3.9.2, 3.9.2.2, 18

NASKIP2 option, 3.9.2, 3.9.2, 18

NASPELL option, 8, 18

NATRIGGER

See $NATRIGGER

NATRIGGER property

See $NATRIGGER property

natural logarithm, 16

NE operator, 2.2.2, 2.2.2, 2.2.2

negative value, 19

in output, 19

obtaining the root, 21

net present value, 18

NEW_TIME function, 18

NEXT_DAY function, 18

NLS options, 1.2.1.1

NLS_CALENDAR option, 18

NLS_CURRENCY option, 18

NLS_DATE_FORMAT option, 18

NLS_DATE_LANGUAGE option, 18

NLS_DUAL_CURRENCY option, 18

NLS_ISO_CURRENCY option, 18

NLS_LANG option, 18

NLS_LANGUAGE option, 18

NLS_NUMERIC_CHARACTERS option, 18

NLS_SORT option, 3.6.6, 18

NLS_TERRITORY option, 18

NONE function, 18

NORMAL function, 18

NOSPELL option, 2.1.3, 18

NOT operator, 2.2.2, 2.2.2, 2.2.2

NPV function, 18

NTEXT data type, 2.1.2

null, 19

status lists and valuesets, 19

null values

See NA values

NULLIF function, 18

number conversion, 23, 23

numbers

assigning random numbers, 20

commas in output, 9

decimal marker for output, 10

decimal places in output, 10

determining sign of, 21

negative values in output, 19

rounding, 21

thousands marker for output, 23

NUMBYTES function, 18

NUMCHARS function, 18

numeric data types

comparing, 3.6.3, 3.6.3.3

list of, 2.1.1

mixing, 3.4.2

numeric expressions

data type of the result, 3.4, 3.4.2

dates in, 3.4.5

defined, 3.4

mixing data types in, 3.4.2

NA values in

numeric functions, A.7

numeric options, A.7

numeric values

rounding, 21

NUMLINES function, 18

NVL function, 18

NVL2 function, 18

O

OBJ function, 19

object definitions

statements for manipulating, A.11

objects, 3.2, 9

assigning values to, 2.2

compiling, 9

creating by copying, 9

creating properties, 19

defining, 10

deleting, 10

describing its definition, 11

describing its properties, 13

dropping changes, 21, 21

exporting from analytic workspace, 12

identifying triggers, 24

importing into analytic workspace, 14

listing, 19

listing names of, 16, 16, 18

loading, 16

making current, 9

obtaining information, 19

qualified name, 3.2.1

recalculating permissions, 19

renaming, 20

restrictions on name, 10

statements for defining, A.11

statements for deleting, A.11

testing for existence, 11

OBJLIST function, 19

OBSCURE function, 19

obtaining, 15

FORECAST results, 15

model information, 15

PARSE results, 15

REGRESS results, 15

OESEIFVERSION

See EIFVERSION option

OESEIFVERSION option

name change

OKFORLIMIT option, 19

OKNULLSTATUS option, 16, 19

OLAP

Data Definition Language See OLAP DML

Data Manipulation Language See OLAP DML

OLAP DML

definition, 1.1

functional categories, A

OLAP session cache

blocking creation of, 21

defined

populating with aggregated values, 6, 24

populating with NA values, 24

ONATTACH program, 19, 19

OPEN command See SQL OPEN command, 22

operating system, 23

determining, 23

operators, 15

Boolean, 2.2.2, 2.2.2

comparison, 2.2.2

conditional, 3.7, 3.7

LIKE, 15, 15

logical, 2.2.2

substitution, 3.8

text formatting

newline characters, 16

options

displaying value of, 1.2.1.2

localization, 18

restoring previous values, 5.1.2.3

retrieving, 1.2.1.2

saving current values, 5.1.2.3

specifying, 1.2.1.2

OR operator, 2.2.2, 2.2.2, 2.2.2

OUTFILE command, 19, 19

and ECHOPROMPT, 11

OUTFILEUNIT option, 19

out-of-range decimal values, 10

output, 19

redirecting, 19

saving in a file, 19

overflow condition, 10

P

padding expressions, 16, 21

PAGE command, 19

PAGENUM option, 19

PAGEPRG option, 19

PAGESIZE, 19

paging in reports, 19

forcing a page break, 19

line number on current page, 16

lines for bottom margin, 8

lines for top margin, 23

lines left on page, 16

lines on a page, 19

page number, 19

producing a custom heading, 19

producing a standard heading, 23

turning on, 19

PAGING option, 19

PARENS option, 19

PARSE command, 3.3.1, 3.3.1, 19

parsing, 15

expressions, 15, 19

partition templates, 10, 10

defining, 10, 10

deleting, 10

maintaining, 16

retreiving partition names, 19

retrieving partitioning method, 19

PARTITIONCHECK function, 19

partitioned variables, 10, 10

aggregating, 7, 19

defining, 10

deleting data from, 16

introduced, 10

maintaining, 16

retrieving dimensions of, 19

retrieving partitioning method, 19

partitioning methods

retrieving, 19

partitions, 10, 10

adding, 9

adding values to, 16, 16

concat, 10

defining, 10

list partitions, 10

deleting, 10

deleting data, 16

external, 7, 9, 10

internal, 10

list, 10

locking segments of, 22

moving values, 16

range, 10, 19

retrieving names of, 19

specifying values of, 16

partitons

retrieving dimensions of, 19

pattern matching, 3.6.6.1

payment schedules, 13

for loan interest, 13, 24

for loans, 13, 24

PERCENTAGE function, 19

permission

programs, 8, 19, 19, 19, A.15.5, A.15.5

permissions, 19

assigning to an object definition, 19

recalculating permission, 19

specifying conditions for accessing, 19

violations of, 19

PERMIT command, 19

PERMIT_READ program, 8, 19

PERMIT_WRITE program, 8, 19

PERMITERROR option, 19

PERMITRESET command, 19

platform, 23

determining, 23

POP command, 5.1.2.3, 5.1.2.4, 19, 19

popping a whole series at once, 19

POPLEVEL command, 19

nesting, 19

using, 5.1.2.5

populating

alias dimensions, 10

POUTFILEUNIT option, 4.2.1, 4.3.1, 19

PREPARE command

See SQL PREPARE command

PRGERR keyword (SIGNAL), 24

PRGTRACE option, 19

PROCEDURE statement

See SQL PROCEDURE command, 22

profiles, 23

PROGRAM command, 19

programs

adding program contents to a definition, 19

analytic workspace permission, 19

branching, 8, 9, 23

branching in, 16

branching labels, 14

calling, 8

case statement, 23

comment lines in, 5.1.1

compiling, 5.2, 9, 9, 9

conditional execution of commands, 11, 14, 24

debugging, 5.3, 8, 9, 12, 19

declaring arguments in, 5.1.1.2.1

defining, 10

deleting, 10

determining how invoked, 8, A.15.5

error handling, 11, 11, 24

errors in, 5.1.3

executing, 5.4

finding line causing error, 8

halting execution with an error, 21

hiding, 14

local variable, 24

ONATTACH, 19

passing arguments to, 8, 8, 8, 8, 8

performance cost, 23

permission, 1.4.1, 8, 8, 19, 19, 19, 19, 19, 19, A.15.5, A.15.5, A.15.5, A.15.5

PERMIT_READ, 8

PERMIT_WRITE, 8, 19

preserving environment, 5.1.2, 5.1.2

preserving status, 9, 9, 19, 19, 19, 19

repeating commands, 13

restoring previous values, 5.1.2.3

returning a value, 21

running, 5.3

saving compiled code, 5.2

saving current values, 5.1.2.3

startup, 1.4.1

statements for, A.15

suspending execution, 21

terminating execution of, 21

testing by running, 5.3

timing execution, 18, 23

trigger, 24, 24, 24, 24, 24, 24, 24, 24, 24

unhiding, 24

properties, 19

copying with an object definition, 9

creating for objects, 19

listing for objects, 13

PROPERTY command, 19

event, 24, 24

trigger, 24, 24

Property event, 24

PUSH command, 5.1.2.4, 19, 19

marking start of series, 19

placement, 5.1.3.5

using, 5.1.2.3

PUSHLEVEL command, 19

nesting, 19

placement, 5.1.3.5

Q

QDR

with = command, 3.10.3.2

with assignment statement, 3.10.3.2

QUAL function, 3.10.3.7, 19

qualified data references, 19

ampersand substitution, 3.10.3.6

creating, 3.10.3

defined, 3.10.3

qualifying a relation, 3.10.3.4

replacing dimension of variable, 3.10.3.2, 3.10.3.3, 3.10.3.3

using with relation, 3.10.3.4

with = command, 3.10.3.2

with assignment statement, 3.10.3.2

with dimensions, 3.10.3

with relations, 3.10.3.4

with variables, 3.10.3.2, 3.10.3.2, 3.10.3.2, 3.10.3.3, 3.10.3.3

qualified object name

defined, 3.2.1

quotation marks (escape sequence), 2.1.2.2

R

RANDOM function, 20

random numbers, 18, 20

random sparsity

defined, 10

RANDOM.SEED.1 option, 20

RANDOM.SEED.2 option, 20

range partitions, 10

retriving calculation for, 19

RANK function, 20

reading files, 20

current record number, 20

error diagnosis, 12

FILEREAD command, 13

processing a record, 13

reading a record, 13

RECAP command, 20

RECNO function, 20

RECURSIVE option, 20

REDO command, 20

REEDIT command, 20

REGRESS command, 20

regression, 12

calculating a linear regression, 12, 20

obtaining information about, 15

regression statements, A.8.1

REGRESS.REPORT program, 20

relation, 23

RELATION statement

for aggregation, 6

for allocation, 7

relations

assigning values to, 21, 21, 21

comparing to text literals, 3.6.6.2

defining, 10

limiting to single value, 3.10.3.4

QDR with, 3.10.3.4

replacing dimension of, 3.10.3.4

RELEASE command, 20

REM function, 20

remainder after division, 20

REMBYTES function, 20

REMCHARS function, 20

REMCOLS function, 20

REMLINES function, 20

RENAME command, 20

REPLBYTES function, 20

REPLCHARS function, 20

REPLCOLS function, 20

REPLLINES, 20

REPORT command

with sparse data, 3.2.4

reports, 20, 21

processing ROW command output, 21

producing, 20

producing with ROW commands, 21

RESERVED function, 21

reserved words, 21

listing, 21

restoring

current dimension status, 3.10.1.2

RESYNC command, 8, 21

RETURN command, 21

return value of a program, 21

REVERT command, 21, 21

ROLE option, 21

roles, 23

ROLLUP command, 21, 21

root of negative number, 21

ROOTOFNEGATIVE option, 3.4.7, 21

ROUND function, 3.6.3, 3.6.3.1

for dates and time, 21

for numbers, 21

ROW command, 21

processing output, 21

ROW function, 21

RPAD function, 21

RTRIM function, 21

running totals, 21

resetting to zero, 24

run-time aggregation, 4.2.2, 4.2.2

RUNTOTAL function, 21

S

saving

current dimension status, 3.10.1.2

scenario models

defined, 4.4.1.6

for financial modeling, 4.4.1.6

seasonal data, 12

forecasting with, 12, 13

SECONDS option, 21

segment width, 9

segments

introduced, 10

locking, 22

SELECT statement

See SQL SELECT command

SELECT statements (in SQL)

selecting

alias dimension values, 10

data, 16

SESSCACHE option, 21

session cache

See OLAP session cache

sessions, 16

preserving environment, 5.1.2, 5.1.2

recording in disk file, 16

restoring environment, 5.1.2.3

user ID, 23

SET1 command, 21

SHORTDECIMAL data type, 3.6.3.3

SHORTINTEGER data type, 2.1.1

SHOW command, 21

showing, 11

definitions of workspace objects, 11

names of dictionary entries, 19

names of objects, 16

object names, 16

object properties, 13

SIGN function, 21

SIGNAL command, 5.1.3.3, 21

simultaneous equations in models, 4.4.1.5

SIN function, 21

sine calculation, 21

hyperbolic, 21

single quotes (escape sequence), 2.1.2.2

SINH function, 21

SLEEP command, 21

slowest-varying dimension, 10

smaller value of two expressions, 17

SMALLEST function, 21

smallest value of an expression, 21

SMOOTH function, 21

solution variables

defined, 4.4

example of, 17

SORT command, 21

SORTCOMPOSITE option, 21

sorting

status list of a dimension, 16, 21

valuesets, 21

SORTLINES function, 21

SOURCEVAL statement, 7

spaces, 8

stripping from text values, 8

sparse data, 15

base dimension value, 15

changing definitions, 9

eliminating, 10

exporting, 12

importing, 14

index algorithm, 21

obtaining information, 19

reading from files, 13

renaming composites, 20

reporting, 20, 21

specifying composites, 10

testing for a value, 15

SPARSE keyword, 10

SPARSEINDEX option, 21

sparsity

controlled, 10

random, 10

spreadsheets

defining

exporting to, 12

importing data from, 14, 14

See worksheets

SQL, 22

embedding in OLAP DML, 22

SQL CLEANUP command

SQL CLOSE command

SQL command, 22

SQL DECLARE CURSOR command

SQL EXECUTE command, 22

SQL FETCH command

SQL IMPORT command

SQL PREPARE command

SQL PROCEDURE command, 22

SQL SELECT command, 22

SQL statements, 22

compiling

issuing through OLAP DML, 1.4.2.1

optimizing, 22

SQL stored procedures

creating, 22

executing, 22

SQL support, 22

blocking factor, 22

error codes, 22

error messages, 22, 22

SQL statement execution, 22

SQLBLOCKMAX option, 22

SQLCODE option, 22

SQLCOLUMNS procedure, 22, 22

SQLERRM option, 22

SQLMESSAGES option, 22

SQLTABLES procedure, 22, 22, 22

SQRT command, 22

square root, 22

calculating, 22

result for negative number, 21

standard deviation calculation, 23

STARTOF function, 22

startup programs, 1.4.1, 19

STATALL function, 22

statements

altering order of execution, 14

editing previously executed, 20

looping, 5.1.1.3.1

reading from a file, 15

sending to file, 20

statements, SQL

compiling

STATFIRST function, 22

statistical functions, A.7.3

STATLAST function, 22

STATLEN function, 22

STATLIST function, 22

STATMAX function, 22

STATMIN function, 22

STATRANK function, 22

status, 22, 22

checking current status list, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22

checking for a dimension value, 15

looping over in a program, 13, 19, 23

null, 19

saving, 9, 9, 19, 19, 19, 19

See dimension status

setting, 16

sorting values in the status list, 21

using result of LIMIT command, 16

status list

current, 3.10.1

default, 3.10.1

STATUS program, 22

STATVAL function, 22

STDDEV function, 23

STDHDR program, 23

line size for centering, 16

storage, 9

in-place vs. permanent, 9

of variables, 10

stored procedures

creating, 22

executing, 22

STORETRIGGERVAL property, 19

See $STORETRIGGERVAL property

subevents

identifying, 24

substitution expressions, 3.8

substitution operator, 3.8

SUBSTR function, 23

SUBSTRB function, 23

substrings

retrieving, 15, 15, 23, 23

SUBTOTAL function, 23

subtotals, 23

in a report, 23

resetting to zero, 24

surrogate dimension, 10

defining, 10

surrogates

defining, 10

deleting, 10

SWITCH command, 8, 23

used with BREAK, 8

used with DO and DOEND, 11

SYSDATE function, 23

SYSINFO function, 23

SYSTEM function, 23

system statements

list of, A.1

T

tab (escape sequence), 2.1.2.2

TALLY function, 23

TAN function, 23

tangent calculation, 23

arc, 8, 8

hyperbolic, 23

tangents

calculating angle value, 8

TANH function, 23

TCONVERT function, 23

temporary members

adding to dimension, 16

TEMPSTAT command, 23

testing

if every value is true, 11

if no values are true, 18

number of true values, 9

whether an object exists, 11

text, 15

comparing values, 3.6.6, 3.6.6

comparing values to a pattern, 3.6.6.1

data types, 2.1.2

functions, A.5.1, A.5.2, A.5.3

NLS_SORT option in comparisons, 3.6.6

options, A.5.1, A.5.2, A.5.3

passing arguments as, 5.1.1.2.3, 16

See also multiline text

TEXT data type, 2.1.2

text expressions

dates in, 3.5.1

defined, 3.5

text formatting, 23

case sensitivity, 15

changing part of a text value, 8, 8

comparing lines to master list, 15

converting to uppercase, 24

counting lines in a value, 18

deleting duplicate lines, 24

extracting lines, 12

extracting part of a text value, 12, 12, 12

filtering lines, 13

finding bytes, 13

finding characters, 13

finding position of lines in a value, 13

importing worksheet data f, 14

inserting a text value, 15

inserting bytes into a text value, 15

inserting characters into a text value, 15

inserting lines, 15

joining, 8

joining columns of values, 15

joining in one line, 15, 15

joining lines, 15

number of bytes in, 17, 18

number of characters in, 17, 18

reformatting, 23

removing lines, 20

removing part of a text value, 20, 20, 20

replacing lines, 20

replacing part of a text value, 20, 20, 20

sorting lines in a multiline value, 21, 24

stripping blank spaces from, 8

text literals

comparing to relations, 3.6.6.2

defined, 3.5

TEXTFILL function, 23

thousands marker, 23

THOUSANDSCHAR option, 23

time, 18

functions, A.6

time of day, 23, 23

time series, 15

averaging over, 18

cumulative totals over, 9

data from previous time period, 15

data from subsequent time period, 15

difference between time periods, 15

maximum value in period, 18

minimum value in period, 18

moving totals over, 18

percent difference between time periods, 15, 15

time-series functions, A.7.4

timing, 18

execution of program lines, 18

execution of programs, 23

title for a report, 14

TMARGIN option, 23

TO_CHAR function, 23

TO_DATE function, 23

TO_NCHAR function, 23

TO_NUMBER function, 23

TOD function, 23

TODAY function, 23

TOTAL function, 23

totals

calculating, 23

cumulative, 9

in a report, 20, 21, 21, 23

moving, 18

over time, 18

running, 21

TRACEFILEUNIT option, 23

tracking, 18

cost of program lines, 18

cost of programs, 23

TRACKPRG command, 23

TRACKREPORT program, 23

transferring, 24

data, 24

TRAP command, 5.1.3.1, 24, 24, 24, 24

trend forecast, 12

trend forecasting, 13

TRIGGER command, 24

TRIGGER function, 24

trigger programs

Assign, 24, 24

Delete, 24, 24

designing, 24

Maintain, 24, 24

Property, 24, 24

Update, 24

update, 24

TRIGGER_AFTER_UPDATE program, 24

TRIGGER_AW program, 24, 24

TRIGGER_BEFORE_UPDATE program, 24

TRIGGER_DEFINE program, 24

TRIGGERASSIGN command, 24

TRIGGERMAXDEPTH option, 24

triggers

Assign, 24, 24

creating, 24, 24, 24, 24, 24, 24, 24, 24, 24

Define, 24

Delete, 24

deleting, 24, 24, 24

event, identifying, 24

Maintain, 24

NA, 6, 24, 24

NA values, 3.9.2.1

object, identifying, 24

Property, 24

subevent, identifying, 24

Update, 24, 24, 24

TRIGGERSTOREOK option, 24

TRIM function, 24

trimming expressions, 16, 21

trimming strings, 24

TRUNC function, 24

for dates and time, 24

for numbers, 24

U

UNHIDE command, 24

UNIQUELINES function, 24

unnamed composites, 10

defining, 10

example of, 10

UNRAVEL function, 24

UPCASE function, 24

UPDATE command, 24

event, 24

events, 24, 24

trigger, 24

triggers, 24, 24, 24

uppercase, 24

converting to, 24

user ID, 23

user-defined functions

arguments in, 5.1.1.1

data type of, 5.1.1.1

executing, 5.4

USERID option, 24

USETRIGGERS option, 24

V

VALSPERPAGE program, 24

value name format

defined, 24

See also VNF command

values

assigning to objects

restoring previous, 5.1.2.3

saving current, 5.1.2.3

VALUES function, 24

VALUESET statement, 7

valuesets

assigning values to, 10

checking, 15

checking current status list, 22, 22, 22, 22, 22, 22, 22, 22, 22

defining, 10, 10

deleting, 10

limiting, 10

listing values, 24

multidimensional, 10

null, 19

setting the status of, 16

sorting values, 21

VARCACHE option, 24

VARCACHE property

See $VARCACHE property

VARIABLE command, 24

variables

accessing, 3.2.3

adding partition, 9

assigning values to, 21

defining, 10, 10

defining in a program, 5.2.2

defining with composite, 10

defining with unnamed composite, 10

deleting, 10

how data is stored, 10

limiting to single value, 3.10.3.2, 3.10.3.2, 3.10.3.2, 3.10.3.3, 3.10.3.3

local to a program, 24

partitioned, 7, 10, 10, 10

QDR with, 3.10.3.2, 3.10.3.2, 3.10.3.2, 3.10.3.3, 3.10.3.3

replacing dimension of, 3.10.3.2, 3.10.3.3, 3.10.3.3

reshaping dimensionality of, 19

sparse data in, 3.2.4

storage of, 10

version, 11

VINTSCHED function, 24

VNF

See value name format

VNF command, 24

VPMTSCHED function, 24

W

WEEKDAYSNEWYEAR option, 24

WEEKOF function, 24

WHILE command, 8, 24

used with BREAK, 8

used with CONTINUE, 9

used with DO and DOEND, 11

WIDTH_BUCKET function, 24

wildcards, 3.6.6.1, 3.6.6.1

WKSDATA function, 24

words

reserved, 21

WORKSHEET data type, 2.1

worksheet objects, 10

cells, 24

data type of cells, 24

defining, 10, 10

deleting, 10

workspaces

alias See workspace alias

Y

YESSPELL option, 2.1.3, 24

YRABSTART option, 24

YYOF function, 24

Z

zero, 11

dividing by, 3.4.7, 11

spelling of, 24

suppressing all-zero report rows, 24

ZEROROW option, 24

ZEROTOTAL command, 24

ZSPELL option, 24