Access Descriptors for the CA-Datacom/DB Tables :: SAS/ACCESS(R) 9.3 Interface to CA-Datacom/DB: Reference

MyLib.Custs Access Descriptor

The MyLib.Custs access descriptor for the Customers table was created as follows:

proc access dbms=Datacom;
   create mylib.custs.access; 
   user=demo; 
   table=customers; 
   assign = yes;
   drop contact;
   list all;
   extend all;
   rename customer = custnum telephone = phone streetaddress = street; 
   format firstorderdate = date7.; 
   informat firstorderdate = date7.;
   content firstorderdate = yymmdd6.;
   list all;
run;

MyLib.Employee Access Descriptor

The MyLib.Employee access descriptor for the EMPLOYEES table was created as follows:

proc access dbms=Datacom;
   create mylib.employee.access;
   user=demo;
   table=employees;
   assign = yes;
   format hiredate = date7.;
   informat hiredate = date7.;
   content hiredate = yymmdd6.;
   format birthdate = date7.; 
   informat birthdate = date7.;
   content birthdate = yymmdd6.;
   list all; 
   extend all; 
run;

MyLib.Invoice Access Descriptor

The MyLib.Invoice access descriptor for the Invoice table was created as follows:

proc access dbms=Datacom;
   create mylib.invoice.access;
   user=demo; 
   table=invoice; 
   assign = yes;
   format billedon = date7.;
   informat billedon = date7.;
   content billedon = yymmdd6.;
   format paidon = date7.;
   informat paidon = date7.;
   content paidon = yymmdd6.;
   list all;
   extend all;
run;

MyLib.Orders Access Descriptor

The MyLib.Orders access descriptor for the Order table was created as follows:

proc access dbms=Datacom;
   create mylib.orders.access;
   user=demo; 
   table=order; 
   assign = yes;
   format dateordered = date7.;
   informat dateordered = date7.;
   content dateordered = yymmdd6.;
   format shipped = date7.;
   informat shipped = date7.;
   content shipped = yymmdd6.;
   list all;
   extend all;
run;