SQL Concepts and Language Elements › SQL Dataviews

SQL Dataviews

A CA Ideal dataview corresponds to a complete SQL table, view, or synonym. To create and use an SQL dataview, perform the following tasks:

1. Issue a CATALOG command with the name of the SQL object.

   The catalog process retrieves the definition of the object from the database. It creates a dataview entity‑occurrence for the object in the dictionary facility and a dataview object module in the virtual library system.

2. Specify the dataview with the object's authorization ID in a program's resource fill‑in.

Any embedded Data Manipulation Language (DML) statements or FOR constructs can access the cataloged object from that program.

For more information about how to define SQL dataviews, see the Creating Dataviews Guide.