MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Need Help setting up Auto Transfer Data from AS400

Posted by Wynn Snider on April 23, 2001 11:26 AM

I need to set up an automatic function on a
customer's desktop that will automatically do the
"Transfer Data from AS400" function. This will be
pulling the same file each month, the data will be
different. I can not use VB. I can set this up
on her desktop using Java or RPGLE. Could you
please help.

Wynn Snider
United Guaranty Corp.
230 N. Elm Street
Greensboro, NC

Posted by Bj on April 23, 2001 12:03 PM

We have Data Transfer with our company, rarely do I use it because of the
limitations on the number of records.
I would recommend that you set up an ODBC driver for you Data Base.
Use Microsoft Query. This will allow you to save the file as a template
and auto refresh upon opening the file.

A Non-VB answer to you question. You can goto Start, IBM AS400 Client Access,
Data Transfer from AS400. After you use this screen you should enter all the required
criteria. When you exit the Data Transfer screen it will ask if you want to save, answer yes.
Now, every time you double click on the data transfer it will allow you to transfer the same data
into a usable format without having to re-select any field criteria.

If you have Microsoft Query it really is a better route to go, I think.

Posted by Pete Wilshaw on April 24, 2001 4:27 AM

Also if you wish to automate it, once you have created your .dtf file in AS/400 Client Access, you can then call it from a batch file and use NT Schedule or something similar to kick it off at a predefined time.
(The command line executable for the Data Transfer is called RTOPCB.EXE located in the Client Access directory)