The Import/Export dialog box allows you to configure import and export settings in Interactive SQL.
| Component | Description |
|---|---|
Default export format | Select the default file format for exporting. This format is automatically selected in the Files of Type field in the Save dialog, but you can still choose other formats. The default is also used when Interactive SQL interprets an output statement if no format is specified. The default setting is ASCII. |
Default import format | Select the default file format for importing. This format is automatically selected in the Files of Type field in the Open dialog, but you can still choose other formats. The default is also used when Interactive SQL interprets an input statement if no format is specified. The default setting is ASCII. |
ASCII options | Specify the default symbols that are used for the field separator, quote string, escape character, and the default encoding datatype when you import or export data in the ASCII format. The default settings are the comma (,) for the field separator, an apostrophe (í) for the quote string, and a backslash (\) for the escape character. By default, Interactive SQL uses the default datatype of the server. |