SAS ACCESS 9.1 Interface to IMS: Reference

✍ Scribed by The SAS Technical Team Writers

• Publisher: SAS Publishing
• Year: 2004
• Tongue: English
• Leaves: 313
• Category: Library

✦ Synopsis

The SAS/ACCESS interface to IMS brings together the resources you need for effective information delivery. SAS/ACCESS software provides an interface between SAS and the IMS database management system (DBMS). In this title you will learn how to perform the following tasks: create SAS/ACCESS descriptor files using the ACCESS procedure, directly access data in IMS databases from a SAS program using the view descriptor files created with the ACCESS procedure, extract data from IMS databases and place it in SAS data files using the ACCESS procedure, the DATA step, or other SAS procedures, update, insert, or delete data in IMS databases using the SQL procedure, SAS/FSP software, the APPEND procedure, or the MODIFY statement (the MODIFY statement can be used with the IMS interface view engine, and supports REPLACE, DELETE, and INSERT calls), and issue DL/I calls to update, insert, and delete data in IMS databases using the DATA step interface's INFILE, INPUT, FILE, and PUT statements. Consider this title your source for complete details on accessing IMS data with SAS. The ACCESS procedure has been enhanced to include new statements and options. This title is designed for users who need complete reference information for using IMS data with SAS.

✦ Table of Contents

