Skip Headers
Oracle® OLAP DML Reference
10g Release 2 (10.2)

Part Number B14346-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

POUTFILEUNIT

The POUTFILEUNIT option identifies a destination for status information about the execution of many OLAP DML statements, including:

AGGREGATE command
AGGREGATE function
ALLOCATE
CLEAR
AW ATTACH
AW DETACH
UPDATE
IMPORT
EXPORT

When an OLAP DML statement is executed through SQL, using the POUTFILEUNIT option enables you to see the work that the statement is doing as it progresses instead of waiting until the execution of the SQL call is complete.

Syntax

POUTFILEUNIT =  -1 |fileunit

Arguments

-1

(Default) Specifies that Oracle OLAP is currently not logging data.

fileunit

Specifies a destination, such as an open disk file, to which Oracle OLAP sends information on the progress of an operation. The fileunit can be the value of the OUTFILEUNIT option or the results of the FILEOPEN function.

Notes

Changing the Setting of POUTFILEUNIT From Fileunit to -1

When you change the value of POUTFILEUNIT from fileunit to -1, Oracle OLAP disassociates the file identified by fileunit from POUTFILEUNIT and suspends logging to that file; however, but Oracle OLAP does not close that file. You can resume logging to that file by issuing another POUTFILEUNIT.

To close the file before suspending logging, issue a FILECLOSEPOUTFILEUNIT before you change the value of POUTFILEUNIT from fileunit to -1.

Information Sent by ALLOCATE and AGGREGATE

ALLOCATE, the AGGREGATE command, and AGGREGATE function send the following types of information:

Examples

Example 21-36 Using FILEOPEN to Open a File

In this example, a FILEOPEN statement opens a file named progress.txt in the userfiles directory object and returns the file handle to the POUTFILEUNIT option. The file receives status messages from the AGGREGATE command. When the aggregation is complete, a FILECLOSE statement closes the file.

POUTFILEUNIT=FILEOPEN('userfiles/progress.txt' WRITE)
AGGREGATE sales units USING gpct.aggmap
FILECLOSE POUTFILEUNIT

Example 21-37 Viewing Progress in OLAP Worksheet

The following statement sets POUTFILEUNIT to the current outfile destination. When the current outfile destination is the OLAP Worksheet window, remember that you cannot do other work in your session until the operation completes.

POUTFILEUNIT=OUTFILEUNIT