Advanced Parameter to Parameter Mapping

In some cases, a filter parameter you use to retrieve host data is not itself available as an attribute or recordset field that can be returned to a querying application. To solve this problem, you can map a filter parameter to an output parameter in a SELECT procedure.

To map a filter parameter to an output parameter in a SELECT procedure

  1. In the Tables dialog box, click the procedure for which you want to map parameters in the Tables and procedures box.

  2. Click the Advanced button beneath the list of output parameters to open the Parameter to Parameter Mapping dialog box. The Output parameter column lists the output parameters for the current procedure.

  3. Click the Filter parameter column next to the output parameter you want to map. Then, click the list to select the filter parameter you want to map to the output parameter.

    The list of available filter parameters is derived from the Filter parameters box in the Tables dialog box. Note: If the filter parameter you are mapping here is available in the form of an attribute or recordset field on an entity, we recommend that you map the attribute or recordset field to an output parameter instead of mapping the two parameters together.

  4. Repeat step 3 for each filter parameter you want to map to an output parameter.

  5. Click Close to return to the Tables dialog box.

Related Topics
Bullet Procedures overview
Bullet Creating procedures
Bullet Tables Overview