Skip Headers

Oracle® OLAP DML Reference
10g Release 1 (10.1)

Part Number B10339-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
View PDF

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