To edit a database function set, select Tools > Database Functions > Maintain Database Functions.
Select a database function set from the Function Set drop-down list.
A group of buttons used to maintain the list of functions in a function set is available on the right side of the screen. These buttons are not available for standard function sets.
To add a new function to the database function set:
Click the New button.
Enter the details for the new function and then click OK.
Field | Description |
|---|---|
Function Name | This field is mandatory and must be unique within the group. |
Group | Select a group from the drop-down list or add a new group name. This field is mandatory. |
Description | Enter a description for the function. |
Syntax | Enter the syntax for the function. |
Model | This is the text that will be pasted into the transformation/ model fields when the function is selected. This field is mandatory. |
Default Column | This is the text that will automatically be highlighted when the function is used in the transformation/model screens. To set the default column, highlight it in the model field and then click the Default Column button. The default column is shown in red in the Model field. |
Clear Default Column | Click this button to clear the default column. |
To copy an existing function in the database function set:
Select the function and then click the Copy button.
Enter a new Function Name and change any other details; then click OK.
To edit an existing function in the database function set:
Select the function and then click the Edit button on the right.
Change any fields as required and then click OK.
A function can also be edited by double-clicking the function.
To delete an existing function in the database function set:
Select the function and then click the Delete button.
Click Yes to confirm the delete.
To move a function in the database function set up or down in the list:
Select a function and then click the Move Up button on the right to move the function up in the function list, within its group; else click the Move Down button on the right to move the function down in the function list, within its group.
To move a group of functions in the database function set up or down in the list:
Under the Group column, select any function in a particular group and then click the Move Up button under the Groups heading on the right to move the function group up in the function list. Similarly, use the Move Down button under the Groups heading to move a function group down in the function list.