CV2VIEW Procedure

TO_VIEW Statement

Specifies the name of the new (converted) SQL view

Restriction: If you specify DBMS=ALL, you cannot use the TO_VIEW statement.
Requirements: You must specify either the TO_VIEW statement or the TO_LIBREF statement.
FROM_VIEW and TO_VIEW statements are always used together.
Interaction: Use the REPLACE statement to control whether the output file is overwritten or appended if it already exists.

Syntax

Required Arguments

libref

specifies the libref where you want to store the new SQL view.

output-view

specifies the name for the new SQL view that you want to create.

Last updated: February 3, 2026