For more information about how to use the SQL Procedure Pass-Through Facility ... proc sql; connect to db2 (ssid=db2); execute (create view testid.whotookorders as select ordernum, takenby, firstname, ...