SAS/ACCESS(R) 9.2 for Relational Databases: Reference
- What's New in SAS/ACCESS 9.2 Interfaces for Relational Databases
Concepts
Overview of the SAS/ACCESS Interface to Relational Databases- SAS Names and Support for DBMS Names
- Data Integrity and Security
- Performance Considerations
- Optimizing Your SQL Usage
- Overview of Optimizing Your SQL Usage
- Passing Functions to the DBMS Using PROC SQL
- Passing Joins to the DBMS
- Passing the DELETE Statement to Empty a Table
- When Passing Joins to the DBMS Will Fail
- Passing DISTINCT and UNION Processing to the DBMS
- Optimizing the Passing of WHERE Clauses to the DBMS
- Using the DBINDEX=, DBKEY=, and MULTI_DATASRC_OPT= Options
- Threaded Reads
- Overview of Threaded Reads in SAS/ACCESS
- Underlying Technology of Threaded Reads
- SAS/ACCESS Interfaces and Threaded Reads
- Scope of Threaded Reads
- Options That Affect Threaded Reads
- Generating Trace Information for Threaded Reads
- Performance Impact of Threaded Reads
- Autopartitioning Techniques in SAS/ACCESS
- Data Ordering in SAS/ACCESS
- Two-Pass Processing for SAS Threaded Applications
- When Threaded Reads Do Not Occur
- Summary of Threaded Reads
- How SAS/ACCESS Works
- General Reference
- SAS/ACCESS Features by Host
- Introduction
- SAS/ACCESS Interface to DB2 under UNIX and PC Hosts: Supported Features
- SAS/ACCESS Interface to DB2 under z/OS: Supported Features
- SAS/ACCESS Interface to HP Neoview: Supported Features
- SAS/ACCESS Interface to Informix: Supported Features
- SAS/ACCESS Interface to Microsoft SQL Server: Supported Features
- SAS/ACCESS Interface to MySQL: Supported Features
- SAS/ACCESS Interface to Netezza: Supported Features
- SAS/ACCESS Interface to ODBC: Supported Features
- SAS/ACCESS Interface to OLE DB: Supported Features
- SAS/ACCESS Interface to Oracle: Supported Features
- SAS/ACCESS Interface to Sybase: Supported Features
- SAS/ACCESS Interface to Teradata: Supported Features
- The LIBNAME Statement for Relational Databases
- Overview of the LIBNAME Statement for Relational Databases
- Assigning a Libref Interactively
- LIBNAME Statement Syntax for Relational Databases
- DBMS Interface Specifics for the LIBNAME Statement
- LIBNAME Options for Relational Databases
- ACCESS= LIBNAME Option
- ADJUST_BYTE_SEMANTIC_COLUMN_LENGTHS= LIBNAME Option
- ADJUST_NCHAR_COLUMN_LENGTHS= LIBNAME Option
- AUTHDOMAIN= LIBNAME Option
- AUTHID= LIBNAME Option
- AUTOCOMMIT= LIBNAME Option
- BL_KEEPIDENTITY= LIBNAME Option
- BL_KEEPNULLS= LIBNAME Option
- BL_LOG= LIBNAME Option
- BL_OPTIONS= LIBNAME Option
- BULKLOAD= LIBNAME Option
- BULKUNLOAD= LIBNAME Option
- CAST= LIBNAME Option
- CAST_OVERHEAD_MAXPERCENT= LIBNAME Option
- CELLPROP= LIBNAME Option
- COMMAND_TIMEOUT= LIBNAME Option
- CONNECTION= LIBNAME Option
- CONNECTION_GROUP= LIBNAME Option
- CONNECTION_TIMEOUT= LIBNAME Option
- CURSOR_TYPE= LIBNAME Option
- DBCLIENT_MAX_BYTES= LIBNAME Option
- DBCOMMIT= LIBNAME Option
- DBCONINIT= LIBNAME Option
- DBCONTERM= LIBNAME Option
- DBCREATE_TABLE_OPTS= LIBNAME Option
- DBGEN_NAME= LIBNAME Option
- DBINDEX= LIBNAME Option
- DBLIBINIT= LIBNAME Option
- DBLIBTERM= LIBNAME Option
- DBLINK= LIBNAME Option
- DBMAX_TEXT= LIBNAME Option
- DBNULLKEYS= LIBNAME Option
- DBPROMPT= LIBNAME Option
- DBSASLABEL= LIBNAME Option
- DBSERVER_MAX_BYTES= LIBNAME Option
- DBSLICEPARM= LIBNAME Option
- DEFER= LIBNAME Option
- DEGREE= LIBNAME Option
- DELETE_MULT_ROWS= LIBNAME Option
- DIRECT_EXE= LIBNAME Option
- DIRECT_SQL= LIBNAME Option
- ENABLE_BULK= LIBNAME Option
- ERRLIMIT= LIBNAME Option
- ESCAPE_BACKSLASH= LIBNAME Option
- IGNORE_ READ_ONLY_COLUMNS= LIBNAME Option
- IN= LIBNAME Option
- INSERT_SQL= LIBNAME Option
- INSERTBUFF= LIBNAME Option
- INTERFACE= LIBNAME Option
- KEYSET_SIZE= LIBNAME Option
- LOCATION= LIBNAME Option
- LOCKTABLE= LIBNAME Option
- LOCKTIME= LIBNAME Option
- LOCKWAIT= LIBNAME Option
- LOGDB= LIBNAME Option
- LOGIN_TIMEOUT= LIBNAME Option
- MAX_CONNECTS= LIBNAME Option
- MULTI_DATASRC_OPT= LIBNAME Option
- OR_ENABLE_INTERRUPT= LIBNAME Option
- OR_UPD_NOWHERE= LIBNAME Option
- PACKETSIZE= LIBNAME Option
- PREFETCH= LIBNAME Option
- PRESERVE_COL_NAMES= LIBNAME Option
- PRESERVE_TAB_NAMES= LIBNAME Option
- QUALIFIER= LIBNAME Option
- QUALIFY_ROWS= LIBNAME Option
- QUERY_TIMEOUT= LIBNAME Option
- QUOTE_CHAR= LIBNAME Option
- QUOTED_IDENTIFIER= LIBNAME Option
- READBUFF= LIBNAME Option
- READ_ISOLATION_LEVEL= LIBNAME Option
- READ_LOCK_TYPE= LIBNAME Option
- READ_MODE_WAIT= LIBNAME Option
- REMOTE_DBTYPE= LIBNAME Option
- REREAD_EXPOSURE= LIBNAME Option
- SCHEMA= LIBNAME Option
- SHOW_SYNONYMS= LIBNAME Option
- SPOOL= LIBNAME Option
- SQL_FUNCTIONS= LIBNAME Option
- SQL_FUNCTIONS_COPY= LIBNAME Option
- STRINGDATES= LIBNAME Option
- TRACE= LIBNAME Option
- TRACEFILE= LIBNAME Option
- UPDATE_ISOLATION_LEVEL= LIBNAME Option
- UPDATE_LOCK_TYPE= LIBNAME Option
- UPDATE_MODE_WAIT= LIBNAME Option
- UPDATE_MULT_ROWS= LIBNAME Option
- UPDATE_SQL= LIBNAME Option
- UPDATEBUFF= LIBNAME Option
- USE_ODBC_CL= LIBNAME Option
- UTILCONN_TRANSIENT= LIBNAME Option
- Data Set Options for Relational Databases
- Overview of Data Set Options for Relational Databases
- AUTHID= Data Set Option
- AUTOCOMMIT= Data Set Option
- BL_ALLOW_READ_ACCESS= Data Set Option
- BL_ALLOW_WRITE_ACCESS= Data Set Option
- BL_BADFILE= Data Set Option
- BL_CODEPAGE= Data Set Option
- BL_CONTROL= Data Set Option
- BL_COPY_LOCATION= Data Set Option
- BL_CPU_PARALLELISM= Data Set Option
- BL_DATA_BUFFER_SIZE= Data Set Option
- BL_DATAFILE= Data Set Option
- BL_DB2CURSOR= Data Set Option
- BL_DB2DEVT_PERM= Data Set Option
- BL_DB2DEVT_TEMP= Data Set Option
- BL_DB2DISC= Data Set Option
- BL_DB2ERR= Data Set Option
- BL_DB2IN= Data Set Option
- BL_DB2LDCT1= Data Set Option
- BL_DB2LDCT2= Data Set Option
- BL_DB2LDCT3= Data Set Option
- BL_DB2LDEXT= Data Set Option
- BL_DB2MAP= Data Set Option
- BL_DB2PRINT= Data Set Option
- BL_DB2PRNLOG= Data Set Option
- BL_DB2REC= Data Set Option
- BL_DB2RECSP= Data Set Option
- BL_DB2RSTRT= Data Set Option
- BL_DB2SPC_PERM= Data Set Option
- BL_DB2SPC_TEMP= Data Set Option
- BL_DB2TBLXST= Data Set Option
- BL_DB2UTID= Data Set Option
- BL_DELETE_DATAFILE= Data Set Option
- BL_DELIMITER= Data Set Option
- BL_DIRECT_PATH= Data Set Option
- BL_DISCARDFILE= Data Set Option
- BL_DISK_PARALLELISM= Data Set Option
- BL_EXCEPTION= Data Set Option
- BL_INDEX_OPTIONS= Data Set Option
- BL_INDEXING_MODE= Data Set Option
- BL_KEEPIDENTITY= Data Set Option
- BL_KEEPNULLS= Data Set Option
- BL_LOAD_METHOD= Data Set Option
- BL_LOAD_REPLACE= Data Set Option
- BL_LOG= Data Set Option
- BL_METHOD= Data Set Option
- BL_OPTIONS= Data Set Option
- BL_PARFILE= Data Set Option
- BL_PORT_MAX= Data Set Option
- BL_PORT_MIN= Data Set Option
- BL_PRESERVE_BLANKS= Data Set Option
- BL_RECOVERABLE= Data Set Option
- BL_REMOTE_FILE= Data Set Option
- BL_SERVER_DATAFILE= Data Set Option
- BL_SQLLDR_PATH= Data Set Option
- BL_SUPPRESS_NULLIF= Data Set Option
- BL_USE_PIPE= Data Set Option
- BL_WARNING_COUNT= Data Set Option
- BUFFERS= Data Set Option
- BULK_BUFFER= Data Set Option
- BULKLOAD= Data Set Option
- BULKUNLOAD= Data Set Option
- CAST= Data Set Option
- CAST_OVERHEAD_MAXPERCENT= Data Set Option
- COMMAND_TIMEOUT= Data Set Option
- CURSOR_TYPE= 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
- DBLINK= Data Set Option
- DBMASTER= Data Set Option
- DBMAX_TEXT= Data Set Option
- DBNULL= Data Set Option
- DBNULLKEYS= Data Set Option
- DBPROMPT= Data Set Option
- DBSASLABEL= Data Set Option
- DBSASTYPE= Data Set Option
- DBSLICE= Data Set Option
- DBSLICEPARM= Data Set Option
- DBTYPE= Data Set Option
- DEGREE= Data Set Option
- DISTRIBUTE_ON= Data Set Option
- ERRLIMIT= Data Set Option
- ESCAPE_BACKSLASH= Data Set Option
- IGNORE_ READ_ONLY_COLUMNS= Data Set Option
- IN= Data Set Option
- INSERT_SQL= Data Set Option
- INSERTBUFF= Data Set Option
- KEYSET_SIZE= Data Set Option
- LOCATION= Data Set Option
- LOCKTABLE= Data Set Option
- MBUFFSIZE= Data Set Option
- ML_CHECKPOINT= Data Set Option
- ML_ERROR1= Data Set Option
- ML_ERROR2= Data Set Option
- ML_LOG= Data Set Option
- ML_RESTART= Data Set Option
- ML_WORK= Data Set Option
- MULTILOAD= Data Set Option
- NULLCHAR= Data Set Option
- NULLCHARVAL= Data Set Option
- OR_PARTITION= Data Set Option
- OR_UPD_NOWHERE= Data Set Option
- ORHINTS= Data Set Option
- PRESERVE_COL_NAMES= Data Set Option
- QUALIFIER= Data Set Option
- QUERY_TIMEOUT= Data Set Option
- READ_ISOLATION_LEVEL= Data Set Option
- READ_LOCK_TYPE= Data Set Option
- READ_MODE_WAIT= Data Set Option
- READBUFF= Data Set Option
- SASDATEFMT= Data Set Option
- SCHEMA= Data Set Option
- SEGMENT_NAME= Data Set Option
- SET= Data Set Option
- SLEEP= Data Set Option
- TENACITY= Data Set Option
- TRAP151= Data Set Option
- UPDATE_ISOLATION_LEVEL= Data Set Option
- UPDATE_LOCK_TYPE= Data Set Option
- UPDATE_MODE_WAIT= Data Set Option
- UPDATE_SQL= Data Set Option
- UPDATEBUFF= Data Set Option
- Macro Variables and System Options for Relational Databases
- Introduction to Macro Variables and System Options for Relational Databases
- Macro Variables for Relational Databases
- System Options for Relational Databases
- DB2CATALOG= System Option
- DBIDIRECTEXEC= System Option
- DBSRVTP= System Option
- SASTRACE= System Option
- SASTRACELOC= System Option
- VALIDVARNAME= System Option
- The Pass-Through Facility for Relational Databases
- DBMS-Specific Reference
- SAS/ACCESS for DB2 under UNIX and PC Hosts
- Introduction to SAS/ACCESS Interface to DB2 under UNIX and PC Hosts
- LIBNAME Statement Specifics for DB2 under UNIX and PC Hosts
- Data Set Options for DB2 under UNIX and PC Hosts
- Pass-Through Facility Specifics for DB2 under UNIX and PC Hosts
- Autopartitioning Scheme for DB2 under UNIX and PC Hosts
- Temporary Table Support for DB2 under UNIX and PC Hosts
- DBLOAD Procedure Specifics for DB2 under UNIX and PC Hosts
- Passing SAS Functions to DB2 under UNIX and PC Hosts
- Passing Joins to DB2 under UNIX and PC Hosts
- Locking for DB2 under UNIX and PC Hosts Interface
- DB2 under UNIX and PC Hosts Bulk Loading
- Naming Conventions for DB2 under UNIX and PC Hosts
- Data Types for DB2 under UNIX and PC Hosts
- SAS/ACCESS Interface for DB2 under z/OS
- Introduction to SAS/ACCESS Interface to DB2 under z/OS
- LIBNAME Statement Specifics for DB2 under z/OS
- Data Set Options for DB2 under z/OS
- Pass-Through Facility Specifics for DB2 under z/OS
- Autopartitioning Scheme for DB2 under z/OS
- Temporary Table Support for DB2 under z/OS
- Calling Stored Procedures in DB2 under z/OS
- ACCESS Procedure Specifics for DB2 under z/OS
- DBLOAD Procedure Specifics for DB2 under z/OS
- The DB2EXT Procedure
- The DB2UTIL Procedure
- Maximizing DB2 under z/OS Performance
- Passing SAS Functions to DB2 under z/OS
- Passing Joins to DB2 under z/OS
- SAS System Options and Settings for DB2 under z/OS
- DB2 under z/OS Bulk Loading
- Locking the DB2 under z/OS Interface
- Naming Conventions for DB2 under z/OS
- Data Types for DB2 under z/OS
- Understanding DB2 under z/OS Client/Server Authorization
- DB2 under z/OS Information for the Database Administrator
- SAS/ACCESS for HP Neoview
- Introduction to SAS/ACCESS Interface to HP Neoview
- LIBNAME Statement Specifics for HP Neoview
- Data Set Options for HP Neoview
- Pass-Through Facility Specifics for HP Neoview
- Passing SAS Functions to HP Neoview
- Passing Joins to HP Neoview
- Temporary Table Support for HP Neoview
- Naming Conventions for HP Neoview
- Data Types for HP Neoview
- SAS/ACCESS for Informix
- Introduction to SAS/ACCESS Interface to Informix
- LIBNAME Statement Specifics for Informix
- Data Set Options for Informix
- Pass-Through Facility Specifics for Informix
- Autopartitioning Scheme for Informix
- Passing SAS Functions to Informix
- Passing Joins to Informix
- Temporary Table Support for Informix
- Locking in the Informix Interface
- Naming Conventions for Informix
- Data Types for Informix
- Overview of Informix Servers
- SAS/ACCESS for Microsoft SQL Server
- Introduction to SAS/ACCESS Interface to Microsoft SQL Server
- LIBNAME Statement Specifics for Microsoft SQL Server
- Data Set Options for Microsoft SQL Server
- Pass-Through Facility Specifics for Microsoft SQL Server
- DBLOAD Procedure Specifics for Microsoft SQL Server
- Passing SAS Functions to Microsoft SQL Server
- Locking in the Microsoft SQL Server Interface
- Naming Conventions for Microsoft SQL Server
- Data Types for Microsoft SQL Server
- SAS/ACCESS for MySQL
- Introduction to SAS/ACCESS Interface to MySQL
- LIBNAME Statement Specifics for MySQL
- Data Set Options for MySQL
- Pass-Through Facility Specifics for MySQL
- Autocommit and Table Types
- Understanding MySQL Update and Delete Rules
- Passing SAS Functions to MySQL
- Passing Joins to MySQL
- Naming Conventions for MySQL
- Case Sensitivity for MySQL
- Data Types for MySQL
- SAS/ACCESS for Netezza
- Introduction to SAS/ACCESS Interface to Netezza
- LIBNAME Statement Specifics for Netezza
- Data Set Options for Netezza
- Pass-Through Facility Specifics for Netezza
- Passing SAS Functions to Netezza
- Passing Joins to Netezza
- Temporary Table Support for Netezza
- Netezza Bulk Loading and Unloading
- Naming Conventions for Netezza
- Data Types for Netezza
- SAS/ACCESS for ODBC
- Introduction to SAS/ACCESS Interface to ODBC
- LIBNAME Statement Specifics for ODBC
- Data Set Options for ODBC
- Pass-Through Facility Specifics for ODBC
- Autopartitioning Scheme for ODBC
- DBLOAD Procedure Specifics for ODBC
- Passing SAS Functions to ODBC
- Passing Joins to ODBC
- Temporary Table Support for ODBC
- ODBC Bulk Loading
- Locking in the ODBC Interface
- Naming Conventions for ODBC
- Data Types for ODBC
- SAS/ACCESS for OLE DB
- Introduction to SAS/ACCESS Interface to OLE DB
- LIBNAME Statement Specifics for OLE DB
- Data Set Options for OLE DB
- Pass-Through Facility Specifics for OLE DB
- Passing SAS Functions to OLE DB
- Passing Joins to OLE DB
- Temporary Table Support for OLE DB
- OLE DB Bulk Loading
- Locking in the OLE DB Interface
- Accessing OLE DB for OLAP Data
- Naming Conventions for OLE DB
- Data Types for OLE DB
- SAS/ACCESS for Oracle
- Introduction to SAS/ACCESS Interface to Oracle
- LIBNAME Statement Specifics for Oracle
- Data Set Options for Oracle
- Pass-Through Facility Specifics for Oracle
- Autopartitioning Scheme for Oracle
- Temporary Table Support for Oracle
- ACCESS Procedure Specifics for Oracle
- DBLOAD Procedure Specifics for Oracle
- Maximizing Oracle Performance
- Passing SAS Functions to Oracle
- Passing Joins to Oracle
- Oracle Bulk Loading
- Locking in the Oracle Interface
- Naming Conventions for Oracle
- Data Types for Oracle
- SAS/ACCESS for Sybase
- Introduction to SAS/ACCESS Interface to Sybase
- LIBNAME Statement Specifics for Sybase
- Data Set Options for Sybase
- Pass-Through Facility Specifics for Sybase
- Autopartitioning Scheme for Sybase
- Temporary Table Support for Sybase
- ACCESS Procedure Specifics for Sybase
- DBLOAD Procedure Specifics for Sybase
- Passing SAS Functions to Sybase
- Passing Joins to Sybase
- Reading Multiple Sybase Tables
- Locking in the Sybase Interface
- Naming Conventions for Sybase
- Case Sensitivity in Sybase
- Data Types for Sybase
- National Language Support for Sybase
- SAS/ACCESS for Teradata
- Introduction to SAS/ACCESS Interface to Teradata
- LIBNAME Statement Specifics for Teradata
- Data Set Options for Teradata
- Pass-Through Facility Specifics for Teradata
- Autopartitioning Scheme for Teradata
- Passing SAS Functions to Teradata
- Passing Joins to Teradata
- Temporary Table Support for Teradata
- Maximizing Teradata Read Performance
- Maximizing Teradata Load Performance
- Teradata Processing Tips for SAS Users
- Locking in the Teradata Interface
- Naming Conventions for Teradata
- Data Types for Teradata
- Sample Code
- Accessing DBMS Data with the LIBNAME Statement
- Accessing DBMS Data with the Pass-Through Facility
- Sample Data for SAS/ACCESS for Relational Databases
- Introduction to the Sample Data
- Descriptions of the Sample Data
- Description of the March DBMS Data
- Description of the Delay DBMS Data
- Description of the InterNat DBMS Data
- Description of the Schedule DBMS Data
- Description of the Payroll DBMS Data
- Description of the Payroll2 DBMS Data
- Description of the Staff DBMS Data
- Description of the Superv DBMSData
- Description of the Invoices DBMSData
- Description of the Employees DBMS Data
- Description of the Customers DBMS Data
- Description of the Faborder DBMS Data
- Description of the TempEmps SAS Data Set
- Converting SAS/ACCESS Descriptors to PROC SQL Views
- Appendixes
- The ACCESS Procedure for Relational Databases
- The DBLOAD Procedure for Relational Databases
- Overview of the DBLOAD Procedure for Relational Databases
- DBMS Specifics for the DBLOAD Procedure
- Procedure Syntax
- PROC DBLOAD Statement
- Database Connection Statements
- ACCDESC= Statement
- COMMIT= Statement
- DELETE Statement
- ERRLIMIT= Statement
- LABEL Statement
- LIMIT= Statement
- LIST Statement
- LOAD Statement
- NULLS Statement
- QUIT Statement
- RENAME Statement
- RESET Statement
- SQL Statement
- TABLE= Statement
- TYPE Statement
- WHERE Statement
- Example of Using the DBLOAD Procedure
- Recommended Reading
- Glossary
Index here
| Product | Release |
|---|---|
| SAS/ACCESS Interface to HP Neoview | 9.2 |
| SAS/ACCESS Interface to Informix | 9.2 |
| SAS/ACCESS Interface to DB2 | 9.2 |
| SAS/ACCESS Interface to Sybase | 9.2 |
| SAS/ACCESS Interface to MySQL | 9.2 |
| SAS/ACCESS Interface to Oracle | 9.2 |
| SAS/ACCESS Interface to Microsoft SQL Server | 9.2 |
| SAS/ACCESS Interface to Teradata | 9.2 |
| SAS/ACCESS Interface to Netezza | 9.2 |
| SAS/ACCESS Interface to ODBC | 9.2 |
| SAS/ACCESS Interface to OLE DB | 9.2 |
| SAS/ACCESS Product of Choice |
- Type
- Usage and Reference
- Copyright Date
- March 2008
- Last Updated
- 30Apr2008
 |
|
| Previous Page | | | Next Page |
| Data Integrity and Security |
Introduction to Data Integrity and Security
This section briefly describes DBMS security issues and then presents measures you can take on the SAS side of the interface to help protect DBMS data from accidental update or deletion. This section also provides information about how how SAS handles null values that will help you achieve consistent results.
|
|
| Previous Page | | | Next Page | | | Top of Page |
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.