Statements for Importing and Exporting Data |
Table: Statements for Importing and Exporting Data lists the OLAP DML statements that you use to import and export data.
Statements for Importing and Exporting Data
| Statements | Description |
|---|---|
| EXPORT
|
Copies both data and object definitions from your workspace to an EIF file, or copies an OLAP DML worksheet object to a spreadsheet file. |
| IMPORT
|
Copies data from an EIF file, a text file, or a spreadsheet into an analytic workspace. |
| WKSDATA
|
Returns the data type of each individual cell in a worksheet. |
| SQL
|
Typically, used in a program to copy data to and from relational tables, passes instructions written in Structured Query Language (SQL) to the relational manager from Oracle OLAP. |
| SQLFETCH
|
Retrieve one or more rows of a column in a relational text |