284 Example 3: Converting a Library of View Descriptors for All Supported DBMSs Chapter 16
/* PW= */
USER=ordevxx PATH=OracleV8 PRESERVE_TAB_NAMES=YES;
QUIT;
The SAVEAS= statement causes all of the generated SQL for all of the Oracle view
descriptors to be stored in the MANYVIEW.SAS file.
If the underlying DBMS is Oracle or DB2, the CV2VIEW procedure adds the
PRESERVE_TAB_NAMES= option to the embedded LIBNAME statement to enable you
to access those tables that have mixed-case or embedded-blank table names.
Example 3: Converting a Library of View Descriptors for All Supported
DBMSs
In this example, PROC CV2VIEW converts all of the view descriptors that are in the
input library and that access data in any supported DBMS. If an error occurs during the
conversion of a view descriptor, then the procedure moves to the next view. The PROC
SQL statements that are generated by PROC CV2VIEW are automatically submitted
but are not saved to an external file (because the SAVEAS= statement is not used).
libname input ’/username/descriptors/’;
libname output ’/username/sqlviews/’;
proc cv2view dbms=all;
from_libref = input;
to_libref = output;
run;
