Download INFORMIX-Enterprise Command Center User Guide

Transcript
Modifying CREATE Statements
4.
Right-click anywhere in the SQL Statements text box and select
Execute All SQL from the popup menu.
The edited CREATE statement is submitted to the database server for
execution. If the execution is successful, the new database object
appears in the IECC window.
5.
Choose File➞Save from the database object editor menu bar to save
this CREATE statement as a text file.
The Save dialog box appears.
6.
Specify the full pathname of the file in the dialog box, then click Save.
Tip: If the database object editor for the database object you want to create is already
launched, you can choose File➞New from the editor menu bar instead of following
Steps 1 and 2, above. Alternatively, you can open a CREATE statement saved as a text
file by choosing File➞Open from the editor menu bar. Then you can modify that
CREATE statement instead of following Steps 1 through 3, above.
Modifying CREATE Statements
You cannot modify stored procedures, views, and triggers. If one of these
database objects has properties that are inappropriate for your needs, you
must first drop the object, re-create it with the desired properties, and regrant privileges.
The database object editors aid you in dropping and re-creating database
objects. When you open a database object’s CREATE statement by navigating
to the object in the IECC window and double-clicking the object, the editor
inserts a DROP statement and explanatory comments before the CREATE
statement. For an example, see Figure 6-3 on page 6-25.
Modify the CREATE and GRANT statements as necessary, then submit the
DROP, CREATE, and GRANT statements to the database server for execution.
To successfully execute the CREATE statement, you must have the proper
privileges to create that type of database object. For information, see “Privileges Required to Manage Database Objects” on page 6-5.
Important: Neither the DROP statement nor the modified CREATE statement takes
effect until it is successfully executed by the database server.
Database Object Management 6-23