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

Like SQL Server, DB2 can display results in a grid. It was the only tool in our roundup that let us query and edit data on the fly, but we wish it reported tablespace sizes in bytes rather than in ...