Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » Context-Sensitive Help » Interactive SQL help

 

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