Sybase 12.4.2 manual Input and output data formats, Import and export overview, 172

Import and export overview

•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.

172