Field Relations (import) (daxch0522m000)

After you run the Table Relations (Import) (daxch0521m000) session to define the table relations, you define the field relations.

Run the Field Relations (Import) (daxch0522m000) session to set up the relations between logical ASCII file fields and LN table fields by batch in an exchange scheme. Use the details session to specify the data to be passed to the physical ASCII files.

After you import data using Exchange, for best results, enter a record in this session to represent all the fields in the table.

LN fills in the value in the ASCII field automatically, using the logic from the Table Field, Condition, and Context fields.

The Specific menu contains this option:

  • Create Default Import Field Relations (Ctrl+Shift+G):

    Creates the field relations automatically. Ensure that the code of the ASCII file is identical to the LN table code. Use this option if the definition file of the ASCII file is not available.

To create field relations:

  1. On the File menu, click New to start the Field Relations (Import) (daxch0122s000) details session.
  2. Specify a serial number, and give this number a logical sequence number.
  3. Select the name of the field for which to create field relations. If the field is defined as an array in the data dictionary, then specify the array element number.
  4. Define the field value, condition script name, constant and increment if this field uses these values.
  5. Click Text/Conditions tab to define text parameters and to set update or overwrite permissions and the appropriate condition.
  6. In Text Settings, you can specify the language of the text and additional parameters.
  7. In Permitted Operations, you can specify the update and overwrite permissions and the appropriate conditions, if required.
  8. Click Edit Text on the toolbar to start the text editor to add more information.