Flat file definition metadata
Metadata in a flat file is captured in a flat file definition. Some metadata are mandatory and some are optional. You define mandatory metadata by using a message default or by setting the metadata on the group, record, or field level. For example, the mandatory metadata for a field are: Name, Tag Name, Data Type, and if applicable, Start Position.
For more information, see the topics "Flat File Definition format" and "Changing the Message Component Property Values" in this user guide.
These tables show a list of metadata and description for each component in a flat file definition.
File
This table shows File component metadata:
Metadata | Details |
---|---|
ID | Identifier for a message transformation definition |
Messages | Allows only one message per file |
Message Definition
This table shows Message Definition component metadata:
Metadata | Details |
---|---|
Name | Specified for documentation purposes |
Tag name | Specify a tag identified in XML or a tag written to XML |
Escape character | Escape sequence for field and record separators |
Record separators |
Common record separators are: Carriage return: Line feed: |
Fixed length separator | If set to true, it defines fixed lengths of records |
Field separator fields |
Specify a value. There can only be one separator in a message. A record separator is considered as a valid separator. This value overrides any field length definition. |
Ignore preceding field separator | Select to ignore preceding field separators |
Default alignment | Specify the alignment to use when a field does not have a defined alignment. You can use a numeric and alpha field value. |
Default padding | Specify the padding character to use when a field does not have a defined padding character. You can use numeric and alpha field value. |
Default trim |
Specify a trim behavior for XML to record if no trim is defined for a field. Use this to remove a preceding and trailing white space or keep the data unchanged. You can set this for a numeric and alpha field values. |
Default empty field value | Specify a value to use if the data is empty for a field or tag. If left blanks, empty fields contain empty tags. |
Add first field separator |
Specify an extra field separator which is defined on the message level in front of the first field of every record in the message |
Add last field separator | Specify to add extra file separators after the last field of every record in the message |
Group
This table shows Group component metadata:
Metadata | Details |
---|---|
Name | Used for documentation purposes |
Tag name | Tag to identify or write |
Minimum occurrences | Minimum required number of times this group must occur |
Maximum occurrences | Maximum number of times this group is allowed to occur. Specify a 0 (null) value for unlimited occurrences. |
Record
This table shows Record component metadata:
Metadata | Details |
---|---|
Maximum occurrences | Specify the allowed maximum number of times for this group to occur. Specify a 0 (null) value for unlimited occurrences. |
Name | Used for documentation purposes |
Tag name | Select a tag to identify or a tag to write |
Minimum occurrences | Specify the minimum required number of times this group must occur |
Maximum occurrences | Specify the maximum number of times this group is allowed to occur. Specify a 0 (null) value for unlimited occurrences. |
Field
This table shows Field component metadata:
Metadata | Details |
---|---|
Name | Used for documentation purposes |
Tag name | Tag to identify or write |
Data type | Specify a data type value to differentiate alignment, padding, trimming, and default empty value handling. You can use a numeric and alpha field values. The default value type is alpha. |
Padding character | Character to pad this field |
Alignment | Alignment to use for this field |
Empty field value | Value to use if this field is empty |
Trim | Indicates whether to trim the field |
Identifier | Defines whether this field is an identifier |
Default value | Identifier value that is tested against, or written to. |
Start position | Field starting position if length-defined fields (no field separator) are defined |
Length |
If the field length is shorter than this length, then the field is padded. If the length is used as parsing fields without a field separator, then the last field is defined as "-1" , which allows the field to have a variable length. |