Options window: Import/Export tab

This tab has the following components:

  • Default export format   To choose a format for exporting files, select a file format from the dropdown list. The default export format is text. This format is used only if you do not specify a FORMAT clause in an OUTPUT statement. See OUTPUT statement [Interactive SQL].

  • Default import format   To choose a format for importing files, select a file format from the dropdown list. The default import format is TEXT. This format is used only if you do not specify a FORMAT clause in at INPUT statement. See INPUT statement [Interactive SQL].

  • Text Options   Specify the default symbols used for the field separator, quote string, and escape character when you import or export data in text format.

    • Default field separator   The symbol used to separate values in text files. The default value is a comma (,).

    • Default quote string   The symbol used to enclose strings in text files. The default value is a single quote (').

    • Default escape character   The symbol used in place of unprintable characters in text 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 default code page for the computer Interactive SQL is running on.

 See also
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0