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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Database Options » Introduction to database options » Alphabetical list of options

optimization_workload option [database] Next Page

percent_as_comment option [compatibility]

Controls the interpretation of the percent character.

Allowed values

On, Off




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.