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: 4648
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 Replace values in the input data Vikas Maharnawar DFSORT/ICETOOL 10 Thu May 11, 2017 2:18 pm
No new posts Group Data based on a key Arun Raj DFSORT/ICETOOL 7 Thu Apr 27, 2017 11:29 pm
No new posts SNMP trap from Mainframe bipinpeter Compuware & Other Tools 6 Wed Apr 26, 2017 3:05 pm
No new posts unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm
No new posts SORT JSON type of data maxsubrat DFSORT/ICETOOL 8 Wed Apr 19, 2017 6:01 pm


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