Deploying change commands

Change commands can be deployed directly against a DB2 database.
Prerequisite: A working connection to a database is required to deploy change commands.

A properly configured Database Administration Server (DAS) is not necessary to deploy most change commands, unless they involve creating a database or deploying certain DB2 system commands. Most DDL statements go through JDBC for deployment.

To deploy change commands, complete the following steps:
  1. In the Data Project Explorer, select your change command script. For example, select sample_deltaddl.chx.
  2. Right-click the script, and click Run SQL.
The database catalog is updated and will contain your changes. You can save the result of your deployed change commands to a file.
Related tasks
Creating a deployment script


Feedback

Copyright IBM Corporation 2006, 2007. All Rights Reserved.