Example Data

View Descriptors Based on the Access Descriptors for ADABAS

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;

Top of Page