Contents
About
SAS/ACCESS Interface to IMS: Introduction
Overview of the SAS/ACCESS Interface to IMS
Introduction to the SAS/ACCESS Interface to IMS
Purpose of the SAS/ACCESS Interface to IMS
Using the SAS/ACCESS Interface to IMS
SAS/ACCESS Descriptor Files for IMS
Executing SAS/ACCESS Programs in Batch Mode
Executing SAS/ACCESS Programs under TSO
About the Example Data in the Document
IMS Essentials
Introduction to IMS Essentials
The IMS DBMS
Overview of IMS Databases
Physical Databases and Program Views
DL/I Calls
IMS Execution Modes
Shared IMS Database Access
The IMS Engine Interface: Usage
Defining SAS/ACCESS Descriptor Files
Introduction to Defining SAS/ACCESS Descriptor Files
SAS/ACCESS Descriptor Files Essentials
Creating and Using Descriptor Files
Using View Descriptors in SAS Programs
IMS Data in SAS Programs
Introduction to Using IMS Data in SAS Programs
Charting IMS Data
Results of Charting IMS Data
Calculating Statistics with IMS Data
Selecting and Combining IMS Data
Updating a SAS Data File with IMS Data
Example of VALIDVARNAME=V7
Data in the Data File to be Updated, MYDATA.SSNUMS
Data That is Described by Updated Data File MYDATA.NEWNUMS
Results of Updating a Version 7 or Later SAS Data File with IMS Data
Browsing and Updating IMS Data
Introduction to Browsing and Updating IMS Data
Browsing and Updating IMS Data with SAS/FSP Procedures
Browsing and Updating IMS Data with the SQL Procedure
Updating SAS Files with IMS Data
Appending IMS Data with the APPEND Procedure
SAS/ACCESS Interface to the IMS Engine: Reference
ACCESS Procedure Reference
Introduction to ACCESS Procedure Reference
ACCESS Procedure Syntax for IMS
Description
PROC ACCESS Statement Options
SAS Passwords for SAS/ACCESS Descriptors
Invoking the ACCESS Procedure
Database-Description Statements
Editing Statements
ASSIGN= Statement
CREATE (Access Descriptor) Statement
CREATE (View Descriptor) Statement
DATABASE= Statement
DELETE Statement
DROP Statement
FORMAT Statement
GROUP= Statement
INSERT Statement
ITEM= Statement
LIST Statement
QUIT Statement
RECORD= Statement
RENAME Statement
REPLACE Statement
RESET Statement
SELECT Statement
SUBSET Statement
UNIQUE = Statement
UPDATE Statement
Tools for Creating IMS Access Descriptors
Performance and Efficient View Descriptors
Advanced User Topics
Introduction to Advanced Topics for the Interface View Engine
Changing an IMS Database and the Effects on Descriptors
Changes That Cause Existing View Descriptors to Fail
Understanding Character Set Encoding
Ensuring IMS Data Security
Maximizing IMS Performance
Understanding the IMS Interface
IMS Engine Calls to the Database
The IMS DATA Step Interface: Reference
Overview of the IMS DATA Step Interface
Introduction to the IMS DATA Step Interface
DATA Step Statement Extensions
Example of Using DATA Step Views
The DL/I INFILE Statement
The DL/I INPUT Statement
The DL/I FILE Statement
The DL/I PUT Statement
IMS DATA Step Examples
How to Use the IMS DATA Step Interface
Introduction to Using the IMS DATA Step Interface
z/OS DL/I System Calls
Fast Path DL/I Database Access
Non-Database Access Calls
Advanced Topics for the IMS DATA Step Interface
Introduction to Advanced Topics for the IMS DATA Step Interface
Restarting an Update Program
SSAs in IMS DATA Step Programs
Appendixes
SAS System Options for IMS Databases
Introduction to SAS System Options for IMS Databases
Specifying System Options
SAS System Options for IMS
BMPREAD= SAS System Option
DLIREAD= SAS System Option
IMSBPAGN= SAS System Option
IMSBPCPU= SAS System Option
IMSBPDCA= SAS System Option
IMSBPIN= SAS System Option
IMSBPNBA= SAS System Option
IMSBPOBA= SAS System Option
IMSBPOPT= SAS System Option
IMSBPOUT= SAS System Option
IMSBPPAR= SAS System Option
IMSBPSTI= SAS System Option
IMSBPUPD= SAS System Option
IMSDEBUG= SAS System Option
IMSDLBKO= SAS System Option
IMSDLBUF= SAS System Option
IMSDLDBR= SAS System Option
IMSDLEXC= SAS System Option
IMSDLFMT= SAS System Option
IMSDLIRL= SAS System Option
IMSDLIRN= SAS System Option
IMSDLLOG= SAS System Option
IMSDLMON= SAS System Option
IMSDLSRC= SAS System Option
IMSDLSWP= SAS System Option
IMSDLUPD= SAS System Option
IMSID= SAS System Option
IMSIOB= SAS System Option
IMSREGTP= SAS System Option
IMSSPIE= SAS System Option
IMSTEST= SAS System Option
IMSWHST= SAS System Option
Quick Reference for Options
Example Data
Introduction to IMS Example Data
Access Descriptors for IMS
View Descriptors Based on the Access Descriptors for IMS
Creating SAS Data Sets for IMS
SAS Statements for Loading DB2 Table BANKCHRG
Recommended Reading
Glossary
Product
Release
SAS/ACCESS Interface to IMS-DL/I
9.2
Type
Usage and Reference
Copyright Date
March 2008
Last Updated
15Apr2008