Hereafter, the term

sequential file

is used to refer to sequential data sets on z/OS and files on i5/OS, Linux, UNIX, or Windows systems.

You must create a data map that uses the SEQ access method in the PowerExchange Navigator for a sequential file source or target. PowerExchange uses the data map to access data and metadata and to create a relational type view of the records. PowerExchange requires a relational view to use SQL‑type statements to read bulk data.

Also, run a PowerExchange Listener on the system where the source is located. Verify that this PowerExchange Listener can communicate with the system or systems where the PowerExchange Navigator, PowerCenter Client, and PowerCenter Integration Service run.

When reading a sequential file, the system determines the record length according to what has been specified in the NRDB data map properties and the operating system file APIs, then maps it into columns ready for processing by a relational system.

When writing a sequential file, the system appends the column data into a record using the data map field sizes and then writes it according to what has been specified in the NRDB data map properties.