Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Download data from Mainframe DB2 table

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
noorkh

New User


Joined: 06 Mar 2006
Posts: 76
Location: Chennai

PostPosted: Mon May 14, 2007 7:50 pm    Post subject: Download data from Mainframe DB2 table
Reply with quote

Do we have any tool to download data from Mainframe DB2 table to a spreadsheet? If any freeware is there please pass me link.

Noor.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue May 15, 2007 2:20 am    Post subject:
Reply with quote

Hello,

Other than ftp no software 'tool' is needed.

From the db2 table, create a delimited file on the mainframe making sure that all fields are in the output file are "displayable" - there should be no packed-decimal (comp-3) or binary (comp) fields in the output.

When the file is ftp'd (pushed or pulled) to the win-based system, it will go directly into a spreadsheet, database, etc.
Back to top
View user's profile Send private message
noorkh

New User


Joined: 06 Mar 2006
Posts: 76
Location: Chennai

PostPosted: Tue May 15, 2007 9:57 am    Post subject:
Reply with quote

Hi Dick,

I agree with your point. But all of my tables are containing COMP-3 fields or binary. So i might need to write program to make it displayable first and then need to ftp it to excel.

I can do it if there are 1 or 2 tables to be downloaded, what if i need to download more than 25 tables. For all the 25 tables, writing delimited programs will become little vague work.

I heard from my colleagues that there are some tools available in market which gives u direct download to excel. And it even displays COMP-3 values.

They are not aware of the tool names. Can you suggest me if you have any idea of that.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue May 15, 2007 7:43 pm    Post subject:
Reply with quote

Hello,

I'm not positive, but i believe that the DB2 UNLOAD will create a delimited file.

My preference has been to use COBOL - almost every database table, vsam file, and major flat file has a copybook. It is trivial to take a simple sleketon bit of code, use the copybook, and STRING the desired fields interspersed with the delimiter-character into an output area and write. The advantage of COBOL is that when something other than a "dumb dump" of the data is needed, code may be easily added (quite often data to be downloaded is de-normalized for ease of use in a spreadsheet or data warehouse) and data from additional tables may be incorporated into the data being sent to a win-based product.

In your case 25 may sound like many pieces of work. In the past several months, i've created, transferred, and loaded several hundred different formats of data. This is between mainframe, unix, and win-based systems.

As far as 3rd-party software, i know of no free mainframe tools and (so far) no tools for purchase that do all or even most of what is needed when transferring data to/from the mainframe. Several vendors have tools that work quite well between SQLServer and Oracle etc - some even do some DB2 (that will grow). From my experience, the tools are just not there yet but there is growing requirement.
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4650
Location: Raleigh, NC, USA

PostPosted: Tue May 15, 2007 8:17 pm    Post subject: Re: Download data from Mainframe DB2 table
Reply with quote

I seem to recall that most of the popular data mapping/transformation products had this capability - Gentran, Mercator, Cloverleaf. I'm sure there are others as well.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Identifying Interfaces in CICS/mainframe Ashishpanpaliya CICS 5 Fri Oct 13, 2017 3:21 pm
No new posts Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Copy 4 byte of data from the last rec... arunsoods DFSORT/ICETOOL 9 Fri Oct 06, 2017 12:15 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts opening a dataset after reading it fr... arunsoods DFSORT/ICETOOL 5 Wed Oct 04, 2017 3:54 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us