× 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.



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.

 


As an Amazon Associate we earn from qualifying purchases.

This thread ...


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.