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 » System Procedures » System procedures

openxml system procedure Next Page

sa_ansi_standard_packages system procedure


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

Syntax

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

Arguments
Remarks

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

Permissions

None

Side effects

None

See also
Example

Following is an example call to the sa_ansi_standard_packages system procedure:

CALL sa_ansi_standard_packages( 'SQL:2003', 
'SELECT * 
   FROM ( SELECT o.SalesRepresentative, 
                 o.Region, 
                 SUM( s.Quantity * p.UnitPrice ) AS total_sales,
                 DENSE_RANK() OVER ( PARTITION BY o.Region, 
                                     GROUPING( o.SalesRepresentative ) 
                                     ORDER BY total_sales DESC ) AS sales_rank
            FROM Product p, SalesOrderItems s, SalesOrders o
            WHERE p.ID = s.ProductID AND s.ID = o.ID
            GROUP BY GROUPING SETS( ( o.SalesRepresentative, o.Region ), o.Region ) ) AS DT 
   WHERE sales_rank <= 3
   ORDER BY Region, sales_rank')

The query generates the following result set:

package_idpackage_name
T612Advanced OLAP operations
T611Elementary OLAP operations
F591Derived tables
T431Extended grouping capabilities