These settings enable you to set the default templates to use for the update routines of each table object routines of load and export objects associated with the selected connection. A default template can be set for the primary and custom update routines of each table by object type and subtypeTo set the default routine templates for table types other than Loads and Exports please refer to the Object Subtypes section.
Image Modified
| Note |
|---|
- Default Load Script Templates can be set in the source connection Properties tab.
- DDL Templates can be set in the Target Settings tab of the target connection.
- The settings in the Routine Templates tab is used in deploying applications into RED via the REDCLI command '
object generate-routine'. Refer to Dedicated Command Line Interface (REDCLI) for details. - The Routine Template defaults can also be set using REDCLI, for example:
RedCli>connection set-default-template --con-name "MyTargetConnection" --obj-type "Stage" --obj-sub-type "DataVaultStage" --op-type "UpdateRoutine" --tem-name "wsl_sqlserver_stage_dv"
|
...