*

An asterisk represents the current dataview. You can substitute it for the entire DATAVIEW identification clause.

dbms

(Mixed SQL Site) Database management system that SQL statements using this dataview access when you can access more than one database management system using SQL. This option overrides the dbms specified by a SET ENVIRONMENT SQL command. Use this option when you catalog a new SQL dataview.

To change the database management system for a cataloged dataview, delete the dataview and catalog again. You cannot make the change when recataloging an existing SQL dataview.

DB Dataview accesses CA Datacom/DB.

DB2 Dataview accesses DB2.

authid

(SQL Only) One‑ to eight‑character authorization ID required for SQL dataviews only.

dvw‑name

The 1‑ to 18‑character name of a dataview. For SQL dataviews, the dataview name is the name of an SQL object (table, view, or CA Datacom SQL synonym).

ver

(Non‑SQL dataviews) Version of the dataview to catalog, for a modeled (CA Datacom native access or sequential) dataview or an unmodeled (sequential or VSAM) dataview. If the version is not specified, the default version set by the SET DATAVIEW VERSION command is used. For information on valid versions to specify, see Using Version Clauses in CA Ideal Commands in the “Preliminary Concepts” chapter.

[WITH] VALIDATION

(VSAM Dataviews Only) Specify this option to verify CA Ideal dataview attributes against the actual characteristics of the VSAM file in the VSAM Access Control Blocks. If any discrepancies are found, the CATALOG command fails and error messages are issued. You can specify this option as VAL.

The following attributes are validated:

• File organization (ESDS, KSDS, RRDS)
• Record length (maximum length must match the length defined in IDCAMS)
• Displacement and length of primary and alternate keys

UNIQUE and UPGRADE SET attributes of the alternate indexes are not validated, although paths defined as part of the upgrade set are checked for availability and the key defined for each path is checked for displacement and length.

Use this option only if the file is accessible in the current environment.

[WITH] NOVALIDATION

(VSAM Dataviews Only) Specify this option to catalog the dataview without validating the attributes. You can specify this option as NOVAL.

WITH NOVALIDATION is the default, but you can change the default by specifying the command SET CATALOG VALIDATION.

Use this option if the file is not accessible in the current environment.