View Descriptors for the CA-Datacom/DB Tables

VLIB.ALLEMP View Descriptor

The VLIB.ALLEMP view descriptor was created as follows:

proc access dbms=Datacom ad=mylib.employee;
   create vlib.allemp.view;
   select all; 
   list view; 
run;

VLIB.ALLORDR View Descriptor

The VLIB.ALLORDR view descriptor was created as follows:

proc access dbms=Datacom ad=mylib.orders;
   create vlib.allordr.view;
   select all;
   list view;
run;

VLIB.CUSORDR View Descriptor

The VLIB.CUSORDR view descriptor contains no selection criteria.

proc access dbms=Datacom ad=mylib.orders; 
   create vlib.cusordr.view;
   select stocknum shipto;
   list view;
run;

VLIB.CUSPHON View Descriptor

The VLIB.CUSPHON view descriptor was created as follows:

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

VLIB.CUSTADD View Descriptor

The VLIB.CUSTADD view descriptor was created as follows:

proc access dbms=Datacom ad=mylib.custs; 
   create vlib.custadd.view; 
   select state zipcode country name city;
   list view;
run;

VLIB.DCMEMPS View Descriptor

The VLIB.DCMEMPS view descriptor was created as follows:

proc access dbms=Datacom ad=mylib.employee;
   create vlib.dcmemps.view;
   select empid birthdate lastname firstname middlename;
   list view;
run;

VLIB.EMPINFO View Descriptor

The VLIB.EMPINFO view descriptor was created as follows:

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

VLIB.EMPS View Descriptor

The VLIB.EMPS view descriptor was created as follows:

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

VLIB.FORINV View Descriptor

The VLIB.FORINV view descriptor was created as follows:

proc access dbms=Datacom ad=mylib.invoice;
   create vlib.forinv.view;
   select all;
   subset where country != 'USA';
   list view;
run;

VLIB.INV View Descriptor

The VLIB.INV view descriptor was created as follows:

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

VLIB.USACUST View Descriptor

The VLIB.USACUST view descriptor was created as follows:

proc access dbms=Datacom ad=mylib.custs;
   create vlib.usacust.view;
   select customer state zipcode name firstorderdate;
   list view; 
   extend view; 
   subset where customer eq 1#; 
   subset sort firstorderdate; 
   list view; 
   list all;
run;

VLIB.USAINV View Descriptor

The VLIB.USAINV view descriptor was created as follows:

proc access dbms=Datacom ad=mylib.invoice;
   create vlib.usainv.view;
   select all;
   subset where country = 'USA';
   list view;
run;

VLIB.USAORDR View Descriptor

The VLIB.USAORDR view descriptor was created as follows:

proc access dbms=Datacom ad=mylib.orders;
   create vlib.usaordr.view;
   select ordernum stocknum length fabriccharges shipto;
   subset sort shipto;
   subset where shipto = 1#;
   list view;
run;