Field In an Output Record (Input Side of Map)

Edit online

About this task

If the field is located in an output record on the input side of a map, both the input and output records are functional.

Note: If the field is contained in an output record, the validation information is set from the column information.

For more information about properties, see Sterling B2B Integrator Map Editor Properties.

To create a output record field on the input side of the map:

Procedure

  1. Right-click a map object. From the shortcut menu, select either Create Sub or Insert.
  2. From the shortcut menu, select Field. The SQL Field Properties dialog box opens.

    For more information about properties, see Sterling B2B Integrator Map Editor Properties.

  3. In the Name tab, specify the following:
    • Unique field name
    • Description
    • Additional notes (if applicable)
  4. Is this a field on the input side of the map?
    • If Yes, click the Query tab and continue with the next step.
    • If No (this is a field on the output side), select the Column tab and continue with step 8.
  5. From the Associate Statement Record list, select the record with which this field is associated.
  6. From the Name list, select the table name.

    If the Name list is not available, you did not test the SQL query. Instead, select a number from the Number box.

  7. Do you want to enable nulls?
    • If Yes, select the Nulls Allowed option and continue with step 11.
    • If No, continue with step 11.
  8. In the Column tab, select the column name from the Name list.

    If the Name list is not available, you did not select to connect to a data source to create a table in the SQL File Properties dialog box. Instead, select a number from the Number box.

  9. Do you want to enable nulls?
    • If Yes, select the Nulls Allowed option and continue with the next step.
    • If No, continue with the next step.

      This option is applicable only for fields in an output record.

  10. Will this field be used in a WHERE clause?
    • If Yes, select the Table Key option and continue with the next step.
    • If No, continue with the next step.
  11. In the Validation tab, specify the following:
    • Whether the field is required
    • Minimum length
    • Maximum length
    • Type of data
    • How the data is formatted
  12. Do you want to specify a standard rule for this field?
    • If Yes, click the Standard Rule tab, define the rule, and continue with the next step.
    • If No, continue with the next step.
  13. Do you want to specify an extended rule for this field?
    • If Yes, click the Extended Rule tab, define the rule, and continue with the next step.
    • If No, continue with the next step.
  14. Click OK to save the field and close the SQL Field Properties dialog box.