In this example, Transact-SQL will create a new table with all columns from the rows in "old_table" in which the last name starts with "Ja." ...

For this example you create a view descriptor, VLIB.ALLEMP, based on SYBASE data. The outer PROC SQL query retrieves data from the view descriptor; the subquery uses a Pass-Through query to retrieve ...

CREATE PROCEDURE GetCustomer AS Next, you must add the SQL code specifically for a stored procedure, and it must look similar to the first example above.

Note: If you specify the NUMBER option in the PROC SQL statement when you create your view, the ROW column appears in the output. However, you cannot order by the ROW column in subsequent queries. See ...