Data Transfer/400 Setup Instructions - Initial Release

From Support

These installation instructions are current as of 6/14/2002

1.) The Data Transfer/400 software can be downloaded from the following links:

AS/400 Library
http://www.rjssoftware.com/files/rjstran.exe 
Password: TRANSFER400

PC Software

VB 5 Runtime Files

http://www.rjssoftware.com/files/vb5run.exe 
** No Password **

Data Transfer/400

http://www.rjssoftware.com/files/rjstran400.exe   
Password: TRANSFER400

2.) Installing AS/400 library - RJSTRAN

- First install the RJSTRAN AS/400 library by running the rjstran.exe file and uploading via our automated FTP utlility which will automatically launch after running the rjstran.exe.

3.) Enter the AS/400 access code from RJS by typing the following AS/400 command and pressing F4: RJSTRAN/PRDSEC

Enter the access code provided by RJS and enter RJSTRAN for both the library and data area name.

4.) Making sure the AS/400 DDM database service is running.

From the AS/400, run the following command: STRTCPSVR *DDM

If the DDM service is already running, the command will be ignored without problem.

5.) On each user PC, you must install both vb5run.exe and rjstran400.exe

6.) Configuring an AS/400 connection for user PC

- From the windows desktop select "Start/Programs/Data Transfer400" and then select "Configure AS/400 connection".

- Add a new entry and enter your AS/400 system name and IP address. User ID and password are not needed. The user ID will be entered at runtime.

7.) Using the Data Transfer/400 download software from user PC

- From the windows desktop select "Start/Programs/Data Transfer400" and then select "Data Transfer Download".

-Enter a SQL select statement to select records from the desired table.

   Example: SELECT * FROM QIWS/QCUSTCDT

This example selects all records from file QCUSTCDT in library QIWS.

- Enter a valid AS/400 user ID and password. 

- Enter an output PC file name

- Select the PC file output type (CSV, Excel 97/2000, Dbase or MS Access). 

Click the "Run Download" button to download the selected file.

**Note: MS Excel format should allow up to 65000 records per spreadsheet. In older versions of Excel only 16000 records wre allowed in a MS Excel table.

Since this is the initial release of the product, we're looking for enhancement suggestions.

Current items on the list are:

- Allow file and field selection on SQL select field.

- Allow table addition to an existing MS Access or Excel spreadsheet.

- Allow transfer setting to be saved and run as command line jobs.

- Allow log to be saved after each transfer so success/failure results can be stored for review.

- Allow user application to auto launch the downloaded file after transfer.

- Upload capability (3rd or 4th Qtr 2002)