The LOAD TABLE statement imports text files with one row per line. 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. See the section “Data extraction options” for details on the output formats of data extraction.
Specifying an output format for Interactive SQL
Select Command > Options from the DBISQL menu bar.
Choose an Output Format from the dropdown list.
To make this the default output format, click Permanent.
