Re: automate .CSV create from CL

[Evan Harris <spanner@xxxxxxxxxx>]

Hi Dan

Is there any reason you couldn't do something like recreate the access 
table on the as/400 and set up a link via ODBC instead ?
This ought to allow you to avoid having the CPYTOIMPF and download 
etc.  Whenever the Access application was accessed it would be with 
whatever data was already there and you could probably tie in a form or 
button to update the database on demand with little additional effort.

Alternatively, if it must live there (and it would be interesting to hear 
the reasons for this if so) perhaps you could try:
- writing the file out to the QNTC directory after converting it
- writing the file out to a folder shared via netserver which the access 
database has access to

Regards
Evan Harris

At 09:09 a.m. 20/10/2004, you 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.
>
> Currently, the CSV creation is done via "Data Transfer From iSeries".  We
> have .dtf files defined and double-click these to invoke the file transfer
> app.  If these .dtf files were on the IFS, how could these be run from a CL
> program?  (My memory is quirky today and an archive search turned up no hits
> or 2,000,000 hits.)  Links would be greatly appreciated.
>
> 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?
>
> Finally, this may be a PCTECH question, and I will ask there as well, but
> since it is related to this...  Is there an easy and reliable way for a CL
> program to invoke the steps that import the CSV into a specific Access
> table?  It would have to replace the existing data in the table.
>
> tia,
> db