Oracle9i OLAP Developer's Guide to the OLAP DML Release 2 (9.2) Part Number A95298-01 |
|
Reading Data from Files, 3 of 9
While reading from a file, you can format the data from each field individually, and use DML functions to process the information before assigning it to a workspace 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:
FILEREAD
command loops automatically over all records in the file and processes them automatically. Use FILEREAD
when all records in the file are the same.FILEVIEW
command processes one record at a time. Use FILEVIEW
when there is more than one type of record in the 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.
|
Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. |
|