Invalidate View under IDS 10

#1

Greeting All,

Since IDS 10.0.UC3 is out with many excellent features and bug fixes,
does any one know if IDS 10.0 supports invalidate views if parent
object has been dropped. If yes, which catalogue/sysmaster table does
have that info ? Also, upon recreating the parent object can view be
validate again.

Example: T1 is a table and a view V1 is based on T1. If T1 has been
dropped, view V1 gets drop as well (until 9.40).

Thanks.

#2

hariog (AT) yahoo (DOT) com wrote:

Quote:

Since IDS 10.0.UC3 is out with many excellent features and bug fixes,
does any one know if IDS 10.0 supports invalidate views if parent
object has been dropped. If yes, which catalogue/sysmaster table does
have that info ? Also, upon recreating the parent object can view be
validate again.

Example: T1 is a table and a view V1 is based on T1. If T1 has been
dropped, view V1 gets drop as well (until 9.40).

No; I don't recall seeing that worthwhile suggestion being discussed before.

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler (AT) earthlink (DOT) net, jleffler (AT) us (DOT) ibm.com
Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/

#3

Thanks Jonathan. I knew that you will be one of many other gurus to
reply my question. Anyway, much appreciated your reply.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Invalidate View under IDS 10

comp.databases.informix comp.databases.informix

Invalidate View under IDS 10 - 08-23-2005 , 07:34 PM

Re: Invalidate View under IDS 10 - 08-24-2005 , 12:13 AM

Re: Invalidate View under IDS 10 - 08-24-2005 , 02:07 AM