Template objects are used to generate the update routines of table objects in RED, e.g. generation of DDL, update/custom procedures, and host scripts. Templates are very similar in their operations to Scripts.
The additional context menu option is Usage Report which enables you to identify the table objects that are associated with a selected Template object.
Following is an example of the menu displayed when you right-click a Template object.

WhereScape RED supports the use of keyboard shortcuts—the underlined letter of a menu option. For example, pressing P opens the Properties window of the selected template, pressing U displays the RED objects that are using the template, etc. Ensure that the Windows > Control Panel > Ease of Access setting associated with keyboard shortcuts is enabled, to display keyboard shortcuts in RED. Refer to the relevant MS Windows documentation for details.

Selecting Usage Report displays a list of objects that are currently using the selected template in the middle pane.

You can select multiple objects from the list and then select Code from the right-click context menu to perform a bulk update procedure or script of the selected objects. Refer to Templates for details.
You can also define default templates to use for the update routines of table objects in RED by Connection type—refer to Routine Templates for details.

The Version Control sub-menu for Template objects provides New Version, Build Application, and Duplicate Object options.


  • No labels