Creating Models › Target Servers for Physical Models › Database Property Editors › Teradata Physical Property Editors › Define Teradata Macros

Define Teradata Macros

You can use the Teradata Macro Editor to define a set of statements that are frequently used or that perform a complex operation in a Teradata physical model.

To define a Teradata macro

1. Click Target-Teradata, Macros on the Model menu.

   The Teradata Macro Editor opens.

2. Select a macro and work with the following options:

   Note: Click New on the toolbar to create a new macro. Use the Enter filter text text box to filter a very large list of macros to quickly locate the one you want to work with.

   Name

   Specifies the name of the macro.

   Database

   Specifies the schema of the database to which the table belongs. Select from the drop-down list.

   Type

   Shows the type of the macro. Select from the drop-down list. Valid values are Model Level or Table Level.

   Attach To New

   Specifies if upon creating a new (table-level only) table, this script will automatically be attached to it.

   Enabled

   Specifies if the macro is enabled or not.

   Use Replace Syntax

   Lets you select whether Forward Engineering will use the REPLACE command instead of the CREATE command.

   Generate

   Generates DDL for this object during Forward Engineering.

   Generate as Pre-Script

   Specifies whether the DDL for this object must be generated as pre-script. Valid values are true or false.

3. Enter the macro code in the text area on the Code tab. Click the Text Editor icon to work with the macro code in a larger box. Click the Macro Toolbox icon to open the Macro Toolbox where you can select and insert a pre-configured macro.
4. Work with the other tabs in the editor to access additional design features, for example:
   • View the fully expanded macro code on the Expanded tab.
   • Work with parameters associated with the macro on the Parameters tab.
   • Work with permissions on the Permission tab.
   • Change the object creation order on the Object Creation Order tab.
5. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
6. (Optional) Click the UDP tab to work with user-defined properties for the object.
7. (Optional) Click the Notes tab to view and edit user notes.
8. Click Close.

   The Teradata Macro Editor closes.