SAS/ACCESS Interface to CA-DATACOM/DB: Reference

View Descriptors for the CA-DATACOM/DB Tables

This section shows the view descriptors used in this manual to access data stored in the CA-DATACOM/DB tables. The tables are described in CA-DATACOM/DB Tables. The view descriptors are presented in alphabetical order for easy reference.

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;

Chapter Contents
Previous
Next
Top of Page