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 data definition files

Use the Append Column wizard to add or replace columns in user tables that are based on data definition files, such as COBOL copybooks or PL/I include files.

Before you begin

The data definition file that contains the columns that you want to use must be in the appropriate folder in your project, for example, the COBOL Copybooks folder.

About this task

You can use columns from the data definition file on which the table is based, or you can use columns from a different file.

Procedure

To add or replace columns in a table that is based on a data definition file:

  1. Right-click the table and select Modify Table > Update Columns.
  2. On page one of the wizard, select the data definition file 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
Creating CA-Datacom tables and views for Classic federation
Creating CICS VSAM tables and views for Classic federation
Creating IMS tables and views for Classic federation
Creating VSAM tables and views for Classic federation
Creating sequential tables and views for Classic federation
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: 2007-07-11