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?
Joined: 20 Oct 2006 Posts: 6968 Location: porcelain throne
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.