Controls the interpretation of the percent character.
It is recommended that you do 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 hyphen) have been available. The double hyphen style is the SQL/2003 comment delimiter.
Adaptive Server Enterprise treats % as a modulo operator and does not support the SQL 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 backward 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.