If the table I want to load does not yet exist can I create a new one without leaving RC/Extract?

Document ID : KB000049293
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

At the Target Definition creation stage during Target mapping it is sometimes discovered that the target tables don't currently exist. This is evident when the target names are entered when the "Map" column changes from YES to NEW. This means that the table does not exist or was not found by that name. The target table needs to be created if the name is the correct one.

Solution:

To create the target table the "T" for Template line command is entered in the "C" column on the far left of the Target Mapping screen next to the source table name.

C S Source Object
T S TABLE1

The template command takes you to the CA RC/Update Table Template screen in order to create the new table. The target table information that was entered has been copied into the screen along with the tablespace and database information from the source table for convenience as well as all the columns from the source table and the other source table attributes.

These can then be changed if required and when ready the PF3 key can be pressed to generate the DDL. When the DDL is displayed it can be submitted online or the EDIT command can be used to further edit the code before execution.

Return to the Target Definition screen using PF3 when the DDL has been executed successfully.

The table will be ready to be loaded now.

Note: A valid CA RC/Update license is also required to use this feature.