Previous Topic: IDCM2PAR48 - object-type object-name is treated as other-type in this contextNext Topic: IDCM2PAR50 - object-type name, name, exceeds maximum length of an SQL LONG-or-SHORT identifier


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

Reason:

An DB2 table/view name that was defined in the programs resource table to take on the default authid for the user (that is, QUAL=N) was explicitly qualified in an embedded SQL statement. For this particular statement, the authid qualification is included in the generated SQL and this occurrence of the dvw does not take on the default authid.

Action:

If the DB2 table/view name should take on the default authid of the executing user, remove the explicit qualification. If this particular occurrence DB2 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.