Contents
About
Title Page
Product Notes
SAS Scalable Performance Data (SPD) Server Product Notes
Overview
What’s New in SPD Server 4.53?
What's New in SPD Server 4.52?
What's New in SPD Server 4.5?
SPD Server Usage
SAS Scalable Performance Data (SPD) Server Overview
Introduction to SAS Scalable Performance Data (SPD) Server
The SPD Server Client/Server Model
Accessing SPD Server Using SAS
Securing SAS Data
Organizing SAS Data
SPD Server Performance Enhancements
SPD Server Extensions to Base SAS
Using SPD Server with Data Warehousing
Connecting to SAS Scalable Performance Data (SPD) Server
Introduction
SAS and SPD Server Tables
SPD Server Resource Security
Accessing SPD Server from a SAS Client
SPD Server Table Options
SPD Server Macro Variables
Accessing and Creating SAS Scalable Performance Data (SPD) Server Tables
Introduction
Using a LIBNAME Statement to Access SPD Server
Managing Large SPD Server Files
Migrating Tables between SAS and SPD Server
The SQL Pass-Through Facility
Creating a New Table
Indexing, Sorting, and Manipulating SAS Scalable Performance Data (SPD) Server Tables
Introduction
Indexing a Table
Creating SPD Server Indexes Examples
Using SAS Scalable Performance Data (SPD) Server with Other Clients
Overview
Using ODBC to Access SPD Server Tables
Using JDBC to Access SPD Server Tables
Using htmSQL to Access SPD Server Tables
Using SQL C API to Access SPD Server Tables
SAS Scalable Performance Data (SPD) Server Dynamic Cluster Tables
Introduction to Dynamic Cluster Tables
Dynamic Cluster Table Structure
Benefits of Dynamic Cluster Tables
Creating and Controlling Dynamic Cluster Tables
Dynamic Cluster BY Clause Optimization
Member Table Requirements for Creating Dynamic Cluster Tables
Querying and Reading Member Tables in a Dynamic Cluster
Unsupported Features in Dynamic Cluster Tables
Dynamic Cluster Table Examples
SPD Server SQL Features
SPD Server SQL Features
SPD Server SQL Planner
Connecting to the SPD Server SQL Engine
Specifying SPD Server SQL Planner Options
Important SPD Server SQL Planner Options
Parallel Join Facility
Parallel Group-By Facility
Parallel Group-By SQL Options
SPD Server STARJOIN Facility
STARJOIN Options
STARJOIN Facility Reference
SPD Server Index Scan
Optimizing Correlated Queries
Correlated Query Options
SPD Server Views
View Access Inheritance
Materialized Views
SPD Server SQL Extensions
Differences between SAS SQL and SPD Server SQL
SPD Server SQL Reference
SPD Server SQL Syntax Reference Guide
Overview
Document Conventions
SQL Syntax Definitions
SQL Statements
NEW SQL Statements
SQL Building Blocks
SAS Scalable Performance Data (SPD) Server SQL Access Library API Reference
Introduction
Overview of SPQL Usage
SPQL API Description
SPQL API Functions
SPQL Function Return Codes
SPD Server Reference
Optimizing SPD Server Performance
SPD Server Performance and Usage Tips
Symmetric Multiple Processor (SMP) Utilization
File System Performance Concepts
LIBNAME Domains
Loading Data into an SPD Server Host
Table Loading Techniques
Loading Indexes in Parallel
Truncating Tables
Optimizing WHERE Clauses
SPD Server Indexing
WHERE Clause Planner
How to Affect the WHERE Planner
Identical Parallel WHERE Clause Subsetting Results
WHERE Clause Examples
Server-Side Sorting
SPD Server Macro Variables
Introduction
Variable for Compatibility with the Base SAS Engine
Variables for Miscellaneous Functions
Variables for Sorts
Variables for WHERE Clause Evaluations
Variables That Affect Disk Space
Variables to Enhance Performance
Variable for a Client and a Server Running on the Same UNIX Machine
SPD Server LIBNAME Options
Introduction
Options to Locate an SPD Server Host
Options to Identify the SPD Server Client
Options to Specify Implicit SQL Pass-Through
Options to Specify File Paths for Table Storage
Options for Access Control Lists (ACLs)
Options for a Client and Server Running on the Same UNIX Machine
Options for Other Functions
SPD Server Table Options
Introduction
Option for Compatibility with Base SAS Software
Options That Affect Disk Space
Options to Enhance Performance
Option to Test Performance
Options for WHERE Clause Evaluations
Options for Other Functions
Options for Security
SPD Server Formats and Informats
Introduction
Formats
User-Defined Formats Example
Informats
SPD Server NLS Support
Overview of NLS
Character Encoding
Moving Data across Environments with Different Encodings
Base SAS Encoding Behavior
Setting the Encoding for Base SAS Sessions
Changing the Encoding for Base SAS Sessions
NLS Support in SPD Server
Appendix
SPD Server Frequently Asked Questions
SPD Server Frequently Asked Questions
Product
Release
SAS Scalable Performance Data Server
4.53
Type
Usage and Reference
Copyright Date
July 2011
Last Updated
09Jul2011