Storage area of view table..

samimaktar · New User Joined: 03 Aug 2009 Posts: 25 Location: Singapore

Hi friends,
As we know that VIEW has only logical existence, no physical existence and it is derived from Base Table. Can u please tell me where the view is logically stored? Is it stored in temporary storage table?

Thanks & Regards,
Samim Aktar

dick scherrer · Posted: Sun Oct 25, 2009 3:08 am

Hello,

Suggest you re-think and more clearly post your question. Are you asking about the definition of the view or the data returned when a SELECT is issued using the view?

The view uses the same physical data that resides in the underlying table but only the columns named in the view are accessable to the query.

dbzTHEdinosauer · Posted: Sun Oct 25, 2009 3:21 am

If you are talking about the location of the SQL that represents a VIEW,
it is maintained in one of the SYSIBM...tables,
a complete description of which can be found in an APPENDIX of every
DB2 SQL Reference ---- which you need to read.