search:
Search support.sas.com
KNOWLEDGE BASE
System Requirements
Install Center
Product Documentation
Papers
Samples & SAS Notes
Focus Areas
SUPPORT
License Assistance
Administrator Services
Downloads & Hot Fixes
LEARNING CENTER
Bookstore
Training
Certification
SAS Learning Edition
Higher Education Resources
SAS OnDemand For Academics
COMMUNITY
User Groups
Events
E-Newsletters
Advanced Search
support.sas.com
KNOWLEDGE BASE
SUPPORT
LEARNING CENTER
COMMUNITY
Product Documentation
>
SAS 9.2 Documentation
Print
|
E-mail
|
Bookmark
|
Feedback
SAS(R) 9.2 Table Server Administrator's Guide
PDF
Contents
About
New Products in SAS 9.2: SAS Table Server
Introduction
Using This Guide
About the SAS Table Server Administrator's Guide
Intended Audience
See Also
Accessibility Features of the SAS Table Server
Software Installation and Configuration
About the Software Installation and Configuration
Packaging and Distribution
Concepts
Understand the SAS Table Server
What Is the SAS Table Server?
Services Provided by the SAS Table Server
Components Provided by the SAS Table Server
SAS Table Server Data Sources
What Is a Data Source?
What Are the Supported Data Sources?
Database Functionality Supported by Data Sources
Data Source Data Types
Overview: Data Types
Define Data Types for a Column
Translate SQL and Client API Data Types
Schemas and Catalogs
About Schemas and Catalogs
Organize Data with a Schema
Organize Data with a Catalog
Data Source Connection
Overview: Data Source Connection
Submit a Connection String
SAS Table Server Metadata Administration
Introduction to the SAS Table Server Metadata Administration
Understand Administering with Metadata
About the Metadata Definitions
User and Group Administration
User and Group Definition Administration
SAS Table Server Administrator Accounts
SAS Table Server Metadata Definition Administration
Overview: SAS Table Server Metadata Definition Administration
SAS Table Server Configuration
Data Source Configuration
Data Access Configuration
Manage a Running SAS Table Server on SAS Management Console
About SAS Management Console's Server Features
Monitor the SAS Table Server
Validate the SAS Table Server
Operate the SAS Table Server
Change the SAS Table Server Default Rowset Buffer Size
METALIB Procedure for the SAS Table Server
Overview: METALIB Procedure for the SAS Table Server
Syntax: METALIB Procedure for the SAS Table Server
PROC METALIB Statement for the SAS Table Server
OMR Statement
CONNECT Statement
EXCLUDE or SELECT Statement
UPDATE_RULE Statement
NOEXEC Statement
Concepts: METALIB Procedure for the SAS Table Server
Results: METALIB Procedure for the SAS Table Server
Examples: METALIB Procedure for the SAS Table Server
Identify the Data Source by Using a DSN Definition
Identify the Table Server and the Data Source with a Connection String
SAS Table Server Security
Understand the SAS Table Server Security
SAS Table Server Security Features
Authentication
Single Sign-On
Authorization
Encryption
Security Coupling
Secure Data Access with SAS Metadata-Based Permissions
Overview: Secure Data Access with SAS Metadata-Based Permissions
About the SAS Table Server Permissions
Default Permission Settings
Inherited Permission Settings
Set Permissions on Metadata Definitions
SAS Table Server Row-Level Permissions
SAS Table Server System Administration
Configuration Files and Scripts
About the Configuration Files and Scripts
SAS Logging Facility Configuration File
Configuration Files
SAS Table Server Invocation Options
Metaprofile.xml File
SAS Table Server Logging and Tracing
SAS Logging Facility
SAS Log
Trace Log
File DSNs
About File DSNs
XML Elements That Define a File DSN
Create a File DSN by Using Connection String Options
Client Application Administration
Cursor Support
Connection String Options for Client-Side Drivers
Data Source Reference
SAS Data Set Reference
Overview: SAS Data Set Reference
Understand the BASE Table Driver
Database Functionality Support for SAS Data Sets
Data Source Connection Arguments for SAS Data Sets
Data Types for SAS Data Sets
SAS Column Labels for SAS Data Sets
Optimize Performance for SAS Data Sets
Indexes for SAS Data Sets
Audit Trail for SAS Data Sets
Integrity Constraints for SAS Data Sets
Generation Data Sets for SAS Data Sets
Cross-Environment Data Access (CEDA) for SAS Data Sets
Identifier Case Sensitivity for SAS Data Sets
Security for SAS Data Sets
Numeric Column Length for SAS Data Sets
Naming Conventions and Attributes for SAS Data Sets
National Language Support (NLS)
SPD Data Set Reference (Preproduction)
Overview: SPD Data Set Reference
Understand the SPD Table Driver
File Formats for SPD Data Sets
Database Functionality Support for SPD Data Sets
Data Source Connection Arguments for SPD Data Sets
Configuration Settings for SPD Data Sets
Data Types for SPD Data Sets
Identity Column for SPD Data Sets
SAS Column Labels for SPD Data Sets
Optimize Performance for SPD Data Sets
Identifier Case Sensitivity for SPD Data Sets
Indexes for SPD Data Sets
Security for SPD Data Sets
Numeric Column Length for SPD Data Sets: SPDC File Format
Naming Conventions and Attributes for SPD Data Sets
Utility File Workspace for SPD Data Sets
DB2 for UNIX and PC Hosts Reference
Overview: DB2 for UNIX and PC Hosts Reference
Understand the DB2 Table Driver
Database Functionality Support for DB2 under UNIX and PC Hosts
Data Source Connection Arguments for DB2 under UNIX and PC Hosts
Data Types for DB2 under UNIX and PC Hosts
Load Data by Using Bulk Operations for DB2 under UNIX and PC Hosts
Locking for DB2 under UNIX and PC Hosts
Naming Conventions for DB2 under UNIX and PC Hosts
MySQL Reference
Overview: MySQL Reference
Understand the MySQL Table Driver
Database Functionality Support for MySQL
Data Source Connection Arguments for MySQL
Data Types for MySQL
Naming Conventions for MySQL
ODBC Reference
Overview: ODBC Reference
Understand the ODBC Table Driver
Database Functionality Support for ODBC
Data Source Connection Arguments for ODBC
Data Types for ODBC
Locking for ODBC
Naming Conventions for ODBC
Oracle Reference
Overview: Oracle Reference
Understand the Oracle Table Driver
Database Functionality Support for Oracle
Data Source Connection Arguments for Oracle
Data Types for Oracle
Load Data by Using Bulk Operations for Oracle
Locking for Oracle
Naming Conventions for Oracle
Teradata Reference
Overview: Teradata Reference
Understand the Teradata (TERA) Table Driver
Database Functionality Support for Teradata
Data Source Connection Arguments for Teradata
Data Types for Teradata
Locking in Teradata
Naming Conventions for Teradata
Appendixes
Recommended Reading
Glossary
Index here
Product
Release
SAS Table Server
9.2
Type
Administration and Configuration
Copyright Date
February 2009
Last Updated
26Feb2009
SAS 9.2 Table Server Administrator's Guide