These settings enable you to set the default templates to use for the update routines of each table object 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 subtype.
- 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"