ASA SQL User's Guide
Importing and Exporting Data
Importing and exporting data
Interactive SQL supports the following import and export file formats:
| File Format | Description | Available for Importing | Available for Exporting |
|---|---|---|---|
| ASCII | A text file, one row per line, with values separated by a delimiter. String values optionally appear enclosed in apostrophes (single quotes). This is the same as the format used by LOAD TABLE and UNLOAD TABLE. |
|
|
| DBASEII | DBASE II format |
|
|
| DBASEIII | DBASE III format |
|
|
| Excel 2.1 | Excel format 2.1 |
|
|
| FIXED | Data records appear in fixed format with the width of each column either the same as defined by the column's type or specified as a parameter. |
|
|
| FOXPRO | FoxPro format |
|
|
| HTML | HTML (Hyper Text Markup Language) format | No |
|
| LOTUS | Lotus workspace format |
|
|
| SQL Statements | The SQL statement format. This format can be used as an argument in a READ statement. | Using the READ statement only |
|
| XML | The generated XML file is encoded in UTF-8 and contains an embedded DTD. Binary values are encoded in CDATA blocks with the binary data rendered as 2-hex-digit strings. | No |
|