If a template exists of the correct Type and Target DB, templates can be specified and evaluated as follows:
Operation | Location to Specify the Template | Notes |
|---|---|---|
Alter Table DDL | Connection Properties > Target Settings > Default Table Alter DDL Template | Only for Custom database targets (on SQL Server, Oracle and Teradata). |
Create DDL | Table Properties > Storage > Create DDL Template Connection Properties > Target Settings > Default Table Create DDL Template Connection Properties > Target Settings > Default View Create DDL Template | DDL is evaluated for the object at runtime, if a template is specified in the Storage tab. Alternatively, clicking the Derive DDL button in the Override Create DDL tab generates the Override DDL based on the specified template. Important If an Override DDL is specified, the Override DDL is used at runtime. |
Create Index DDL | Connection Properties > Target Settings > Default Index Create DDL Template | Only for Custom database targets (on SQL Server and Oracle). |
Drop Index DDL | Connection Properties > Target Settings > Default Index Drop DDL Template | Only for Custom database targets (on SQL Server and Oracle). |
Export Script | Export Object Properties > Script Template | |
Load Script | Load Table Properties > Script Template Connection Properties > New Table Default Load Script Template | |
Update Procedure | When building the Update Procedure, specify a template to use in the Template drop-down field of the Update Build Option > Processing tab. |
|
Custom Update Procedure | Table Properties > Custom Procedure | Only on SQL Server, Oracle and Teradata |
Update Script | Table Properties > Update Script | Only for Custom database targets (on SQL Server, Oracle and Teradata). |
Post Load Procedure | Load Table Properties > Post Load Procedure | Only on SQL Server, Oracle and Teradata. |
Post Load Script | Load Table Properties > Post Load Script | Only for Custom database targets (on SQL Server, Oracle and Teradata). |
To check which Operations are supported by Templates on your Target database, refer to Templates for details.
Note
- The template of the right type and database controls the availability of the template options above, e.g. the template selection fields are only available if valid templates exists.
- Most of the default settings for Templates are configurable in the Connection Properties > Target Setting tab. Refer to Connection Target Settings for details.
- The template object context menu that is displayed when you right click a Template object from the Objects list on the left pane provides a Usage Report option, which enables you to list the table objects that are currently associated with the selected template. Refer to Working with Objects > Templates for details.
- Additional host script language types which can be applied to templates can be defined in RED. Refer to Host Script Languages for details.