Analyze database contents using basic, intermediate and advanced SQL statement syntax and usage. Demonstrate capability to query data from multiple tables using SQL JOINS. Create and modify database ...

This example uses the SQL procedure to retrieve and manipulate data from the view descriptor VLIB.ALLEMP, which is based on the DB2 table SASDEMO.EMPLOYEES. When this query (as a SELECT statement ...