Chapter Contents |
Previous |
Next |
SAS/ACCESS Interface to IMS-DL/I Software |
ACCTDBD Database View Descriptors |
This section shows SAS statements used to create the view descriptors for the ACCTDBD database used in the examples in this book. The ACCTDBD database is described in Understanding IMS-DL/I Essentials. The view descriptors are presented here in alphabetical order for easy reference.
You can create all the view descriptors used in the book by using PROC ACCESS statements. The view descriptors are based on the MYLIB.ACCOUNT access descriptor shown earlier in this appendix.
proc access dbms=ims ad=mylib.account; create vlib.account.view psb=accupsb; select soc_sec_number customer_name city state zip_code; list view; create vlib.cdbtdate.view psb=accupsb; select check_account_number check_date; list view; create vlib.chckacct.view psb=accupsb; select soc_sec_number customer_name check_account_number check_date check_balance; list view; create vlib.chkcrd.view psb=accupsb pcb=2; select customer_record checking_account_record checking_credit_record; reset 17 28; list view; create vlib.chkdeb.view psb=accupsb pcb=3; select customer_record checking_account_record checking_debit_record; reset 17 22; list view; create vlib.chktrans.view psb=accupsb; select customer_name check_account_number check_date check_balance; list view; create vlib.credits.view psb=accupsb; select soc_sec_number check_account_number check_credit_amount check_credit_date check_credit_time check_credit_desc; list view; create vlib.custacct.view psb=accupsb; select soc_sec_number customer_name check_account number; list view; create vlib.custinfo.view psb=accupsb; select 2 3 5 6 7 8 9 10 11 12; list view; create vlib.custphon.view psb=accupsb; select soc_sec_number customer_name home_phone office_phone; list view; create vlib.savebal.view psb=accupsb; select soc_sec_number customer_name city 32 36; list view; create vlib.ssname.view psb=accupsb; select soc_sec_number customer_name; list view; create vlib.trans.view psb=accupsb; select soc_sec_number check_account_number check_debit_amount; list view; run;
EMPLINF2 Database View Descriptors |
proc access dbms=ims accdesc=mylib.employee; create vlib.emplload.view psbname=empilpsb; select employee_record; list view; create vlib.emplview.view psbname=empiupsb; select employee_record; list view; create vlib.empbday.view psbname=empiupsb; select employee_id last_name first_name birthday phone_extension; list view; run;
WIRETRAN Database View Descriptor |
proc access dbms=ims ad=mylib.wiretran; create vlib.wiredata.view psbname=acctsam pcbindex=5; select 'wire transaction'; list view; run;
Chapter Contents |
Previous |
Next |
Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.