The following examples use the SQL procedure to query, update, and create DBMS tables. Querying a DBMS Table This example uses the SQL procedure to query the ORACLE table PAYROLL. The PROC SQL query ...

specifies an alias, if one was defined in the CONNECT statement. (DBMS-SQL-query) specifies the query that you are sending to the DBMS. The query can use any DBMS-specific SQL statement or syntax that ...