FTP to an iSeries

[Jennifer Higbie]

I’m attempting to write to a table on an iSeries partition using the Fileset FTP protocol and am receiving the following error message:

FTP command APPE chfpatient failed:  426-Unable to close file.  Error code CPE3101.

426 Data transfer ended.

I’ve successfully written data to our iSeries box before.  The only difference I know of with this file is that it is a DB/2 file created using an SQL stmt on the iSeries.  Previous files I have written to were physical files created using a DDS.

If there are any iSeries programmers/interface developers out there that can help me out – I’d sure appreciate it!

Thanks!

Topic

[David Bolin]

You should attempt a manual ftp (external to cloverleaf) from the engine server to the iseries.  This will help determine the source of the problem. SQL creates physical files too. The main difference is the name of the member within its physical file. Maybe you left that off and need to use it. Its in the form library.file.mbr. If you leave the member off then it defaults to same name as the file name.

[Vince Angulo]

If it’s a large file you’re trying to append, check the SIZE parameter of the PF.  If it’s like ours it defaults to 10K records with 3, 1K increments. If you’ve exceeded that, I believe it will give a 426 error.

[Jennifer Higbie]

David:

I thought I had tried the library.file.member format before I posted my question originally, but thought I would test it again.  My attempt today to use that format resulted in the following message:

[fset:cont:ERR /0:  CHF_db_out1] FTP command ‘APPE intraapps.chfpatient.chfpatient

‘ failed: ‘501 Unknown extension in database file name.

‘

I believe I read in another post when I was researching the issue, that Cloverleaf thinks that anything longer than 3 chars after the “.” is invalid.  I tried file.member and that also fails.

Vince:

The file I am writing to is new with only a few records in it.  I have not reached the 10K limit yet.

If you have any other suggestions, I’m willing to try them!

Thanks!

[Jennifer Higbie]

David & Vince,

Well, I finally got it to work.  The configuration is no different than any of my other FTP’s to the iSeries.  The only thing I can think of was some type of corruption existed.  I deleted it and rebuilt it and now it’s working!

Thanks for your suggestions!

[Author]

Replies