IGYPS0225-S An "EXEC SQL" statement was found.

[Sangitha]

Hi,

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. 

the strange thing is, when i am using SQL query inside the copy book I am getting the error but if the call it directly the compilation was successfull.

could you help me?

[nicc]

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

[Anuj Dhawan]

Along with what Nic has said, I'd also like to know what "compiling tool" are you using to compile your program?

[William Collins]

To put it another way, you shouldn't have SQL statements in COBOL copybooks if you are using the pre-compiler, because the pre-compiler does not expand copybooks (it would have to re-write them if it did, and that would very quickly become a big mess).

The message is referring to the compiler option SQL, which when on uses the SQL co-processor, directly from the compiler (so no pre-processor step needed). Then the SQL can be in a copybook.

What exactly you've got wrong, we can't guess. Ask your colleagues how they do what you want to do.

[Sangitha]

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

Fine but what should I do to rectify the error now?

[Sangitha]

Along with what Nic has said, I'd also like to know what "compiling tool" are you using to compile your program?

I'm using chaneman for this.

[William Collins]

What exactly you've got wrong, we can't guess. Ask your colleagues how they do what you want to do.

[Robert Sample]

Fine but what should I do to rectify the error now?

Take the EXEC SQL statement out of the copy book and put it in the program.

Or, stop using the precompile and just do the compile with the DB2 option.

Or, talk to your co-workers about how to resolve the issue and follow their advice.

Note that your use of Changeman makes no difference -- if you don't like how it is working, you need to work with your site support group to change it.

[Anuj Dhawan]

Along with what Nic has said, I'd also like to know what "compiling tool" are you using to compile your program?

I'm using chaneman for this.

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.

Having said all that, suggest - you ask around at your shop about this.

[Sangitha]

Thanks all.

I was missing to tryn the 'pre-compiler' option as Yes. Making it "Y" has resolved the problem.