download db2 V9 z/os to MS Excel
Previous topic • Next topic • 2 posts
• Page 1 of 1
download db2 V9 z/os to MS Excel
by 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
by 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.
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.
d.sch.
-
dick scherrer - Global moderator
- Posts: 6268
- Joined: Sat Jun 09, 2007 8:58 am
- Has thanked: 3 times
- Been thanked: 93 times
Previous topic • Next topic • 2 posts
• Page 1 of 1
-
- Related topics
- Replies
- Views
- Last post
-
- Download table with comp-3 fields
by makdiver » Wed Feb 24, 2021 9:38 pm - 5 Replies
- 1880 Views
- Last post by sergeyken
Thu Feb 25, 2021 8:19 pm
- Download table with comp-3 fields