Re: FTP unable to open or create target file with some files

[Gord Hutchinson <gordm1@xxxxxxxxxxxxxxx>]

>On Tue, 10 Jan 2006 15:35:27 -0700, "Dave Odom" <Dave.Odom@xxxxxxxxxxxx> wrote:

>Well, I found the answer after working with IBM and I was surprised by
>the answer.    The short answer is:  When you have certain table
>attributes, like DECIMAL or NUMERIC, even though the movement of data is
>between LPARs in the same iSeries machine, you may need to use the FTP
>commands: TYPE E and MODE BLOCK.    
>

Dave,

Thanks for this.

We have had a 'situation' this week were a developer had used SQL to update
fields, including a type L date field, in a DDS defined file.  Afterwards,
FTP would fail on the records updated by SQL.  CPYF would work fine.
RCVNETF would work fine but FTP would fail.

I included these commands in the FTP script and FTP now copies the file OK
as well.


Again, thanks.


Gord