sa_ansi_standard_packages system procedure

Returns information about the non-core SQL extensions used in a SQL statement.

Syntax

sa_ansi_standard_packages(
standard
, statement
)

standard – Use this LONG VARCHAR parameter to specify the standard to use for the core extensions. One of SQL:1999 or SQL:2003.
statement – Use this LONG VARCHAR parameter to specify the SQL statement to evaluate.

Column name	Data type	Description
package_id	VARCHAR(10)	The feature identifier.
package_name	LONG VARCHAR	The feature name.

If there are no non-core extensions used for the statement, the result set is empty.

None

None