SQL Anywhere offers several ways to invoke the SQL Flagger to check a SQL statement, or a batch of SQL statements:
SQLFLAGGER function The SQLFLAGGER function analyzes a single SQL statement, or batch, passed as a string argument, for compliance with a given SQL standard. The statement or batch is parsed, but not executed. See SQLFLAGGER function [Miscellaneous].
sa_ansi_standard_packages system procedure The sa_ansi_standard_packages system procedure analyzes a statement, or batch, for the use of optional packages from the ANSI SQL/2003 or SQL/1999 international standards. The statement or batch is parsed, but not executed. See sa_ansi_standard_packages system procedure.
sql_flagger_error_level and sql_flagger_warning_level options The sql_flagger_error_level and sql_flagger_warning_level options invoke the SQL Flagger for any statement prepared or executed for the connection. If the statement does not comply with the option setting, which is a specific ANSI standard or UltraLite, the statement either terminates with an error (SQLSTATE 0AW03), or returns a warning (SQLSTATE 01W07), depending upon the option setting. If the statement complies, statement execution proceeds normally. See sql_flagger_error_level option [compatibility] and sql_flagger_warning_level option [compatibility].
SQL preprocessor (sqlpp) The SQL preprocessor (sqlpp) has the ability to flag static SQL statements in an embedded SQL application at compile time. This feature can be especially useful when developing an UltraLite application, to verify SQL statements for UltraLite compatibility. See SQL preprocessor, and Running the SQL preprocessor.
Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |