Introduction › Dataview Menu › For SQL Access

For SQL Access

No CA Ideal components are necessary to create and edit dataview definitions for SQL objects.

For DB2, the definitions of tables and views are maintained in the DB2 catalog. Definitions of dataviews are maintained in the dictionary.

For CA Datacom SQL access, the definitions of tables, views, synonyms, and dataviews are maintained in the Datadictionary of the Datadictionary. Any field information provided in the dictionary, such as headings, initial values, and edit patterns, is incorporated into the dataview object. CATALOG process makes a dataview definition available to CA Ideal.

When you catalog an SQL dataview, CA Ideal records a dataview corresponding to the SQL object as an entity occurrence in the dictionary. The dataview entity occurrence is recorded in the dictionary facility as version 1 in production status. You can issue one or many CATALOG commands in a batch run of CA Ideal.

Deleting an SQL dataview deletes the dataview entity occurrence from the dictionary, and deletes its object member.

Note: The CA Ideal CATALOG command does not update the definition of the SQL object in Datadictionary or the DB2 catalog. Rather, it updates the dataview definition for the SQL object in the CA Ideal dictionary facility.

Once an SQL dataview is cataloged, you can display or print the definition online, delete the dataview entity occurrence from the dictionary facility, or dequeue the dataview if it is improperly enqueued. For more information about how to use dataview, see the Creating Programs Guide. For more information about syntax of the DISPLAY, PRINT, DELETE, CATALOG, and DEQUEUE commands, see the Command Reference Guide.

Note: SQL access dataviews can be updated by default in CA Ideal.

If the SQL object is an SQL view, the CREATE VIEW statement displays in the dataview Text area.