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"



  • No labels