CV2VIEW Procedure
| See: | CV2VIEW Procedure |
Syntax
PROC CV2VIEW DBMS=dbms-name | ALL;
FROM_VIEW=libref.input-descriptor;
FROM_LIBREF=input-library;
TO_VIEW= libref.output-view;
TYPE= SQL | VIEW | ACCESS;
TO_LIBREF= name
of output library;
SAVEAS=external
filename;
REPLACE=ALL | VIEW | FILE;
Table of Procedure Tasks
| Statement | Task |
|---|---|
| PROC CV2VIEW Statement | Convert |
| FROM_LIBREF= Statement | Specify the library containing the view descriptors or access descriptors that you want to convert |
| FROM_VIEW= Statement | Specify the view descriptor or access descriptor that you want to convert |
| REPLACE= Statement | Specify whether existing views and files are replaced |
| Save the generated PROC SQL statements to a file | |
| SAVEAS= Statement | Submit the generated PROC SQL statements when you specify the SAVEAS= statement |
| Specify the name of the new (converted) SQL view | |
| TO_VIEW= Statement | Specify the library that contains the new (converted) SQL views |
| TYPE= Statement | Specify what type of conversion should occur |