sa_ansi_standard_packages system procedure

Syntax

sa_ansi_standard_packages( standard, statement )

Arguments

• standard – The standard to use for the core extensions. One of SQL:1999 or SQL:2003.
• statement – The SQL statement to evaluate.

Remarks

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

Permissions

None

Side effects

None

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: