Contents Index ISQL_COMMAND_TIMING option [ISQL] ISQL_FIELD_SEPARATOR option [ISQL]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

ISQL_ESCAPE_CHARACTER option [ISQL]


Function 

Controls the escape character used in place of unprintable characters in data exported to ASCII files.

Allowed values 

Any single character

Default 

A backslash ( \ )

Description 

When Interactive SQL exports strings that contain unprintable characters (such as a carriage return), it converts each unprintable character into a hexadecimal format and precedes it with an escape character. The character you specify for this setting is used in the output if your OUTPUT statement does not contain an ESCAPE CHARACTER clause. This setting is used only if you are exporting to an ASCII file.

Example 

Contents Index ISQL_COMMAND_TIMING option [ISQL] ISQL_FIELD_SEPARATOR option [ISQL]