I am compiling a COBOL-DB2 pgm. I am getting below error msg.
Code: Select all
IGYPS0225-S An "EXEC SQL" statement was found, but the "SQL" compiler option was not in effect. The statement was discarded.
could you help me?
Code: Select all
IGYPS0225-S An "EXEC SQL" statement was found, but the "SQL" compiler option was not in effect. The statement was discarded.
Fine but what should I do to rectify the error now?nicc wrote:The SQL recompiler runs before the COBOL compiler. It is the COBOL compiler that brings in the copybook so your SQL statement comes in after the SQL pre-compiler. (The pre-compiler converts the SQL code to COBOL, PL/1 or whatever language you are using that a pre-compiler exists for).
I'm using chaneman for this.Anuj Dhawan wrote:Along with what Nic has said, I'd also like to know what "compiling tool" are you using to compile your program?
What exactly you've got wrong, we can't guess. Ask your colleagues how they do what you want to do.
Take the EXEC SQL statement out of the copy book and put it in the program.Fine but what should I do to rectify the error now?
If it is so - I'd make an educated guess that you're not telling the changeman that you're compiling a COBOL-DB2 program. To do that, from a distant memory, on some changeman panel, while compiling, you've to mention 'Y' to tell changeman to include 'pre-compiler' step in the underlying compile JCL that changeman will generate.Sangitha wrote:I'm using chaneman for this.Anuj Dhawan wrote:Along with what Nic has said, I'd also like to know what "compiling tool" are you using to compile your program?
You need to be a member in order to post a reply
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute