Filter
Top Products
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.