Re: VAX FTP to AS/400 (via NT) with packed f

[Terry Grider <tgrider@xxxxxxxxxxxx>]

Bob,

  If you can get your file to a PC in ASCII and you have a DB2 definition of 
the file on the AS400, you can create a Client Access transfer from the
400 to the PC (even if the file is empty) and create an FDF file on the PC 
which is a field level description of the data corresponding to the file
defined on the 400.  Using this FDF, it is possible to transfer a file back to 
the 400 from the PC and it will translate the character fields to
EBCDIC and leave the packed fields alone.  One other caveat, the file on the 
400 must have a Field Reference File defined for it in order the get the
upload to work.  We do this every day to send data from a PC Cobol application 
to the 400 and it works fine.  Be sure all your packed fields are valid
though or you'll get a error.

Hope this is some help,

Terry Grider

Buck Calabro/commsoft wrote:
> 
> On 03/09/99 11:59:00 AM Bob Clarke 3rd x4502  wrote:
> 
> >solution?  Is there something about packed fields that FTP cannot deal
> >with?  Am I missing something obvious (I don't mind looking like an idiot
> 
> Nothing obvious.  The basic problem is that ftp translates on a record
> basis, not on a field basis.  AFAIK, you can't turn translation off on a
> field by field basis.  Perhaps (heaven help me for suggesting it!) perhaps
> you can get one ftp as binary and one as text and use an RPG program to
> merge the binary (packed field) data with the text (all other) data.
> 
> Buck Calabro
> Billing Concepts Inc (formerly CommSoft), Albany, NY
> mailto:mcalabro@commsoft.net
> +---
+---
| 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
+---