Example: Lookup Table support

To use multiple stored procedures in an interface:

  1. Open the Lookup Table Configurator and select Advanced Database Lookup.
  2. Select the Database Connection.
  3. Click Configure to open the Inbound (Outbound) SQL Statement Configurator dialog box.
  4. Select the stored procedure to configure and assign the In and Out variables.
  5. Click OK to save the configuration.
  6. Repeat the process for the other stored procedures that are required to dynamically lookup.