Re[2]: AS400 (FTP --> UNIX)

[eric.delong@xxxxxxxxxxxxxxxxx]

     Haven't tried this with FTP, but it always worked with old PCS. 
     Make a LF over this file, make all numeric fields Zoned (type S) 
     and specify this LF in you FTP. OS400 will convert your packed 
     fields to zoned when mapping PF data to the LF record format.
     
     eric.delong@pmsi-services.com


______________________________ Reply Separator _________________________________
Subject: Re: AS400 (FTP --> UNIX) 
Author:  <MIDRANGE-L@midrange.com > at INET_WACO
Date:    5/11/99 2:31 PM


Tim,

Nope! If you transfer it in binary mode it will be in EBCDIC and the
numerics will still be packed. Useless.

If you transfer it in ASCII mode the character data will be usable, but
numerics will be junk. No unpacking, etc.

You can:

Write RPG code to unpack the numerics, handle the signs, etc., then
transfer with FTP.

Or, download to a PC using Client Access (etc, etc) converting to fixed
ASCII, tab-delimited, CSV, etc. and then transfer to UNIX.

Or, fiddle around with CPYTOIMPF command to convert the file, then use
FTP to transfer to UNIX.

Or, use a third-party product to get all of this done. 

If the last option is of interest we have a product that does this (data
conversion, FTP automation, FTP security) called Alliance FTP Manager.
More information here: http://www.patownsend.com

Patrick

> Tim Truax wrote:
> 
> Hello all,
> If I FTP an AS400 file that contains some packed data to a UNIX
> machine, and I use the BINARY ftp command in my script, will it be
> converted or readable on the UNIX as packed or upacked?
> :-) Tim & Dana Truax ... and Caleb :-)
> http://members.xoom.com/truax

-- 
IBM AS/400 communications, FTP automation, and network security
software and consulting services.

http://www.patownsend.com
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---