Read Schema (Positional) Reference

The positional read schema has some attributes, you can check the following table for the attributes and the corresponding description:

Attribute Name Description
Name The file record names have alphanumeric characters only and have 80 characters at most. Each name is unique within the adapter configuration.
Description (Optional) A short description for the positional file record.
Position From Header This field is available only for records that are defined as immediate child record of the root record. Select Begin or End based on the structure of the actual records in the data file.
Strip Blanks Select this check box to remove the blank spaces for each field identified for the record in data file.
Repeating Delimiter Specifies whether to ignore repeated delimiters. Select this check box to translate any repeated delimiters between fields as only one field separator. Clear this check box to translate the repeated delimiters as empty fields.
Identifier Type Specifies the method to identify a record. Field Value (constant field value) and Record Length are available options.

When the Identifier Type field is set to Field Value, the constant attribute for one of the fields is specified when defining the fields for the records. When the Identifier Type field is set to Field Value, Publication Service can also be configured to check the field count in addition to the constant field value in validating a delimited record.

In addition to checking only the constant field value in validating a record, Publication Service can also be configured to check the record length.

For example, a read schema defines a record to contain three String fields with the first field containing a constant string "Order". A record, such as "Order,ID1234,Aug20" is accepted by Publication Service. However, a record with a valid constant Order but contains four fields, such as "Order,ID1234,Aug20,CA" is rejected. The following error is logged: 1 lines couldn't be interpreted.

To use this feature, you have to set the adfiles.matchFieldCountAndRecordLength property to ON in the adfilesagent.tra file (in the TIB_ADFILES_HOME\bin directory).

Note: Only one constant field value can be used to identify a record.
Length This field is available only if you have selected Record Length in the Identifier Type field.