Previous Topic: IDCMDBQP10 - Qualification of DVW SQL table/view name by AUTHID AUTHID qualifier is not allowedNext Topic: IDCMDBQP12 - field-name, an input-intent parameter field, is used in an UPDATE context

Compile (CM) Messages › › IDCMDBQP11 - Qualification of DVW SQL table/view name by AUTHID AUTHID qualifier will override PGM resource table QUAL=N specification

IDCMDBQP11 - Qualification of DVW SQL table/view name by AUTHID AUTHID qualifier will override PGM resource table QUAL=N specification

Reason:

An SQL table/view name that was defined in the program's resource table to take on the default authorization ID for the user (for example, QUAL=N) was explicitly qualified in an embedded SQL statement. For this particular statement, the authorization ID qualification is included in the generated SQL and this occurrence the dataview does not take on the default authorization ID.

Action:

If the SQL table/view name should take on the default authorization ID of the executing user, remove the explicit qualification.

If this particular occurrence SQL table/view name should access only the specified authid.dvw, there is no action necessary.

Note: This is useful for populating user tables from production tables.