|
View previous topic :: View next topic
|
| Author |
Message |
Nagendran
New User
Joined: 24 Jan 2007
Posts: 89
Location: USA
|
|
|
|
hi,
i am executing pure DB2 pgm. I am getting below error msg.
IGYPS0225-S An "EXEC SQL" statement was found, but the "SQL" compiler option was not in effect. The statement was discarded.
when i am using sql query inside the copy book i am getting the error.if i am calling directly the compilation was successfull.
could any body help me?
regards,
Nagu |
|
| Back to top |
|
 |
Devzee
Active Member
Joined: 20 Jan 2007
Posts: 684
Location: Hollywood
|
|
|
|
| Quote: |
| sql query inside the copy book |
This copybook is included using COPY or INCLUDE statement? |
|
| Back to top |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005
Posts: 2358
Location: Israel
|
|
|
|
The COPY statement is processed by the language compiler only, therefor the precompiler can't "see" it. Use INCLUDE instead of COPY.
O. |
|
| Back to top |
|
|
Nagendran
New User
Joined: 24 Jan 2007
Posts: 89
Location: USA
|
|
|
|
the solution is,while compiling DB2 program set the option
EXPAND COPY===> Y |
|
| Back to top |
|
|
|
|
