download db2 V9 z/os to MS Excel



IBM's flagship relational database management system

download db2 V9 z/os to MS Excel

Postby p19689 » Mon Oct 17, 2011 8:29 pm

Hi , what's the best of downloading data from Z/os to MS office products. Is it possible to do this without DB2 connect license just using some ODBC drivers please ?
p19689
 
Posts: 65
Joined: Fri Oct 01, 2010 1:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: download db2 V9 z/os to MS Excel

 

Re: download db2 V9 z/os to MS Excel

Postby dick scherrer » Mon Oct 17, 2011 11:23 pm

Hello,

One easy to do this is to create a "delimited" file on the mainframe (the TAB x'05' works well), us9ing the ftp client on the pc, pull this frmo the mainframe, and the import this into Excel on the pc.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to DB2