Create and Template During Load
If you are mapping to an object that does not exist (and the database and tablespace already exist), the object is automatically created when loading the extracted data (if Extract DDL was set to Y for DDL Options on the Process Source Definition panel).
Creation During Load
If you are mapping to an object that does not exist (and the database and tablespace already exist), the object is
automaticallycreated when loading the extracted data (if Extract DDL was set to Y for DDL Options on the Process Source Definition panel).
If the database or tablespace does
notexist, an error message appears when attempting the load.
Template a New Object
Instead of automatically creating a new object when loading the extracted data, you can use the T line command on the Target Mapping panel to jump to
CA RC/Update™ for DB2 for z/OSto create the object yourself. A valid
CA RC/Update™ for DB2 for z/OSlicense is required to use this feature.
You create a new object using an existing object as a template. The Table Template screen in
CA RC/Update™ for DB2 for z/OSdisplays the values used to create the template object, letting you specify many more parameters for the new object than if you only used the
CA RC/Extract™ for DB2 for z/OSautomatic object creation feature. With automatic object creation, you can specify only the object name, creator, database name, and tablespace name. When you use the T line command, you can set specific parameters for your new object, such as removing EDIT PROCS, changing column level defaults, and so forth.
Follow these steps:
- EnterTthe Target Mapping panel in the C column next to the target object that you want to template.The Table Template screen appears, listing the values defined for the “templated” object.
- Specify table parameters by editing the fields on the Table Template screen, and press the END key to exit.You are returned to the Target Mapping panel, and the value YES appears in the MAP column, indicating that the target object exists and has columns, which correspond to each of the columns in the source object.If the object you are templating has an index, you must create an index for your new objectSee theCA RC/Update™ for DB2 for z/OSdocumentation for details.