Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 192 / 536

Import and export overview
172
• To remove specific rows from a table, use the
DELETE
statement.
• To change existing rows in a table, you can also use the
UPDATE
statement.
From DBISQL you can export data to another database in a variety of formats,
or produce a text file as output. See the next section for a list of formats and
how to select them. You can also redirect the output of any command.
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 an Adaptive Server 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
DIF
Data Interchange 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
LOTUS Lotus workspace format
SQL
Interactive SQL INPUT statement required to recreate the
information in the table
TEXT TEXT format file that prints the results in columns with the
column names at the top and vertical lines separating the
columns. This format is similar to that used to display data in
the Interactive SQL data window
WATFILE
WATFILE format.