Data and Descriptors for the Examples

View Descriptors for the CA-Datacom/DB Tables

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;

Top of Page