|Overview of the SAS/ACCESS Interface to IMS|
|How to Use the Example Data|
This document uses two HDAM IMS databases, the ACCTDBD database and the WIRETRN database. These databases were created for a bank, and they contain data about the bank's customers and their checking and savings account transactions. The seven ACCTDBD database segments are named CUSTOMER, CHCKACCT, CHCKDEBT, CHCKCRDT, SAVEACCT, SAVEDEBT, and SAVECRDT. The WIRETRN database has one segment, WIRETRAN, and includes only data pertaining to wire transfers of money. All the data in the document is fictitious.
Note: These databases are designed to show how the interface treats IMS-DL/I data. They are not meant as an example for you to follow in designing databases for any purpose.
Appendix 2 gives more information about the ACCTDBD database and the data it contains. Appendix 2 also includes definitions of all the view descriptors referenced in this document and all the SAS data files and statements used to create them. Defining SAS/ACCESS Descriptor Files provides information about the WIRETRN database and definitions of the view descriptors used in the examples.
|Running the Examples in This Document|
To run the examples based on the ACCTDBD and WIRETRN databases, you must first load the database files and define the access and view descriptors shown in Appendix 2. Use the sample library files described here.
contains the source programs for loading the ACCTDBD, EMPLINF2, and WIRETRN database files for both the engine interface and DATA step. It includes the JCL used to allocate the IMS databases, to create DBDs and PSBs, and to create needed flat files.