refresh view ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

satishrajana@gmail.com - 01 Mar 2006 13:03 GMT

Do we need to refresh a view when a table structure is altered ?. I
thought a view is just a query and it does not have to ? Please let me
know.
S

Reply to this Message

Serge Rielau - 01 Mar 2006 13:15 GMT

> Do we need to refresh a view when a table structure is altered ?. I
> thought a view is just a query and it does not have to ? Please let me
> know.
> S

How do you alter the table structure? And which version of DB2?

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

satishrajana@gmail.com - 01 Mar 2006 13:20 GMT

I mean by adding adding a column and the DB2 version is 8

Reply to this Message

Serge Rielau - 01 Mar 2006 14:16 GMT

> I mean by adding adding a column and the DB2 version is 8

Adding a column has no impact whatsoever on a view.
If you happen to use "SELECT *" then the SQL Standard requires the view
NOT to pick up the extra column.
Note that "SELECT *" (especially in static objects) is by many
considered evil.

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

satishrajana@gmail.com - 01 Mar 2006 14:20 GMT

Serge..That answers my question. Appreciate your help !

Reply to this Message