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 - SQL Reference » SQL Functions » Alphabetical list of functions

SQLDIALECT function [Miscellaneous] Next Page

SQLFLAGGER function [Miscellaneous]


Returns the conformity of a given SQL statement to a specified standard.

Syntax

SQLFLAGGER( sql-standard-string, sql-statement-string )

Parameters

sql-standard-string    The standard level against which to test conformance. Possible values are the same as for the sql_flagger_error_level database option:

sql-statement-string    The SQL statement to check for conformance.

See also
Standards and compatibility
Example

The following statement shows an example of the message that is returned when a disallowed extension is found:

SELECT SQLFLAGGER( 'SQL:2003/Package', 'SELECT top 1 dummy_col FROM sys.dummy ORDER BY dummy_col' );

This statement returns the message '0AW03 Disallowed language extension detected in syntax near 'top' on line 1'.

If no disallowed extensions are found, such as in the following example SQL statement, '00000' is returned.

SELECT SQLFLAGGER( 'SQL:2003/Package', 'SELECT dummy_col FROM sys.dummy' );