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, ...

specifies the name of the database where the DB2 table resides. Database name is limited to eight characters. The IN statement is required and follows the CREATE statement. DATABASE= and DSN= are ...