How to Turn Output On in SQL Developer. ... Click "View" and then click "Dbms Output." Click the green "+" sign in the window that opens and select the database connection from which you want output.

libname myoralib oracle user=charles password=mazyar path='airhrdept' schema=hrdept; title "Payrolls 1 & 2"; proc sql; select * from myoralib.payroll outer union corr select * from myoralib.payroll2 ...

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