If you develop your IBM^® database SQL and SPL routines and database objects in the Server Explorer, you can review and update their DDL scripts by using the IBM Script Designer.

Reviewing and updating scripts for overloaded procedures that are based on data type produces undefined results.

To review and update the DDL script for an SQL or SPL routine or a database object:

1. In the Server Explorer, right-click the SQL or SPL procedure or function, or the database table or view, and then click Show Script on the shortcut menu.

   The IBM Script Designer opens and displays the DDL script for the routine or database object.

2. Optional: To update the DDL script:
   1. In the Script section of the Script view, change the script as needed. If appropriate, you can insert code fragments by using the Insert SQL commands on the shortcut menu.
   2. Remove the comment notation from the line in the script that contains the DROP command.

      Important: If you are updating the DDL script for a table, you lose all the data in the table if you drop the table.

   3. From the IBM Script Designer menu, select Execute Script.

      The IBM Output Message Pane displays the status messages as the script runs.

See Also

IBM Script Designer | Editing the Source Code of Procedures, Functions, or Objects | Managing Procedures, Functions, and Objects

.NET Development Forum   DB2 FAQs   IDS FAQs

© Copyright IBM Corporation 2002, 2019. All Rights Reserved.