Changes in DB2 View

nidhi.palsule · New User Joined: 17 Feb 2009 Posts: 9 Location: Pune

Hi,

I am accessing a view from my application program (PLI). I compile and bind it and run it.

Now if I change something in DDL of the view (without changing the name of the view) do I need to bind my application program again?

sushanth bobby · Posted: Mon Jun 28, 2010 8:21 pm

Nidhi,

Basically, you cannot alter a VIEW. So, only available option is DROP and re-create the view. So when you do that, DB2 invalidates the package. And when you execute the program after recreating the view and DB2 will try to rebind the package automatically.

Thanks,
Sushanth