Create and Template During Load
If the database and tablespace already exist, and you can map to an object that does not yet exist. The object is automatically created when loading the extracted data. The object is only created if the Extract DDL was set to Y for DDL Options on the Process Source Definition panel.
Creation During Load
If the database and tablespace already exist, and you can map to an object that does not yet exist. The object is
automaticallycreated when loading the extracted data. The object is only created if the 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 an object when loading the extracted data, you can use the T line command on the Target Mapping panel to use
CA RC/Update™ for DB2 for z/OSto create the object. A valid
CA RC/Update™ for DB2 for z/OSlicense is required to use this feature.
You create an object using an existing object as a template. The Table Template screen in
CA RC/Update™ for DB2 for z/OSdisplays the values that were used to create the template object. This screen allows you to specify many more parameters for the new object than using 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 and changing column level defaults.
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. The value YES appears in the MAP column, indicating that the target object exists and has columns. The columns 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.