Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 4649
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 copying data without knowing location arunsoods DFSORT/ICETOOL 6 Thu Jul 20, 2017 1:03 pm
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Mainframe Opening in Chennai ( 2 to 4... muralikrishnan_new Mainframe Jobs 0 Tue Jul 18, 2017 2:20 pm
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us