Previous Topic: IDCMDBQP08 - Field, host variable name, is an occurring item which may not be used in constructNext Topic: IDCMDBQP10 - Qualification of DVW SQL table/view name by AUTHID AUTHID qualifier is not allowed


IDCMDBQP09 - Dataview identifier is not a valid RESOURCE of this PGM

Reason:

An SQL statement makes reference to identifier as a VIEW or TABLE, but identifier was rejected as a RESOURCE of the program or was never entered as a RESOURCE of the program.

Action:

If the dataview was never included as a program resource, add it to the resource table and recompile.

If use of the dataview is restricted, see your CA Ideal Administrator to authorize use of the dataview by the SYSTEM containing your program.

If the dataview is a defined resource of the program and authorized for use, be certain that the SQL TABLE or VIEW is defined to CA Datacom SQL and that it was CATALOGed to CA Ideal.