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


Change Column Selection wizard

Use this wizard to replace all columns in an existing table or to append columns to an existing table.

This wizard applies to tables that are mapped to data structures in CA-Datacom, CA-IDMS, CICS® VSAM, IMS™, sequential files, and native VSAM.

Specify to Replace or Append Columns page

Use this page to specify the copybook that contains the columns that you want to substitute for the current columns or append to the current columns.

Record
For CA-Datacom, CA-IDMS, CICS VSAM, sequential, and native VSAM: Select the record in which the elements for the additional columns are located.
Segment
For IMS: Select the segment that contains the fields that you want to map to replacement columns or additional columns in the table.
Copybook
Type the path and name of the copybook that contains the information for the additional columns. For example, if your project is named MyProject and your copybook is named copybook1, type \MyProject\copybook1. You can click Browse to select a copybook that is located on your file system.
Replace all columns
Specifies to replace all of the columns in the table with columns that you select in this wizard.
Replace all columns from selected segment
For IMS: Specifies to replace all of the columns that are mapped to fields in the selected segment.
Append to existing columns
Specifies to append the columns that you select in this wizard after the last column in the table.
Calculate starting offet
Select to specify an offset at which to append the first column that you select in this wizard.
Use offset
Type the offset at which to append the first column that you select in this wizard. The offset must be equal to the offset of the current last column plus the length of the current last column.

Select Elements page, or Select Fields page

Use this page to select items to map to columns in the table.

Table usage
Specifies how the table is being used in the project.
Select 01 level
If the copybook contains more than one 01 levels, select the 01 level that contains the fields that you want to map as columns in the table.

For descriptions of the other controls on this page, see these help topics:

Mapped Records for Table table-name page

Use this page to verify the columns that will be created when you generate and run the DDL.

You can click Finish to generate the model for the table.



Feedback

Update icon Last updated: 2006-12-15