FedSQL Enhancements

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.

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.

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.

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 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 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.