Creating a view

Authorities and privileges

To create a view:

1. Open the Create View window.
   
   

2. Optional: In the View owner field, type a 1- to 8-character name that is unique on the current server. You can use an existing schema name (for Version 6 and later) , or use an authorization ID. If you do not specify a name, DB2 for OS/390 assumes the user issuing the CREATE VIEW statement.
   
   

3. In the View name field, type a 1- to 18-character name that is unique within the current server. This identifies the view.
   
   

4. Edit the contents of the SQL statement box to enter the values that you want for the COLUMN, AS, WITH, SELECT, FROM, and WHERE clauses. You can:
   
   

   • Click the Undo push button to revert the text to a previous state. There are four possible results:
     
     
     • Resets the text box to its initial state if you have modified the template.
     • Resets the text box to the text that existed just before clicking Clear, if Clear was clicked.
     • Resets the text box to the text that existed just before launching SQLAssist, if the SQLAssist push button was clicked.
     • Resets the text box to the text that existed just after launching SQLAssist, if text is modified after generating an SQL statement
       
       
   • Click the Clear push button to erase the entire contents of the SQL statement text box.
     
     
   • Click the SQLAssist push button for help building a SELECT statement. A SELECT statement is needed in the AS clause when you create a view.
     
     
     

5. Select a radio button to indicate whether you want check option None, Cascaded, or Local.
   
   

6. Optional: In the Comment field, type any comments about the view. You can type up to 254 characters.
   
   

7. Click OK to save your changes and close the window.
   
   

View owners and privileges

About granting and revoking privileges