I'm new to DB2 and have learned so much from this forum.

I've been asked to alter some tables to declare them "volatile". I have the syntax for that request but am wondering if there is a "describe" command that will tell me if a table is already "volatile"? Any ideas? We're on v8 fp6 running on AIX v5.2.

Thanks in advance,
Jodi



DB2 & UDB email list listserv db2-l LazyDBA home page