Use Table data to process a message

After you have created one or more Tables in a DML Mapping Project, you can retrieve the data in the Tables to use in message processing. To do this you use DML Table functions that you add to DML expressions.

To use a Table in Mapping Services, you must complete the following steps:

  • Add the Table Function to the DML expression field from which you want to the Table data
  • Define the table_name parameter of the Table Function.
  • Define the other Table Function parameters.

Add a Table Function to a DML expression

  1. Display the Mapping Services expression field in which you want to use a Table Function.
  2. On the Tools menu, select DML Object Browser.

Mapping Services opens the DML Object Browser.

  1. In the DML Object Browser, double-click the DML Function folder. Mapping Services displays a list of predefined DML Function folders.
  2. Double-click the Tables folder. Mapping Services displays a list of Table Functions.
  3. Drag-and-drop the Table Function to the expression field in Mapping Services. Then Mapping Services adds the Function to the expression field.

Define the table_name parameter

After you add the Table function to the DML expression you need to edit the function to refer to the appropriate Table. You enter the Table name in the table-name parameter of the function.

If you:

  • know the name of the Table and the Table is located in the current Folder, you can type the name of the Table directly into the table-name parameter in the expression. Type the name in the parentheses of the Function.
  • do not know the name of the Table or if the Table is not located in the current Folder, complete the following steps:
  1. On the Tools menu, select Entity Browser.

Mapping Services opens the Entity Browser and in the Folder tab displays a list of Folders that are in the local Entity.

  1. In the Folder tab, double-click the user Folder that contains the Table you want to use.

In the left screen, Mapping Services displays all of the objects available in that folder.

If there are a large number of objects you can use the bottom left screen to filter the types of displayed objects.

  1. Drag-and-drop the Table to the table-name parameter parentheses of the Table Function. Mapping Services writes the name of the Table into the parameter. If the Table does not belong to the current WorkFolder, Mapping Services prefixes the name of the Folder to the name of the Table, as follows: Name_Of_Folder.Name_of_Table.

Related topics

Use Tables

Related Links