Oracle9i OLAP Services Developer's Guide to the OLAP DML Release 1 (9.0.1) Part Number A86720-01 |
|
Reading Data from Files, 3 of 9
While reading from a file, you can format the data from each field individually, and you can use Express functions to process the information before assigning it to an OLAP DML object. Reading a file generally involves the following steps.
The FILEREAD and FILEVIEW commands have the same attributes and can do the same processing on your data. However, they differ in important ways:
Consequently, there are two basic methods for reading a file.
The following table shows, for each method, the commands you need to open and close the input file, to read the file, and to handle errors that might occur.
Note: The error handling in the abnormal exit section of the programs closes the file only when the file is open. The FILEOPEN function signals an error when for any reason the system can not open the file. The program tries to close the file after the ERROR label only when FUNIT holds a valid file unit number. You can add additional commands to the error handling section as well. These sections of the program are the same for both methods.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|