Home > IT Answers > AS/400 > Moving data from iSeries to DB2 on Windows
Claudek7
5 pts.
 Moving data from iSeries to DB2 on Windows
AS/400 DB2, DB2, iSeries, SAVF, Windows DB2
I need to get data from a iSeries DB2 system to my Windows DB2 system. The DBA produced and sent me a savf file. How can I important that savf file into DB2?

Software/Hardware used:
ASKED: June 19, 2008  3:01 PM
UPDATED: June 20, 2008  3:00 PM
RELATED QUESTIONS
Answer Wiki:
Hi, I don't think that's going to work for you. The .savf is an iSeries "Save File" and is only restoreable on another iSeries. I suggest you ask the DBA to export the files to another format for you, maybe he can FTP them to a PC in ASCII format. Make sure you let him know you're not working with an iSeries. Most people will assume DB2 is either iSeries or Mainframe. Regards, Martin Gilbert.
Last Wiki Answer Submitted:  June 20, 2008  9:58 am  by  Gilly400   23,625 pts.
All Answer Wiki Contributors:  Gilly400   23,625 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Try a utility called VIEWSAVF, created by Julian Wong. You find it here :

You will have to pay for it, but it’s only 29 USD (about 15 GBP), paid throgh PayPal. If you don’t pay, you can only see the first 20 records in a file member.

I’ve just downloaded it and tried it out – it’s quite basic, but workable. It will copy a file member to a PC folder as text, Word or Excel format.

Please note that I am not advertising or recommending this software; I have no connection with the author, the product or the website.

Regards,

Sloopy

Sloopy
 2,195 pts.
 

Why did the link not appear in my previous post?

http://www.juliansoft.com/

:-~

Sloopy

Sloopy
 2,195 pts.