STRPDM.COM                  

   Home    |    IBM Manuals Direct    |    iBytes Library   |    Links    |   About     |   Book Store   |  On-Line Code

 

iByte

Subject – Data Migration

Data Migration using AS/400 folders and documents

One way to migrate data between the AS/400 and your PC is with AS/400 folders and documents.

After initial setup it’s a handy way to transfer data.

Step 1 – Confirm you have access to QDLS from your PC.

On your PC open "Network Neighborhood" or "My Network Places"
Check to see if your AS/400 is listed. If so continue, if not you’re out of luck.
Select your AS/400 and look for the QDLS folder. If it’s listed you’re set, if not you’re out of luck.

Step 2 - Create a folder on the AS/400

Enter the PC file section of the AS/400 by entering WRKFLR on the AS/400 command line.
Enter 1 to create a new folder, followed by the folder name.
Exit the PC file section.
You’re ready to transfer data!

Step 3 – To move data from the AS/400 to the PC.

From the AS/400 command line issue the CPYTOPCD command and prompt it.
Enter the required information.
Enter the folder name you created in Step 2.
The document name can be anything you want.
I usually enter a document name with a .txt so the PC will know how to open it. You could also just rename the document from the PC.
If you entered everything correctly and did not get an error. You’ll now have a text file in your new folder on the AS/400.
Now just open QDLS again on your PC and drag/drop the document anywhere you like.

 

Step 4 – To move data from the PC to the AS/400.

Open the QDLS folder as described in Step 1.
Drag and drop the file(s) into the folder you created in Step 2.
Decide where your data is to go on the AS/400. Create a flat file if needed.
From the AS/400 command line issue the CPYFRMPCD command and prompt it.
Enter the required data.
If you entered everything correctly and did not get an error. You’ll now have the data in an AS/400 file.

Step 5 – Suggestions

Map QDLS as a drive for super fast access.
This is also a fast way to move source code between the AS/400 and your PC.