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 |
| SAS Names and Support for DBMS Names |
Renaming DBMS Data
| Renaming SAS/ACCESS Tables |
You can rename DBMS tables and views using the CHANGE statement, as shown in the following example:
proc datasets lib=x; change oldtable=newtable; quit;
You can rename tables using this method for the following engines:
| DB2 UNIX/PC | Netezza |
| DB2 z/OS | ODBC |
| HP Neoview | OLE DB |
| Informix | Oracle |
| Microsoft SQL Server | Sybase |
| MySQL | Teradata |
Note: If you change a table name, any view that depends
on that table will no longer work unless the view references the new table
name. ![[cautionend]](../../../../common/61925/HTML/default/images/cautend.gif)
| Renaming SAS/ACCESS Columns |
You can use the RENAME statement to rename the 8-character default SAS variable names to long DBMS column names when you load the data into a DBMS table. You can also use the SAS data set option RENAME= to rename the columns after they are loaded into the DBMS.
| Renaming SAS/ACCESS Variables |
You can use the RENAME statement to specify 8-character SAS variable names such as access descriptors and view descriptors.
|
|
| Previous Page | | | Next Page | | | Top of Page |
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.