Generate Input Record Database Fields

Edit online

About this task

To generate input record database fields:

Procedure

  1. Right-click an input record. From the shortcut menu, select Generate Fields.

    The SQL Field Generator Wizard opens.

  2. From the Queries list, select the defined queries and click Next.

    Sterling B2B Integrator Map Editor displays only the queries that return a result set.

  3. From the Columns list, select the result columns and click Finish.

    Click Choose All to select all the columns. Click Clear to clear all columns.

    Sterling B2B Integrator Map Editor adds the specified result columns to the record and automatically generates the validation settings.