Sybase Adaptive Server Anywhere - Page 209

Chapter 5 Database Options
191
This boolean option controls whether SQL statements are timed or not. If
you set the option to ON, YES, or 1, the time of execution appears in the
Messages pane after you execute a statement. If you set the option to OFF,
NO, or 0, the time does not appear.
You can also set this option on the Messages page of the Options dialog.
ISQL_ESCAPE_CHARACTER option [ISQL]
Controls the escape character used in place of unprintable characters in data
exported to ASCII files.
Any single character
A backslash ( \ )
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.
♦ Create a table that contains one string value with an embedded carriage
return (denoted by the "\n" in the INSERT statement). Then export the
data to
c:\escape.txt with a # sign as the escape character.
CREATE TABLE escape_test( TEXT varchar(10 ) );
INSERT INTO escape_test VALUES( ’one\ntwo’ );
SET TEMPORARY OPTION ISQL_ESCAPE_CHARACTER=’#’;
SELECT * FROM escape_test;
OUTPUT TO c:\escape.txt FORMAT ASCII
This code places the following data in escape.txt :
’one#x0Atwo’
where # is the escape character and x0A is the hexadecimal
equivalent of the "\n" character.
The start and end characters (in this case, single quotation marks)
depend on the ISQL_QUOTE setting.
Description
Function
Allowed values
Default
Description
Example