SAS OnlineTutor HomeFAQ PageSuggested Learning PathsContents+Searchback||next

Accessing Other Vendors' DBMS Data
DBMS Access Using the SQL Procedure Pass-Through Facility

Question: Which of the following PROC SQL steps is correct?

proc sql;
   connect to db2 as dbdeux
           (user=cestmoi using=sesame db=receipts);
   execute (grant update, create totals)
           by dbdeux;
quit;
proc sql;
   connection to db2 as dbdeux
              (user=cestmoi using=sesame db=receipts);
   execute (grant update, create totals)
           by dbdeux;
quit;



back||next


Copyright © 2002 SAS Institute Inc., Cary, NC, USA. All rights reserved.

Terms of Use & Legal Information | Privacy Statement