The Import/Export tab of the Options dialog in Interactive SQL has the following components:
Default export format To choose a format for exporting files, select a file format from the dropdown list. By default, the export format is ASCII.
Default import format This option is not supported for use with Sybase IQ databases.
For more information about the file formats supported by Interactive SQL, see Chapter 7, “Moving Data In and Out of Databases,” Sybase IQ System Administration Guide.
The IQ data extraction facility exports data in binary
or ASCII format, which can be loaded into another database. Use
this facility for high-volume data movement, or when you need an
output file that can be used for loads. See “Data
extraction options” in Chapter
7, “Moving Data In and Out of Databases,” Sybase IQ System Administration Guide for details
and advantages of this feature.
ASCII Options Specify the default symbols used for the field separator, quote string, and escape character when you export data in ASCII format.
Default field separator The symbol used to separate values in ASCII files. The default value is a comma (,).
Default quote string The symbol used to enclose strings in ASCII files. The default value is a single quote (').
Default escape character The symbol used in place of unprintable characters in ASCII files. The escape character must be one, single-byte character. The default value is a backslash (\).
Default encoding The encoding used when importing and exporting files. If you change this value, it is only changed for the current Interactive SQL session. When you start a new Interactive SQL session, it is restored to its default value. The default value is (Default). If you select (Default), the encoding is determined as follows:
the code page specified in the ENCODING clause of the INPUT, OUTPUT, or READ statement
the code page specified with the DEFAULT_ISQL_ENCODING option (if this option is set)
the code page specified with the -codepage command-line option when Interactive SQL was started
the default code page for the computer Interactive SQL is running on
