CV2VIEW Procedure

SAVEAS= Statement

Saves the generated PROC SQL statements to a file
Interaction: If you specify the SAVEAS= statement, the generated SQL is not automatically submitted, so you must use the SUBMIT statement.

Syntax

Required Argument

external-filename
lets you save the PROC SQL statements that are generated by PROC CV2VIEW to an external file. You can modify this file and submit it on another platform.

Details

PROC CV2VIEW inserts comments in the generated SQL to replace any statements that contain passwords. For example, if a view descriptor is READ-, WRITE-, or ALTER-protected, the output view has the same level of security. However, the file that contains the SQL statements does not show password values. The password in the LIBNAME statement also does not show password values.