Changing the column order in a new target table includes: Opening a CONNX Data Dictionary (CDD) Moving the rows in a column map so the target table columns are in the correct order   Change the column order in a new target table if: You want the source and target table columns to be in different order   After you change the column order in a new target table you will be able to: Create the target table Deploy the replication (which will start replicating data from source database to target database)

 

A target table is considered to be "new" if it does not exist on the target data base and it has not been created or deployed.

 

You can change the column order in a new Target Table. Columns can be grouped together even if they don't appear in that order in the Source Table.

 

Note: You can not use the Open Systems Event Replicator to change the order of the columns in the Source Table.  The Add Row, Delete Row, Row Up and Row Down buttons are only available when mapping to a new target table.  If you are mapping to an existing target table and wish to change the structure of that table, you will need to press the "Drop Target Table" button (available when mapping to an existing table).  This will drop the target table and allow you to re-create it with the new structure.  Warning: Only do this if you intend to physically drop and re-create the target table.  All data in the existing table will be lost.

 

Warning: Since the Event Replicator cannot create Adabas Target Tables, you cannot change the row order in a Adabas Target Table. All Adabas Target Table changes must be done using Adabas, not the Event Replicator.

 

1. Open the Open Systems Event Replicator CDD.

2. Select a new Target Table to change. Click Map Columns. The Map Columns window appears.

 

3. To change the order of the rows in the target table:

   1. Select the row to be moved.

   2. Click Row Up or Row Down.  The selected row moves in the specified direction.