data warehousing and CPYTOIMPF

[saustad@xxxxxxxxxxxxxxxxx]

I know this isn't exactly related to RPG (the extract pgm is written RPG!),
but I'm hoping I can get an answer from this list.  I tried on MIDRANGE-L,
but we didn't get many responses.

We have a data warehousing project we are working on.  We'd like to take a
physical file and copy it to the IFS as a pipe-delimited ("|"),
variable-length, ASCII text file.  The alphanumeric fields should not
contain the trailing blanks.  The numeric fields should not contain the
leading zeroes.  The CPYTOIMPF cmd seems to work, except the "pipes" are
showing up fixed in the same column on each record.  Is there a parameter
we missing, or anything else?  We are on V4R5.  Any help would be greatly
appreciated.  Thanks.

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