IDCMGENQ03 - DVW-related SQL statements must reference a defined resource of the program

Products

• Ideal

Issue/Introduction

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...

Environment

z/os. Ideal 14.0 and above 

Cause

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): 

IDE YES 
EXD YES 
BOD YES 
ADV YES 
MEL YES 
DBCS NO 
LSQL YES 
REF FULL 
PNL FULL

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.  

Resolution

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.

Additional Information

For Ideal 15.0 and over please see:

https://docops.ca.com/ca-datacom-tools/15-1/en/utilizing-ca-ideal-for-ca-datacom/ca-ideal-for-ca-datacom-reference/ca-ideal-for-ca-datacom-commands/set-compile-command