Cover......Page 1
Overview......Page 8
SAS/ACCESS Interface to IMS: Introduction......Page 10
Purpose of the SAS/ACCESS Interface to IMS......Page 12
How the IMS Engine and DATA Step Interfaces Differ......Page 13
SAS/ACCESS Descriptor Files for IMS......Page 14
View Descriptor Files......Page 15
DD Statements......Page 16
About the Example Data in the Document......Page 17
Running the Examples in This Document......Page 18
Introduction to IMS Essentials......Page 20
Overview of IMS Databases......Page 21
Segment Occurrences......Page 23
Segment Relationships......Page 24
Path Navigation......Page 25
Fields......Page 26
What You Need to Know to Create Descriptors......Page 27
Database Description......Page 28
Program Specification Block......Page 33
DL/I Call Functions......Page 34
Program Communication Block......Page 35
Segment Search Arguments......Page 37
IMS Execution Modes......Page 39
Outline of a Batch DL/I Subsystem......Page 40
Outline of an Online DL/I Subsystem......Page 42
Shared IMS Database Access......Page 43
General Considerations for Sharing Resources......Page 44
Database-Level Shared Access......Page 45
Block-Level Shared Access......Page 46
The IMS Engine Interface: Usage......Page 48
SAS/ACCESS Descriptor Files Essentials......Page 50
Creating Access and View Descriptors in One PROC Step......Page 51
Creating Access and View Descriptors in Separate PROC Steps......Page 53
Printing Data......Page 54
Reviewing Variables......Page 56
Charting IMS Data......Page 58
Calculating Statistics with IMS Data......Page 59
Calculating Statistics Using the MEANS Procedure......Page 60
Calculating Statistics Using the RANK Procedure......Page 64
Selecting and Combining Data Using the WHERE Statement......Page 65
Selecting and Combining Data Using the SAS SQL Procedure......Page 69
Example of VALIDVARNAME=V6......Page 73
Example of VALIDVARNAME=V7......Page 75
Introduction to Browsing and Updating IMS Data......Page 80
Browsing Data Using the FSBROWSE Procedure......Page 81
Updating Data Using the FSEDIT Procedure......Page 82
Browsing and Updating Data Using the FSVIEW Procedure......Page 83
Specifying a SAS WHERE Statement While Browsing or Updating Data......Page 84
Scrolling with SAS/FSP Procedures......Page 85
Inserting and Deleting Segments with SAS/FSP Procedures......Page 86
Browsing and Updating IMS Data with the SQL Procedure......Page 87
Retrieving and Updating Data with the SQL Procedure......Page 88
Inserting and Deleting Data with the SQL Procedure......Page 91
Updating Data with the MODIFY Statement......Page 92
Updating SAS Files with IMS Data......Page 94
Appending IMS Data with the APPEND Procedure......Page 98
SAS/ACCESS Interface to the IMS Engine: Reference......Page 102
Introduction to ACCESS Procedure Reference......Page 104
Description......Page 105
SAS Passwords for SAS/ACCESS Descriptors......Page 106
Assigning Passwords......Page 107
Invoking the ACCESS Procedure......Page 109
Database-Description Statements......Page 110
ACCESS Procedure Statements for IMS......Page 111
COB2SAS Tool......Page 132
Extracting Data Using a View......Page 133
Deciding How to Subset Your Data......Page 134
Writing Efficient WHERE Statements......Page 135
Identifying Inefficient SAS WHERE Conditions......Page 136
Identifying SAS WHERE Conditions That Are Not Acceptable to IMS......Page 137
Introduction to Advanced Topics for the Interface View Engine......Page 140
Understanding Character Set Encoding......Page 141
SAS Security......Page 142
Understanding the Flattened File Concept......Page 143
Handling Special Fields......Page 145
Data Retrieval......Page 150
Data Retrieval by Using a Secondary Index......Page 155
Data Modification Processing......Page 157
The IMS DATA Step Interface: Reference......Page 160
Introduction to the IMS DATA Step Interface......Page 162
DL/I Input and Output Buffers......Page 163
An Introductory Example of a DATA Step Program......Page 164
Example of Using DATA Step Views......Page 168
The DL/I INFILE Statement......Page 171
PCB Selection Options......Page 172
Other DL/I INFILE Options......Page 173
Using the DL/I INFILE Statement......Page 177
The DL/I INPUT Statement......Page 180
Example 1: A Get Call......Page 182
Using the DL/I INPUT Statement......Page 183
The DL/I PUT Statement......Page 187
Example 3: An Update Call......Page 188
Using the DL/I PUT Statement......Page 189
IMS DATA Step Examples......Page 192
Example 6: Issuing Path Calls......Page 193
Example 7: Updating Information in the CUSTOMER Segment......Page 196
Example 8: Using the Blank INPUT Statement......Page 199
Example 9: Using the Qualified SSA......Page 202
Introduction to Using the IMS DATA Step Interface......Page 206
OS/390 DL/I System Calls......Page 207
FLD Call......Page 208
Non-Database Access Calls......Page 209
TP PCBs......Page 210
Basic CHKP Call......Page 212
LOG Call......Page 214
ROLB Call......Page 215
IMS/ESA BMP System Calls......Page 216
IMS/ESA Message Queue Access......Page 221
Restarting an Update Program......Page 228
Examples......Page 229
The PUT Function......Page 244
Setting SSAs Conditionally......Page 246
Changing SSA Variable Values between Calls......Page 247
Specifying System Options......Page 248
Overriding Option Defaults......Page 249
SAS System Options for IMS......Page 250
Detailed Reference for Options......Page 251
Quick Reference for Options......Page 262
Introduction to IMS Example Data......Page 264
ACCTDBD Database Access Descriptor......Page 265
EMPLINF2 Database Access Descriptor......Page 267
WIRETRAN Database Access Descriptor......Page 268
ACCTDBD Database View Descriptors......Page 269
WIRETRAN Database View Descriptor......Page 271
MYDATA.CHECKS Data Set......Page 272
MYDATA.CHKCRED Data Set......Page 273
MYDATA.CHKDEBD Data Set......Page 275
MYDATA.EMPLDATA Data Set......Page 279
MYDATA.INITSEG Data Set......Page 282
MYDATA.PHONENUM Data Set......Page 283
MYDATA.SAVCRED Data Set......Page 284
MYDATA.SAVDEBD Data Set......Page 285
MYDATA.CUSTOMER Data Set......Page 287
VER6.SSNUMS Data Set......Page 288
Loading DB2 Table BANKCHRG from MYDATA.BANK......Page 289
DB2 View Descriptor for BANKCHRG......Page 290
Recommended Reading......Page 292
Glossary......Page 294
Index......Page 304