MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » November 2006

FTPing file from the iSeries to a mainframe



fixed

from: "Douthat, Trent" <trent.douthat@xxxxxxx>
subject: FTPing file from the iSeries to a mainframe

I have a database file with one variable length field in it. The 
field
is 4500 bytes long plus 2 bytes to contain the field length.

I'm having a heck of a time getting a file to the mainframe as a 
datasetwith variable length records. I've experimented quite a bit 
but I keep
ending up with either
1. junk at the beginning of the record or 
2. the records are wrapping or
3. the records get truncated.

My theory is that if I convert the file to an IFS ASCII file and then
FTP it from the IFS, it ought to work, but it doesn't.

Does anyone have any experience getting an iSeries database file with
variable length fields transferred successfully to a mainframe 
dataset
with variable length records using FTP? If so, what FTP parms did you
use?

Thanks,
Trent Douthat

Trent,

What are teh commands that you are using?  

(after you login)
QUOTE SITE CDUP   <-- This will set your 'root' to null rather than 
prefixing User ID
QUOTE SITE RECFM=VB LRECL=(Max record length) BLKSIZE=(a number you 
calc. or SMS will)
PUT LIB/DB 'HLQ.SLQ.TLQ' 

Let me know how that works.

Mike.

 






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact