Alphabetical list of options
204
This option controls the length used when Interactive SQL exports
information to an external file (using output redirection with the OUTPUT
statement). This option affects only ASCII, HTML, and SQL output formats.
OUTPUT_NULLS option [ISQL]
Controls the way NULL values appear in result sets.
String
’NULL’
This option controls the way NULL values appear in result sets. Every time a
NULL value is found in the result set, the string from this option is returned
instead. This setting applies to data showing in the Interactive SQL Results
pane as well as to data in output files generated by the OUTPUT statement.
This option affects only ASCII, HTML, and SQL output formats.
PERCENT_AS_COMMENT option
Controls the interpretation of the percent character.
ON, OFF
ON
It is recommended that you not use % as a comment marker.
Versions of this product before Version 6 treated the percent character (%) in
SQL statements exclusively as a comment delimiter. Since Version 5,
alternative comment markers such as //, /* */, and -- (double dash) have been
available. The double-dash style is the SQL/92 comment delimiter.
Adaptive Server Enterprise treats % as a modulo operator and does not
support the Adaptive Server Anywhere mod function. Writing a statement
that works in both environments and performs a modulo operation was
previously impossible.
The PERCENT_AS_COMMENT option controls the meaning of %. The
default setting is ON, for backwards compatibility. You can set the option to
OFF for compatibility with Adaptive Server Enterprise.
Procedures, triggers and views that were created with %-style comments are
converted to double-dash comments when they are stored in the catalog.
Description
Function
Allowed values
Default
Description
Function
Allowed values
Default
Description
To Next Page
Loading...