Input and output data formats

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.