Fixed-length Format File
Some systems may require fixed-length record formats. As described by IBM:
"In fixed-length or fixed-format records, each field starts and ends at the same place in every record. A data file that contains data records of equal and constant length might be organized as follows.
aaabbbbcccddddggghhhh
The data illustrated above has three records. Each record has a field of three characters followed by a field of four characters, so the total record length is seven characters. The file does not contain any separation between records; delimiters are unnecessary because all fields have the same length.”
Reference: IBM® Informix® 12.10
In the above example, the records are not separated with a newline character (
). For such types of file, line separator should not be enabled in the data source. Refer to Managing Data Source for details.
Fixed-length file only works with FPE algorithms.
References
We have provided samples of fixed length file where records are separated with a newline character () followed by its data source configuration.
