Use the DROP VIEW statement to obsolete a view in CA Datacom Datadictionary. When you drop a view, the synonyms or views that are directly or indirectly dependent on the view are automatically dropped. All application plans and statements that reference the view are invalidated.
Enter the DROP VIEW statement in the numbered area of an EDIT Source Member Panel. See How to Submit SQL Statements for the steps to obtain the panel and an explanation of the fields on the panel.
Specifying Authorization ID
To be certain you are dropping the desired view, qualify the view name with the authorization ID in the DROP statement. If you do not specify the authorization ID, CA Datacom Datadictionary uses the current default authorization ID for the online session.
Example Source Member
The following example shows the DROP VIEW statement. See How to Submit SQL Statements for the steps to obtain the panel and an explanation of the fields on the panel.
=> => => ------------------------------------------------------------------------------- Interactive SQL Service Facility SQLMAINT Source Panel S01S EDIT Member: DVIEW Output Line Limit: 01000 Person: JONES Current Authid: JONES Description: DROP VIEW DEPTVEW ------------------------------------------------------------------------------- ====== ========================== T O P ======================================= 000001 drop view jones.deptvew; ====== ======================= 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 DROP statement is required, as is the keyword VIEW. The keyword must be followed by the name of the object you are dropping.
Once this source member is executed, you cannot recall the view definition. If you want to use this view again, you must re-create it.
See DROP for more information on the syntax of the DROP statement.
Example Output Member
When you execute the statement, you receive a Output Panel similar to the following example:
=> => => --------------------------------------------------------------------------- >>> Interactive SQL Service Facility SQLMAINT Output Panel S01O EDIT Member= DVIEW Description: DROP VIEW DEPTVEW ------------------------------------------------------------------------------- ====== ========================== T O P ======================================= 000001 (OUTPUT CREATED FROM SOURCE MEMBER DVIEW ) 000002 drop view jones.deptvew; 000003 ---------+---------+---------+---------+---------+---------+---------+-- 000004 STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0 000005 ---------+---------+---------+---------+---------+---------+---------+-- 000006 SQL STATEMENTS ASSUMED TO BE BETWEEN COLUMNS 1 AND 72 000007 NUMBER OF INPUT RECORDS READ IS 0001 000008 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
To exit from the Output Panel, you can perform one of the following:
|
Copyright © 2014 CA.
All rights reserved.
|
|