SQL Anywhere Studio Help
Interactive SQL Help
Options dialog
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 To choose a format for importing files, select a file format from the dropdown list. By default, the import format is ASCII.
For more information about the import and export file formats supported by Interactive SQL, see Data formats.
ASCII Options Specify the default symbols used for the field separator, quote string, and escape character when you import or 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 (\).
SET OPTION statement [Interactive SQL]