The ACCESS Procedure for Relational Databases |
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.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.