Re: Client Access file Xfer from the AS400

[PaulMmn <PaulMmn@xxxxxxxxxxxxx>]

>Hey again, I know you guys like to hear from me because my questions
>are easy to answer.  I hope this one is the same.
>I need to xfer data from the AS400 into a vendor file.  The vendor PC  file
>cannot be changed :), so I wondered if there was a way to get data in a
>record who's fields are 5 digits long to xfer into a file who's fields are 6
>digits long.
>I know there is an FDF which is created during a download.  Maybe CA
>is not the way to go.
>
>Thanks in Advance
>Arch


You may need to create a new DDS on the AS/400 that matches the PC file.
Then use

        CPYF   YOURFILE   PCFILE  MBROPT(*REPLACE) FMTOPT(*MAP)

CPYF should be able to handle the change in field length as long as the
field names are the same, and as long as you don't swap alpha and numeric
fields, and as long as you don't fiddle with the number of decimals in
numeric fields.

--Paul E Musselman
PaulMmn@ix.netcom.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
+---