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