The ACCESS Procedure for Relational Databases

Example 2: Example 2: Create a View Descriptor

The following example re-creates a view descriptor, VLIB.EMP1204, which is based on an access descriptor, ADLIB.EMPLOY, which was previously updated.

proc access dbms=oracle;

   /* re-create view descriptor  */

   create vlib.emp1204.view;
   select empid hiredate dept jobcode gender
      lastname firstname middlename phone;
   format empid 6.
          jobcode 5.
          hiredate datetime9.;
   subset where jobcode=1204;
run;

Because SELECT and RESET are not supported when UPDATE is used, the view descriptor Vlib.Emp1204 must be re-created to omit the Salary and BirthDate columns.

Top of Page

Previous Page
|
Next Page
|
Top of Page