 |
» |
|
|
|
The SYSTEM.VIEWDEF view displays information about view
definitions, including the SELECT part of each CREATE VIEW
statement used
to create a view. The SELECT is stored in a series of
segments of up to 64 bytes. SYSTEM.VIEWDEF is initially empty, and it is updated whenever ALLBASE/SQL
processes a CREATE VIEW statement, a DROP VIEW statement, or a TRANSFER
OWNERSHIP statement on a view. System views are not included in
SYSTEM.VIEWDEF. When the view is
dropped, the rows making up the byte string of the SELECT portion are
deleted. If a TRANSFER OWNERSHIP is done on the view, the owner field
in this table is updated with the Name of the new owner.
Table 8-42
System.ViewDef
|
Column Name
|
Type
|
Length
|
Description |
|---|
|
VIEWNAME
|
CHAR
|
20
|
Name of the view | |
OWNER
|
CHAR
|
20
|
Owner of the view | |
QUALIFIER
|
CHAR
|
20
|
Owner Name to be used to qualify any unqualified objects referenced in
the SELECT byte string | | SEGNUM | INTEGER | 4 | Segment Number | | SEGLEN | INTEGER | 4 | Length of segment in bytes (up to 64) | | SELECTSTRING | CHAR | 64 | SELECT byte string segment
|
Example | |
select * FROM System.ViewDef WHERE VIEWNAME = 'VENDORSTATISTICS';
--------------------+--------------------+--------------------+------
VIEWNAME |OWNER |QUALIFIER |SEGNUM
--------------------+--------------------+--------------------+------
VENDORSTATISTICS |PURCHDB |PURCHDB | 1
VENDORSTATISTICS |PURCHDB |PURCHDB | 2
VENDORSTATISTICS |PURCHDB |PURCHDB | 3
VENDORSTATISTICS |PURCHDB |PURCHDB | 4
VENDORSTATISTICS |PURCHDB |PURCHDB | 5
---------------------------------------------------------------------------
First 5 rows have been selected.
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> r
+------+---------------------------------------------------------------
|SEGLEN|SELECTSTRING
+------+---------------------------------------------------------------
| 64| SELECT PurchDB.Vendors.VendorNumber,PurchDB.Vendors.VendorName
| 51|, OrderDate,OrderQty,OrderQty*PurchasePrice FROM
| 58|PurchDB.Vendors,PurchDB.Orders,PurchDB.OrderItems WHERE
| 63|PurchDB.Vendors.VendorNumber=PurchDB.Orders.VendorNumber AND
| 60|PurchDB.Orders.OrderNumber=PurchDB.OrderItems.OrderNumber;
---------------------------------------------------------------------------
First 5 rows have been selected.
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> r
|
|
