• Contents
  • About
  • Title Page
  • Accessibility Features of the LIBNAME Engine for DataFlux Federation Server
  • Introduction
    • Using This Document
      • About the Document
      • Intended Audience
      • See Also
    • Introduction to the LIBNAME Engine for DataFlux Federation Server
      • Understand the LIBNAME Engine
      • Using the LIBNAME Engine for DataFlux Federation Server
  • Usage
    • Establishing a Connection to the DataFlux Federation Server
      • Components of the LIBNAME Statement
      • Server Connection
      • Data Source Connection
      • Data Source Processing Options
    • Security
      • About the Security on the LIBNAME Engine
      • SAS File Passwords
      • DataFlux Federation Server Security
    • Data Type Support
      • About the DataFlux Federation Server Data Type Support
      • Translation of the DataFlux Federation Server Data Types
      • Override Default Legacy SAS Data Type
    • Null Values
      • About Null Values
      • Null Value Processing Modes
      • Potential Result Set Differences
      • Change Null Processing Modes
    • SAS Names
      • About SAS Names
      • Support for Column Names with Special Characters
      • Reserved Language Keywords
    • SAS Functionality Available Through the Engine
      • Data Source Access and Processing
      • LIBNAME Statement Processing Options
      • Nonexistent Values
      • Numeric Column Length
      • SAS Data Set Options
      • SAS Formats and Informats
      • SAS Indexes
      • SAS Names and Support for DBMS Names
      • SAS Passwords
      • SAS System Options
      • SAS Procedures
    • Examples of Using the Engine
      • Connect to the DataFlux Federation Server and Reference a DSN Definition
      • Control Data Source Processing with a LIBNAME Statement Option
      • Apply a SAS Data Set Option
      • Control Data Source Processing with a SAS System Option and a LIBNAME Statement Option
      • Authenticate with an Authentication Domain
      • Using the SCHEMA= Data Set Option to Reference a Subsequent Data Source in a Federated DSN
      • Using the SCHEMA= Data Source Processing Option
  • LIBNAME Statement Syntax and Options: Reference
    • LIBNAME Statement for the FEDSVR Engine
      • LIBNAME Statement Syntax
    • System Options for the FEDSVR Engine
      • About SAS System Options for the FEDSVR Engine
      • BUFNO= System Option
      • BUFSIZE= System Option
      • COMPRESS= System Option
      • FIRSTOBS= System Option
      • OBS= System Option
      • SASTRACE= System Option
      • SASTRACELOC= System Option
      • VALIDVARNAME= System Option
    • Data Source Processing Options for the FEDSVR Engine
      • About the FEDSVR Engine LIBNAME Statement Options
      • ACCESS= LIBNAME Statement Option
      • AUTOCOMMIT= LIBNAME Statement Option
      • COMPRESS= LIBNAME Statement Option
      • CONNECTION= LIBNAME Statement Option
      • DBCOMMIT= LIBNAME Statement Option
      • DBGEN_NAME= LIBNAME Statement Option
      • DBINDEX= LIBNAME Statement Option
      • DBLIBINIT= LIBNAME Statement Option
      • DBLIBTERM= LIBNAME Statement Option
      • DBNULLKEYS= LIBNAME Statement Option
      • DBPROMPT= LIBNAME Statement Option
      • DBSASLABEL= LIBNAME Statement Option
      • DEFER= LIBNAME Statement Option
      • DIRECT_EXE= LIBNAME Statement Option
      • DIRECT_SQL= LIBNAME Statement Option
      • IGNORE_READ_ONLY_COLUMNS= LIBNAME Statement Option
      • INSERT_SQL= LIBNAME Statement Option
      • INSERTBUFF= LIBNAME Statement Option
      • MULTI_DATASRC_OPT= LIBNAME Statement Option
      • PRESERVE_COL_NAMES= LIBNAME Statement Option
      • PRESERVE_TAB_NAMES= LIBNAME Statement Option
      • QUALIFIER= LIBNAME Statement Option
      • READBUFF= LIBNAME Statement Option
      • READ_ISOLATION_LEVEL= LIBNAME Statement Option
      • READ_LOCK_TYPE= LIBNAME Statement Option
      • REREAD_EXPOSURE= LIBNAME Statement Option
      • SCHEMA= LIBNAME Statement Option
      • SPOOL= LIBNAME Statement Option
      • SQL_FUNCTIONS= LIBNAME Statement Option
      • STRINGDATES= LIBNAME Statement Option
      • UPDATE_ISOLATION_LEVEL= LIBNAME Statement Option
      • UPDATE_LOCK_TYPE= LIBNAME Statement Option
      • UTILCONN_TRANSIENT= LIBNAME Statement Option
    • Data Set Options for FEDSVR Engine
      • FEDSVR LIBNAME Engine Data Set Options
      • Syntax
      • How Data Set Options Interact with Other Types of Options
      • ALTER= Data Set Option
      • BL_LOAD_REPLACE= Data Set Option
      • BL_LOG= Data Set Option
      • BL_OPTIONS= Data Set Option
      • BUFNO= Data Set Option
      • BUFSIZE= Data Set Option
      • BULKLOAD= Data Set Option
      • BULKOPTS= Data Set Option
      • COMPRESS= Data Set Option
      • DBCOMMIT= Data Set Option
      • DBCONDITION= Data Set Option
      • DBCREATE_TABLE_OPTS= Data Set Option
      • DBFORCE= Data Set Option
      • DBGEN_NAME= Data Set Option
      • DBINDEX= Data Set Option
      • DBKEY= Data Set Option
      • DBLABEL= Data Set Option
      • DBMASTER= Data Set Option
      • DBNULL= Data Set Option
      • DBNULLKEYS= Data Set Option
      • DBSASLABEL= Data Set Option
      • DBSASTYPE= Data Set Option
      • DBTYPE= Data Set Option
      • DROP= Data Set Option
      • ENCRYPT= Data Set Option
      • FIRSTOBS= Data Set Option
      • IDXNAME= Data Set Option
      • IDXWHERE= Data Set Option
      • IGNORE_READ_ONLY_COLUMNS= Data Set Option
      • INSERTBUFF= Data Set Option
      • INSERT_SQL= Data Set Option
      • KEEP= Data Set Option
      • LABEL= Data Set Option
      • NULLCHAR= Data Set Option
      • NULLCHARVAL= Data Set Option
      • OBS= Data Set Option
      • PRESERVE_COL_NAMES= Data Set Option
      • PW= Data Set Option
      • QUALIFIER= Data Set Option
      • READ= Data Set Option
      • READ_ISOLATION_LEVEL= Data Set Option
      • READ_LOCK_TYPE= Data Set Option
      • READBUFF= Data Set Option
      • RENAME= Data Set Option
      • REUSE= Data Set Option
      • SASDATEFMT= Data Set Option
      • SCHEMA= Data Set Option
      • TYPE= Data Set Option
      • UPDATE_ISOLATION_LEVEL= Data Set Option
      • UPDATE_LOCK_TYPE= Data Set Option
      • WHERE= Data Set Option
      • WRITE= Data Set Option
  • Appendix
    • LIBNAME Statement Syntax for Submitting a Fully-Specified Connection String
      • LIBNAME Statement Syntax for Submitting a Fully Specified Connection String
    • Data Source Connection Arguments for SAS Data
      • SAS Data Set Connection Arguments
    • Examples of a Fully-Specified Connection String
      • Access a SAS Data Set with a Fully-Specified Connection String
      • Access an Oracle Database with a Fully-Specified Connection String
  • Recommended Reading
  • Glossary


ProductRelease
DataFlux Federation Server
Type
Usage and Reference
Copyright Date
August 2012
Last Updated
30Aug2012