× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Try to create a query base on that file and then make a criteria to not
include that extra line.

That happens to me when I make sums.

Regards,
Marco

-----Original Message-----
From: midrange-l-bounces+marco.silva=mwbrands.com@xxxxxxxxxxxx
[mailto:midrange-l-bounces+marco.silva=mwbrands.com@xxxxxxxxxxxx] On
Behalf Of Fleming, Greg (ED)
Sent: quarta-feira, 14 de Novembro de 2007 22:47
To: Midrange Systems Technical Discussion
Subject: Extra record on iSeries to PC FTP

When I FTP a file from our iSeries to the PC, it always seems to have
one blank record at the end. Also seems to happen when I use CPYTOIMPF
to the IFS.

I reckon the CRLF on the last record is causing an extra record to be
created.

This seems to be causing our DB service provider some consternation, as
the actual record count they see is one more than the count I send them
in the control file.

I could just increase the control file count by one every time, but that
seems like cheating.

Does anyone know of a way to prevent this extra record from appearing on
the PC side ?

Thanks



Greg Fleming

Senior Programmer/Analyst

Everglades Direct, Inc.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.