Try using the STRPCO and STRPCCMD in your CL.
the STRPCCMD would call a batch file on the PC to change to the right
directory and use the RTOPCB or RFROMPCB pc commands.
----------------------------
Bryan Dietz
Aktion Associates
midrange-l-bounces@xxxxxxxxxxxx wrote on 10/19/2004 04:09:16 PM:
> 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
>
