Using a Reference Table Query in a Flex

Use a reference table query to obtain data from an external database table for processing by a SPLASH routine in a Flex operator.

1. Obtain the necessary information about the external database table containing the information you wish to look up:
   • the name of the table containing the data.
   • the schema for that table.
   • the service to use to connect to it.
2. Create the reference table query in your project.
3. Create the input stream or window.
4. Create the Flex operator:
   1. From the Palette, under Streams and Windows, select Flex (), then click an empty area in the diagram.
   2. From the Palette, select Connector and connect the input stream or window to the Flex operator.
   3. From the Palette, select Connector and connect the reference table query to the Flex operator.
   4. Define the schema for the Flex operator.
   5. (Optional) Click on Aging Policy ().
   6. (Optional) Click Set Output Keep Policy () to set keep policy options.
5. Implement a SPLASH routine:
   1. In the Flex operator, under Methods, click on the () of the expression you wish to edit.
   2. In the Edit Expression Value dialog box, write the SPLASH script you wish to implement.
      See the Programmers Guide for examples of SPLASH routines in a Flex operator.