Mapping Columns to a new Target Table
Mapping columns to a new Target Table includes:
Opening a CONNX Data Dictionary (CDD).
Viewing, and if necessary, changing some of the target table metadata.
Map columns to a new Target Table if:
You wish to change the target table metadata so it is different than the source table metadata.
You don't need all of the source columns replicated to the target table.
After you map columns to 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 database and it has not been created or deployed.
When InstantdbSync creates a Target Table, it assigns column source and attributes based on the associated Source Table. Map Columns allow you to change the column source and the column attributes.
CAUTION:
InstantdbSync cannot create Adabas Target Tables, therefore you cannot map columns to a new Adabas Target Table. All Adabas Target Table changes must be done using Adabas, not InstantdbSync.
To map columns to a new target table:
1. Open the InstantdbSync CDD.
2. Select a Target Table to view. Click Map Columns. The Map Columns window appears:
The Index entry is used to indicate if a field will be part of the target table index. Even if your source table contains multiple index fields, you can only use a single unique index for replication. You can indicate the index order by designating "1" as the first part of the index, "2" as the second part of the index (if necessary), and so on. A zero means this field is not part of the index.
The Source Column names are pre-populated and cannot be changed.
Select the correct SQL data type in the source and target Data Type fields.
You can change the source and target Length, Precision and Scale values if they are incorrect.
Target Column is pre-populated with the same name as the Source Column. This name can be changed.
Note:
You cannot use InstantdbSync to change the order of the rows in the Source Table.