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
Uses the view to get some data and insert it in temp table and then return the cursor to calling application using temp table
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?