Using Debug an SQL procedure returns “Compiled successfully”; however, the SQL procedure is dropped.
There is a known issue with IBM DB2 running 10.1.3 on any server.
In the collected SQL from Toad for DB2 5.5, one can see SQL issued with the NULLIF expressions.
It is this kind of expression that the below IBM APAR defect references.
WORKAROUND:
Set QUERY OPTIMIZATION LEVEL to 0 or 1 on the server.
This will have to remain in effect until IBM addresses the APAR and a FixPack is applied to the server.
This issue is IBM APAR ID IC96725.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center