SAS/ACCESS Interface to ADABAS Software

View Descriptors Based on the Access Descriptors

This section shows the view descriptors used in this book to access ADABAS data. The view descriptors are presented in alphabetical order.

VLIB.ADAEMPS View Descriptor

The VLIB.ADAEMPS view descriptor was created as follows:

proc access dbms=adabas ad=mylib.employee;
   create vlib.adaemps.view;
   select empid birthdate;
   select lastname firstname middlename;
run;

VLIB.ALLEMP View Descriptor

The VLIB.ALLEMP view descriptor was created as follows:

proc access dbms=adabas ad=mylib.employee;
   create vlib.allemp.view;
   select all;
   reset isn;
run;

VLIB.ALLORDR View Descriptor

The VLIB.ALLORDR view descriptor was created as follows:

proc access dbms=adabas ad=mylib.order;
   create vlib.allordr.view;
   select all;
   reset isn;
run;

VLIB.CUSORDR View Descriptor

The VLIB.CUSORDR view descriptor was created as follows:

proc access dbms=adabas ad=mylib.order;
   create vlib.cusordr.view;
   select stocknum shipto;
run;

VLIB.CUSPHON View Descriptor

The VLIB.CUSPHON view descriptor was created as follows:

proc access dbms=adabas ad=mylib.custs;
   create vlib.cusphon.view;
   select customer telephone name;
run;

VLIB.EMPINFO View Descriptor

The VLIB.EMPINFO view descriptor was created as follows:

proc access dbms=adabas ad=mylib.employee;
   create vlib.empinfo.view;
   select empid dept lastname;
run;

VLIB.EMPS View Descriptor

The VLIB.EMPS view descriptor was created as follows. This descriptor includes sort and WHERE statements to specify selection criteria.

proc access dbms=adabas ad=mylib.employee;
   create vlib.emps.view;
   select empid jobcode birthdate lastname;
   subset where jobcode = 602;
   subset sort lastname;
run;

VLIB.FORINV View Descriptor

The VLIB.FORINV view descriptor was created as follows. This descriptor includes a WHERE statement to specify selection criteria.

proc access dbms=adabas ad=mylib.invoice;
   create vlib.forinv.view;
   select all;
   reset isn computedexchange;
   subset where country != 'USA';
run;

VLIB.INV View Descriptor

The VLIB.INV view descriptor was created as follows. This descriptor includes a sort statement to specify selection criteria.

proc access dbms=adabas ad=mylib.invoice;
   create vlib.inv.view;
   select invoicenum amtbilled country 
      billedby paidon;
   subset sort billedby;
run;

VLIB.USACUST View Descriptor

The VLIB.USACUST view descriptor was created as follows. This descriptor includes SORT and WHERE statements to specify selection criteria.

proc access dbms=adabas ad=mylib.custs;
   create vlib.usacust.view;
   select all;
   reset isn telephone streetaddress 
     city "STATE-ZIPLAST2" ziplast2;
   mvf "BRANCH-OFFICE" reset br_any 
     branch_1 branch_3 branch_4;
   subset where country = 'USA';
   subset sort customer;
run;

VLIB.USAINV View Descriptor

The VLIB.USAINV view descriptor was created as follows. This descriptor includes a WHERE statement to specify selection criteria.

proc access dbms=adabas ad=mylib.invoice;
   create vlib.usainv.view;
   select all;
   reset isn computedexchange;
   subset where country = 'USA';
run;

VLIB.USAORDR View Descriptor

The VLIB.USAORDR view descriptor was created as follows. This view descriptor uses a SORT statement to specify selection criteria.

proc access dbms=adabas ad=mylib.order;
   create vlib.usaordr.view;
   select ordernum stocknum length 
     fabriccharges shipto;
   subset sort shipto;
run;

Chapter Contents
Previous
Next
Top of Page