What's New in SAS 9.4 FedSQL Language Reference :: SAS(R) 9.4 FedSQL Language Reference, Third Edition

Introduction to the FedSQL Language

SAS FedSQL is a SAS proprietary implementation of ANSI SQL:1999 core standard. It provides support for new data types and other ANSI 1999 core compliance features and proprietary extensions. FedSQL provides a scalable, threaded, high-performance way to access, manage, and share relational data in multiple data sources. When possible, FedSQL queries are optimized with multi-threaded algorithms in order to resolve large-scale operations.

For applications, FedSQL provides a common SQL syntax across all data sources. That is, FedSQL is a vendor-neutral SQL dialect that accesses data from various data sources without having to submit queries in the SQL dialect that is specific to the data source. In addition, a single FedSQL query can target data in several data sources and return a single result table.

Documentation Enhancements

If you previously used the FedSQL language with DataFlux Federation Server, SAS FedSQL Language Reference replaces DataFlux Federation Server FedSQL Reference Guide. The FedSQL language is available now for Base SAS users as well as for users of SAS Federation Server.

First Maintenance Release of SAS 9.4

In the first maintenance release of SAS 9.4, the following functionality was added to the FedSQL language:

Support for Memory Data Store (MDS), SAP HANA, and SASHDAT data sources.
Rename table and rename column functionality in the ALTER TABLE statement. See ALTER TABLE Statement.

The documentation was enhanced to include the following:

examples of join operations. See Join Operations.
examples of EXCEPT, INTERSECT, and UNION operations. See Examples of Query Expressions.
examples of subqueries. See Overview of Subqueries, Examples of Correlated Subqueries, Examples of Scalar Subqueries, and Examples of Non-Correlated Queries.
an explanation of how the PUT function can be used. See Using Formats in FedSQL and Using a User-Defined Format.
an explanation of how FedSQL handles transactions. See Transactions in FedSQL.
reference information for additional functions. See FedSQL Functions.

Second Maintenance Release of SAS 9.4

In the second maintenance release of SAS 9.4, the following functionality was added to the FedSQL language:

Support for Hive, HDMD, and PostgreSQL data sources. See Data Types for Hive, Data Types for HDMD, and Data Types for PostgreSQL to see what data types are supported for each data source. Not all FedSQL statements are supported for each data source. See the documentation for FedSQL statements to determine statement support.
CAST Function
DBCREATE_INDEX_OPTS= for ODBC
SQUEEZE= Table Option for SASHDAT

What’s New in SAS 9.4 FedSQL Language Reference

Introduction to the FedSQL Language

Documentation Enhancements

First Maintenance Release of SAS 9.4

Second Maintenance Release of SAS 9.4