Re: automate .CSV create from CL

[Martin Rowe <martin@xxxxxxxxxx>]

On Tue, 2004-10-19 at 21:09, Dan Bale wrote:
> Creating a .CSV file from an AS/400 file and importing that into an Access
> db table.  Trying to cut down on the number of manual steps needed to get
> from point A to point Z.
[snip]
> 
> Also, I tried CPYTOIMPF, and this works seemingly well, but this method does
> not trim trailing blanks from text fields, whereas the "Data Transfer From
> iSeries" method does.  I'm not sure if there are any implications of those
> differences when the data is imported into Access.  Anybody know?

Hi Dan

You could try the CRTCSVSTMF utility from my site. That creates .csv
files similar to CPYTOIMPF, but trims trailing blanks, plus allows some
extra formatting of fields within the file (changing date formats, etc).
Details and source code download from  http://www.dbg400.net/crtcsv.html

Regards, Martin
-- 
martin@xxxxxxxxxx  AIM/Gaim: DBG400dotNet  http://www.dbg400.net       /"\
DBG/400 - DataBase Generation utilities - AS/400 / iSeries Open        \ /
Source free test environment tools and others (file/spool/misc)         X 
[this space for hire]  ASCII Ribbon Campaign against HTML mail & news  / \