The following example shows the Output Panel received when executing the previous CREATE VIEW statement.
=> => => --------------------------------------------------------------------------- >>> Interactive SQL Service Facility SQLMAINT Output Panel S01O EDIT Member= DEPTVEW Description: VIEW DEPARTMENT ORGANIZATION ------------------------------------------------------------------------------- ====== ========================== T O P ======================================= 000001 (OUTPUT CREATED FROM SOURCE MEMBER DEPTVEW ) 000002 create view deptvew 000003 (deptno, deptname, admdept) 000004 as select all 000005 deptno, deptname, admdept 000006 from depttbl 000007 ---------+---------+---------+---------+---------+---------+---------+-- 000008 where admdept = 'A1'; 000009 ---------+---------+---------+---------+---------+---------+---------+-- PF1=HELP PF2=END PF3=SPLIT PF4=PROCESS MORE... PF5=TOP PF6=BOTTOM PF7=BACKWARD PF8=FORWARD PF9=EXECUTE PF10=LEFT PF11=RIGHT PF12=ALTERNATE
If the display is larger than your screen allows, use the PF keys to scroll to other portions of the display.
=> => => --------------------------------------------------------------------------- >>> Interactive SQL Service Facility SQLMAINT Output Panel S01O EDIT Member= DEPTVEW Description: VIEW DEPARTMENT ORGANIZATION ------------------------------------------------------------------------------- 000009 ---------+---------+---------+---------+---------+---------+---------+-- 000010 STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0 000011 --------+--------+--------+--------+--------+--------+--------+--------+ 000012 SQL STATEMENTS ASSUMED TO BE BETWEEN COLUMNS 1 AND 72 000013 NUMBER OF INPUT RECORDS READ IS 0006 000014 NUMBER OF SQL STATEMENTS PROCESSED IS 0001 ====== ======================= B O T T O M ==================================== PF1=HELP PF2=END PF3=SPLIT PF4=PROCESS PF5=TOP PF6=BOTTOM PF7=BACKWARD PF8=FORWARD PF9=EXECUTE PF10=LEFT PF11=RIGHT PF12=ALTERNATE
The previous example of a view is a row and column subset view of the table DEPTTBL which contains columns DEPTNO, DEPTNAME, MGRNBR, and ADMDEPT. The view DEPTVEW is a subset since only three of the four columns in DEPTTBL are included in the view, plus the number of rows is limited to those where the value of the ADMDEPT column is equal to the literal value 'A1'.
This view can be used to update values for the three specified columns. However, this view would not be used to insert new rows into the DEPTTBL table since one of the columns is not included in the view definition.
To exit from the Output Panel, you can perform one of the following:
|
Copyright © 2014 CA.
All rights reserved.
|
|