Replace "new_table" with the name of the table to create, and replace "old_table" with the name of the table to select from. The INTO clause behaves the same as CREATE TABLE in other SQL environments.

proc-sql-view specifies the name for the PROC SQL view that you are creating. ... Sorting Data Retrieved by Views: PROC SQL allows you to specify the ORDER BY clause in the CREATE VIEW statement. ... ...

Because of the READ= level of protection, the password must be specified in the PROC SQL SELECT statement before you can see the DB2 data accessed by VLIB.ALLEMP. In the following example, the ...