I have a couple of users that have just over the past couple of weeks begun to complain that their download files are not sequenced correctly. Here's the scenario:
- Positive Pay file to send to the bank is built by check run program on i.
- Users use i Access for Windows "Receive File From Host..." option on the Actions menu to retrieve the file down to their desktops, then FTP them to the bank.
- Files have a format defined by the bank, the sequence of records being important: Voids first, Checks next, Total last.
- The records in the table on the i follow this format, i.e.; the total row is last.
- For the past two weeks on Monday, the files are being downloaded from the i with the Total row first. The rest are in the correct sequence.
- There is no "order by" clause specified in the data options of the transfer.
Last week, I had the user change the "Sort sequence" on the "Misc" tab under the "Format options" button from "System i Default" to "Hexadecimal". That seemed to work...for the rest of last week. This morning it failed again. I had the user try every different option available for "Sort sequence" (except User Specified Table) with no changes to the order of the lines in the downloaded file.
What could be causing the file transfer to change the sort sequence of the records in the table?
Any ideas?
-Michael
- Positive Pay file to send to the bank is built by check run program on i.
- Users use i Access for Windows "Receive File From Host..." option on the Actions menu to retrieve the file down to their desktops, then FTP them to the bank.
- Files have a format defined by the bank, the sequence of records being important: Voids first, Checks next, Total last.
- The records in the table on the i follow this format, i.e.; the total row is last.
- For the past two weeks on Monday, the files are being downloaded from the i with the Total row first. The rest are in the correct sequence.
- There is no "order by" clause specified in the data options of the transfer.
Last week, I had the user change the "Sort sequence" on the "Misc" tab under the "Format options" button from "System i Default" to "Hexadecimal". That seemed to work...for the rest of last week. This morning it failed again. I had the user try every different option available for "Sort sequence" (except User Specified Table) with no changes to the order of the lines in the downloaded file.
What could be causing the file transfer to change the sort sequence of the records in the table?
Any ideas?
-Michael
Comment