Adding columns to a table

A column in a table represents an attribute of an XML element.
Before you begin
About this task
To add columns to a table:
  1. Start IBM® InfoSphere™ Data Architect and load the data model.
  2. Select the table where you want to add the columns, right-click, and click Add Data Object > Column.
  3. In the Properties view, specify the properties of the attribute.
  4. In the Project Explorer view, right-click the table where you added the columns and click Generate DDL.
  5. Make sure to select the following options: Fully qualified names, CREATE statements, COMMENT ON statements, and IN TABLESPACE clause.
  6. Click Next.
  7. Make sure to select the following options: Check constraint, Foreign key constraint, Primary key constraint, and Tables.
  8. Click Next.
  9. Select Run DDL on server, click Next, select the data warehouse connection, and click Next.
  10. When prompted, type the user name and password for the database connection.
  11. Click Finish.

Feedback