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 and .
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 (\).
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