The SAS code below shows you how to make SQL DB2 pass-through.
proc sql noprint;
connect to db2 (database=<Your database> user=<Your username> password=”<Your password>”);
execute
(
<Your SQL sentence>
) by db2;
disconnect from db2;
quit;
If you have your credentials stored in a SAS metadata-server it is possible to use a authdomain and skip entering username and password.
It is done using the following option in SAS:
options
metaserver=”<Your metadataserver>”
metaport=<usually 8561>
metaprotocol=bridge
metarepository=”Foundation”
;
proc sql noprint;
connect to db2 (database=<Your database> authdomain=<Your authdomain>);
execute
(
<Your SQL sentence>
) by db2;
disconnect from db2;
quit;
The database has to be available to SAS. This can eg be done through your DB2 ControlCenter.