Hi,
This is related to DB2 UDB Ver 9.5 fixpack 8. I have 2 stored procedures using a view. But views are used in different fashion. Details are mentioned below.
1) procedure A
Uses the view to declare curor and return it to calling application
2)procedure B
Uses the view to get some data and insert it in temp table and then return the cursor to calling application using temp table

Problem:
When I drop the view and recreate it, procedure A works fine with implicit rebind. But procedure B does not work even with explicit rebind. The only way it works is by dropping and recreating the procedure.

Why does this happen? Any way to resolve this ?

Also, When I query SYSIBM.SYSPLANDEP for proc A and prob B package, view is listed for for procedure A but not for proc B. Any idea why?

Thanks,
Rajesh