thank you! that worked and saved me from having to declare those tables as they already are volatile.



-----Original Message-----
From: Richard Flores
[mailto:db2udbdba-ezmlmshield-x7409043.[Email address protected]
Sent: Friday, January 28, 2005 2:10 PM
To: LazyDBA Discussion
Subject: RE: volatile tables


SELECT creator, name, volatile from sysibm.systables where volatile = 'C';

-----Original Message-----
From: Onstad Jodi
[mailto:db2udbdba-ezmlmshield-x99468912.[Email address protected]
Sent: Friday, January 28, 2005 12:48 PM
To: LazyDBA Discussion
Subject: volatile tables

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




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


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