I am having a problem trying to create a schema that does the following:
There are two record types. The header record that is 47 characters long with the first 6 characters identifying the header record and the there is a series of body records with no identifier which is 143 characters long. Both record must be defined as fixed width and each record separated by a semi-colon.
I’ve tried defining each record in a dictionary with fixed width fields. In the Flat File schema I have defined the records to be record delimited by a ‘;’ under the assumption that the field will be broken up by their dictionary definition. In the schema In the flat file structure section I set the default record as the body record and the header set as a record reference with the name being the first 6 characters to define the record.
When I test the schema, the schema doesn’t recognise the first 6 characters and so it goes directly into the default record definition for each record.