Page 1 of 1

download db2 V9 z/os to MS Excel

PostPosted: Mon Oct 17, 2011 8:29 pm
by p19689
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 ?

Re: download db2 V9 z/os to MS Excel

PostPosted: Mon Oct 17, 2011 11:23 pm
by dick scherrer
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.