Re: CPYTOIMPF

[Martin Rowe <martin@xxxxxxxxxx>]

On Friday 20 July 2001 01:55, saustad@deltadentalwi.com wrote:
> 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 field, 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 are missing, or something?  Any help would be greatly
> appreciated.  Thanks.

You can try my free CRTCSVDTA utility http://www.dbg400.net/crtcsv.html 
that should do what you want. By default the field separator is a comma 
but you can specify any value. You'll need to run a CPYTOSTMF afterwards 
as CRTCSVDTA (currently[1]) creates the data in flatfile format in a 
database file. One of the reasons for writing the tool was to get rid of 
the trailing blanks - I never found a method of getting CPYTOIMPF to work 
the way I wanted.

Regards, Martin 

[1] I have a CRTPCF - Create PC file front end to it that combines the 
two, as well as a few other options, but it hasn't made onto my site yet 
- email me if you want me to get a move on with it ;-)
-- 
martin@dbg400.net / jamaro@firstlinux.net
http://www.dbg400.net  DBG/400 - DataBase Generation utilities 
Open Source test environment tools for the AS/400 / iSeries and 
miscellaneous database & spooled file management commands.
+---
| 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
+---