Data from iseries to PC
Last Post 19 Feb 2013 07:36 AM by dexum. 7 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
imrkhan
New Member
New Member
Posts:11

--
15 Feb 2013 06:42 AM

We migrating from As400 to some other system so I have to transfer data from physical file to tab limited file on PC using IBM client access Data transfer from iSeries tool. Please help me how to do it?


Thanks In advance..


dexum
Veteran Member
Veteran Member
Posts:1158
Avatar

--
15 Feb 2013 07:42 AM

Imrkhan

Welcome.

Did you try Google. There are numerous hits of information on this.

http://lmgtfy.com/?q=Data+transfer+...oolhttp://

Danny Exum Model 515 OS Level 6.1
dexum
Veteran Member
Veteran Member
Posts:1158
Avatar

--
15 Feb 2013 07:49 AM
Crazy forum software added a http:// to link and when I edit the link it looks good but still adds the http:// to end.
Danny Exum Model 515 OS Level 6.1
imrkhan
New Member
New Member
Posts:11

--
15 Feb 2013 07:51 AM
Thanks Dexum

But I was not able to transfer my data into Tab delimited file. I was able to export the pf as a normal text file only.
Tommy Holden
Senior Member
Senior Member
Posts:2833
Avatar

--
15 Feb 2013 08:57 AM
why use the data transfer? just use CPYTOIMPF and use FLDDLM(*TAB) and either copy it to the IFS then drag & drop them onto your PC or server? then all you have left is to do the import into your new database. or alternatively just create an ODBC connection to the system and import directly into the new database using the ODBC driver?
dexum
Veteran Member
Veteran Member
Posts:1158
Avatar

--
15 Feb 2013 09:15 AM

On the Data Transfer screen ,

Click Output Device and choose File.

Click Details.

Choose Tab Delimited Text.

Run download.

 

Hope this helps.

Danny Exum Model 515 OS Level 6.1
imrkhan
New Member
New Member
Posts:11

--
18 Feb 2013 08:04 AM
Thanks Dexum

But I am able to pull only 11089 records only.
dexum
Veteran Member
Veteran Member
Posts:1158
Avatar

--
19 Feb 2013 07:36 AM

Did you try Tommys suggestion?

Or maybe use Excel with ODBC and save as Tab Text file?

Danny Exum Model 515 OS Level 6.1
You are not authorized to post a reply.

Acceptable Use Policy