WebSphere logo Classic Federation Server for z/OS, Version 9.1
WebSphere logo Classic Replication Server for z/OS, Version 9.1
WebSphere logo Classic Data Event Publisher for z/OS, Version 9.1
WebSphere logo Data Integration Classic Connector for z/OS, Version 9.1


Adding or replacing columns in tables based on copybooks

Use the Append Column wizard to add or replace columns in logical tables that are based on copybooks.

Before you begin

The copybook that contains the columns that you want to use must be listed in the COBOL Copybooks folder in your project.

About this task

You can use columns from the copybook on which the table is based or you can use columns from a different copybook.

Procedure

To add or replace columns in a table that is based on a copybook:

  1. Right-click the table and select Modify Table > Update Columns.
  2. On page one of the wizard, select the copybook that contains the columns that you want to use.

    If the table is for an IMS™ data source, select the segment for the columns that you either want to add columns to or that you want to replace with different columns.

  3. On page two of the wizard, select the data that you want to map to new columns.
  4. On the summary page, verify that the table contains the columns that you want. Click Finish to generate the updated model for the table.
Related tasks
Modifying the selection of records in tables for CA-IDMS databases
Mapping tables and creating publications for Classic event publishing
Mapping tables for Classic federation
Mapping tables for Classic replication
Related reference
Column properties
Database properties
Publication properties
Publishing queue map properties
Table properties
View properties
Index properties
Stored procedure properties


Feedback

Update icon Last updated: 2006-12-15