I am getting this error after compiling an Ideal program:
SQIB500 VERSION: 002 STATUS 140 CMGENQ03-E DVW-related SQL statements must reference a defined resource of the program.
but don't understand what the error is about...
z/os. Ideal 14.0 and above
The main reason for being unable to correct that error was the COMPILE Options being set.
You don't have to use the DIALMASK procedure to get the reason for an error.
But if you set the Compile Options as mentioned below and explained in the:
CA Ideal for CA Datacom Command Reference Guide 14.0 (Operand Definitions related to COMPILE Command).
Then you will get the Line number in error as well as the related error message.
When you compile an Ideal program it is better to SET the COMPILE OPTIONs (via SET (SITE) COMPILE):
Those Options will display all it is needed to resolve an error.
Dialmask may be asked by Support to find out more about an error but it is not needed for you when compiling.
Once the Compile Options are set up correctly, the error shows up clearly and in that specific case:
The correction was to use of SQL statement "CLOSE C1" instead of "CLOSE CURSOR C1".
Which will prevent the error:
CMGENQ03-E DVW-related SQL statements must reference a defined resource of the program.
For Ideal 15.0 and over please see: