A.16 File Reading and Writing Statements

Table A-27, "File Reading and Writing Statements" lists the OLAP DML statements that you use when reading data from files or to files.

Table A-27 File Reading and Writing Statements

Statement	Description
CDA	Identifies or changes the current directory object for your session.
FETCH	Closes an open file. If the file has not been opened, an error occurs.
FILECOPY	Copies the contents of one file (the source file) to another file (the target file).
FILEDELETE	Deletes a file from the operating system disk space.
FILEERROR	Returns information about the first error that occurred when you are processing a record from an input file with the data reading statements FILEREAD and FILEVIEW.
FILEGET	Returns text from a file that has been opened for reading; or NA when FILEGET reaches the end of the file.
FILEMOVE	Changes the name or location of a file that you specify. The new file name may be the same or different from the original name.
FILENEXT	Makes a record available for processing by the FILEVIEW command.
FILEOPEN	Opens a file, assigns it a fileunit number (an arbitrary integer), and returns that number.
FILEPAGE	Forces a page break in your output when PAGING is on.
FILEPUT	Writes data that is specified in a text expression to a file that is opened in WRITE or APPEND mode.
FILEQUERY	Returns information about a file.
FILEREAD	Reads records from an input file and processes data according to action statements that you specify.
FILESET	Sets the paging attributes of a specified fileunit.
FILEVIEW	In conjunction with the FILENEXT function, reads one record at a time of an input file, processes the data, and stores the data in Oracle OLAP dimensions and variables according to the descriptions of the fields.
GET	Requests input from the current input stream.
INFILE	Reads statement input from a specified file.
LISTFILES	Lists all the open files that can be referenced by the FILEQUERY function.
LOG command	Starts or stops the recording of a session to a disk file. All lines of input and output are recorded.
OUTFILE	Redirects the text output of statements to a file.
RECNO	Reports the current record number of a file opened for reading; or NA when Oracle OLAP has reached the end of the file.