Displaying or Printing an Index of Dataview Definitions

Introduction › Displaying or Printing an Index of Dataview Definitions

Displaying or Printing an Index of Dataview Definitions

The DISPLAY INDEX and PRINT INDEX commands (options 6 and 7 on the Dataview Menu) list the name and status of each dataview currently in the dictionary facility.

Optionally, the index can include occurrences of entity‑types that are related to a dataview (for example, each program related to a given dataview). This display is based on Datadictionary relationships. Refer to the Command Reference Guide for the syntax and a description of the command.

The display resulting from the DISPLAY INDEX DATAVIEW command follows:

 =>
 -------------------------------------------------------------------------------
 IDEAL: DISPLAY INDEX         DVW                             SYS: CCF   DISPLAY

 Command Name           Ver S U Type Description               Created  Updated
 ====== ================================ T O P =================================
 000001 APPLSYSTEM      001 H Y                                02/21/94 03/14/94
 000002 APPLSYSTEM      002 H Y                                02/21/94 03/14/94

000003 APPLSYSTEM‑RO 001 H N 02/21/94 03/14/94

000004 APPLSYSTEM‑RO 002 H N 02/21/94 03/14/94 000005 @I$IMAGE‑BYFILE 001 P Y QSAM Sample program standard 06/10/94 06/10/94 000006 ACCOUNTS 001 P Y 12/11/94 12/11/94 000007 ACT‑DVW‑A01 001 P N SAMPLE DATAVIEW FOR FILE 10/10/94 10/10/94 000008 CMF‑VSEIN 001 P N SAM SYSIN file for CMF input 05/03/94 05/03/94 000009 CMF.APPLSYSTEM Y DSQL 09/07/93 12/16/94 000010 CMF.APPLSYSTEM_V 000011 Y DSQL 09/24/93 09/14/94 000012 CMFDB2.APPLSYSTEM_V 000013 Y DB2 04/27/94 10/22/94 000014 MFSDGR 001 P N VSAM MFS test downgrade 01/04/93 01/04/93 000015 MVS 001 P Y QSAM 06/15/92 05/20/94 000016 OCC 001 P Y QSAM 04/13/94 04/13/94 000017 ORDERS 001 P Y 12/11/93 04/29/94 000018 QAXDVW1V 001 P N VSAM vsam for source transport 07/05/92 12/05/93

Command

Specifies an area where you can specify line commands. For more information about description of line commands, see the Command Reference Guide.

Name The 1‑ to 18‑character name of the dataview definition. For an SQL access dataview, the name is prefixed by the one‑ to eight‑character authorization ID, as shown on lines 9‑13 of the previous figure.
Ver (Version) The one‑ to three‑digit version number CA Ideal assigned when this version of the dataview definition was created.
S (Status) The status of each dataview definition. Status is not used for SQL dataviews.
- H History status
- P Production status
- T Test status

All history entries display first, followed by production versions, then test versions. In each status group, the dataview definition names appear in alphabetical sequence. For each name, versions appear in numerical sequence.

U (Update‑intent)

Indicates whether the PDL statements in a CA Ideal application can update records or rows viewed through this dataview. This reflects the table or view definition only, not the individual's authorization for them.

Y The records or rows viewed through this dataview can be updated, inserted, or deleted. An SQL access dataview is always updateable.
N The records or rows viewed through this dataview cannot be updated, inserted, or deleted.

Type

Specifies the type of file represented by the dataview:

QSAM-For sequential QSAM files.
SAM-For sequential SAM files.
VSAM-For VSAM files.
DSQL-For CA Datacom SQL access objects.
DB2-For DB2 objects.
spaces-For CA Datacom/DB native access tables.

Description

Specifies the description for the dataview definition. If the description of an CA Datacom/DB native access dataview is longer than 24 characters, it is truncated on this display.

Created (Creation date)

Indicates the date on which the dataview definition was created or first cataloged.

Updated (Modified date)

Indicates the date on which the dataview definition was last modified or last cataloged.