The LOAD TABLE statement imports data from files row by row. Both ASCII and binary input files are supported, with either fixed-length fields or variable-length fields ended by a delimiter.
The INSERT statement moves data into a Sybase IQ table either from a specified set of values, or directly from tables.
Interactive SQL supports the following output file formats:
File Format |
Description |
|---|---|
ASCII |
A text file, one row per line, with values separated by a delimiter. String values are optionally enclosed in apostrophes (single quotes). This is the same as the format used by LOAD TABLE |
DBASEII |
DBASE II format |
DBASEIII |
DBASE III format |
EXCEL |
Excel format |
FIXED |
Data records are 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 format |
LOTUS |
Lotus worksheet format |
SQL |
Interactive SQL INPUT statement required to recreate the information in the table |
XML |
XML format encoded in UTF-8 and containing an embedded DTD. |
The IQ data extraction facility exports data in binary or ASCII format.