The following example
creates a new Sybase table, EXCHANGE, from the DLIB.RATEOFEX data
file. (The DLIB.RATEOFEX data set is included in the sample data that
is shipped with your software.) An access descriptor ADLIB.EXCHANGE
is also created, and it is based on the new table. The DBLOAD procedure
sends a Transact-SQL GRANT statement to Sybase. You must be granted
Sybase privileges to create new Sybase tables or to grant privileges
to other users.
libname adlib 'SAS-library';
libname dlib 'SAS-library';
proc dbload dbms=sybase data=dlib.rateofex;
server='server1';
database='testdb';
user='testuser';
password='testpass';
table=EXCHANGE;
accdesc=adlib.exchange;
rename fgnindol=fgnindolar 4=dolrsinfgn;
nulls updated=n fgnindol=n 4=n country=n;
load;
run;