Because SAS Federation Server
supports several data sources, a broad range of database functionality
that is unique to each data source is provided. For example, a particular
data source provides transaction support while another data source
might not provide transaction support but supports indexes and integrity
constraints.
You must understand
database functionality and how its implementation affects processing,
performance, and integrity of your data in order to determine which
data sources are most appropriate for different types of applications.
Because database functionality is unique to each data source, you
cannot make assumptions about the data source to be accessed. For
example, an application cannot request a locking level just because
that locking level is more efficient. An application must respond
to the attributes of a SAS Federation Server driver.
Database functionality
is applied through the SAS Federation Server driver
when the application submits requests. Requests can be in the form
of FedSQL statements or the SQL statements
that are the implementation of the data service. For additional information
about database functionality including data types, see the
SAS FedSQL Reference Guide.