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 | File record names have alphanumeric characters only and have 80 characters at most. Each name is unique within the adapter configuration. |
| Description | (Optional) Description of the positional file record. |
| Position From Header | This option 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 | Selecting this check box removes blank spaces for each field identified for the record in data file. |
| Repeating Delimiter | Specifies whether to ignore repeated delimiters. Selecting this check box translates any repeated delimiters between fields as only one field separator. Clearing the check box translates 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). |
| Length | Active only if you have selected Record Length in the Identifier Type field. |