FedSQL Enhancements

Reserved Words

For a complete list of reserved words in FedSQL, see FedSQL Reserved Words.

Column Modifiers

FedSQL supports the FORMAT=, INFORMAT=, and LABEL= modifiers in the HAVING clause of the CREATE TABLE statement. These modifiers control the format in which output data is displayed and labeled. For more information, see How to Store, Change, Delete, and Use Stored Formats , How to Specify Informats in FedSQL, and the HAVING Clause.

Functions

Aggregate Functions

FedSQL supports many more aggregate functions than are required by the ANSI Standard for SQL. For a complete list of aggregate functions that FedSQL supports, see Aggregate Functions.

Base SAS DATA Step Functions

FedSQL supports many of the functions that are available to the Base SAS DATA step. Functions that are not supported include the variable information functions and functions that work with arrays of data. Other FedSQL data sources support their own sets of functions.
For a complete list of functions that FedSQL supports, see Overview of FedSQL Functions.

PROC FCMP Functions

FedSQL supports user-written functions, except those functions with array elements, only when FedSQL statements are submitted with PROC FEDSQL. For more information about using PROC FEDSQL, see Base SAS Procedures Guide.

Table Options

A table option specifies actions that enable you to perform operations on a table such as assigning or specifying passwords. A table option in the FedSQL performs much of the same functionality as a Base SAS data set option. For more information, see Overview of Statement Table Options.

SAS Missing Values and Null Values

FedSQL supports both SAS missing values and null values. Nonexistent data is represented by a SAS missing value in SAS data sets, SPD Engine data sets, and SPD Server tables. For all other data sources, nonexistent data is represented by an ANSI SQL null value. For more information, see How FedSQL Processes Nulls and SAS Missing Values.

DS2 Package Methods as Functions

You can invoke a DS2 package method as a function in a FedSQL SELECT statement. For more information, see Using DS2 Packages in Expressions.

Integrity Constraints

Integrity constraints are a set of data validation rules that you can specify to preserve the validity and consistency of your data. Integrity constraints that are specified in the CREATE TABLE statement are passed through to the data source. When a transaction modifies the table, the data source enforces integrity constraints. For more information, see the CREATE TABLE Statement.

FedSQL DICTIONARY Tables

FedSQL supports DICTIONARY tables that are similar to the DICTIONARY tables that are available in Base SAS. A FedSQL DICTIONARY table is a Read-only table that contains information about columns, tables, and catalogs, and statistics about a single table and its associated indexes. For more information, see DICTIONARY Tables.
Last updated: February 23, 2017