Solved

Downloading to an Excel using net.data

Posted on 2008-10-07
11
606 Views
Last Modified: 2013-11-14
Hello Gurus,

Can someone let me know how to download to an excel using net.data in IBM Mainframe. We are using net.data 6.0

Regards.
Hari.
0
Comment
Question by:rharivenkatesh
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 3
11 Comments
 

Author Comment

by:rharivenkatesh
ID: 22665767
Hello All,

Any updates on this downloading to Excel using net.data?

Regards.
Hari.
0
 
LVL 62

Expert Comment

by:gheist
ID: 22667340
What version od UNIX you are using (uname -a)
0
 
LVL 57

Expert Comment

by:giltjr
ID: 22685831
How is the Excel file getting to the mainframe?  Is it being created on a PC and then uploaded?  Or are you trying to create an Excel file on the mainframe??

What OS are you running on the mainframe?

Do you have a ftp server running on the mainframe?

0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 62

Expert Comment

by:gheist
ID: 22695247
net.data is ODBC cleint application just like Microsoft Excel.

if you have selected "Microsssssssoft Query" when installing excel you have option to import SQL data using ODBC.
0
 

Author Comment

by:rharivenkatesh
ID: 22696597
Can we do that Query for Mainframe to Microsoft. This is basically downloading data to Excel from IBM Mainframe using net.data.

Regards.
Hari.
0
 
LVL 62

Expert Comment

by:gheist
ID: 22696769
net.data is high level application like excel.
you have to use same ODBC setting to connect to same mainframe net.data v6.0 connects
0
 
LVL 57

Expert Comment

by:giltjr
ID: 22698691
How is the data stored on the mainframe?

Using ODBC would only work if the data is in DBMS on the mainframe and you have the required drivers.

Again, what OS is running on the mainframe.

Another question is how is the data stored on the mainframe?  DB2, IDMS, flat file, VSAM or something else?
0
 
LVL 62

Expert Comment

by:gheist
ID: 22699057
http://www-01.ibm.com/software/data/net.data/

Sad - dinosaurs died before ice age...

WebSphere is different world - JDBC, java etc.
0
 
LVL 57

Accepted Solution

by:
giltjr earned 500 total points
ID: 22701503
gheist --> I forgot about that product.  I was thinking of a .net stuff.

rharivenkatesh -->

Here is an write up on how to generate documents in various formats using net.data:

     http://www.ibmsystemsmag.com/i5/february01/tipstechniques/8753p1.aspx

It deals with iSeries servers, but it should work the same interacting with z/OS.
0
 
LVL 62

Expert Comment

by:gheist
ID: 22703582
So you think about ADO.NET  or something like that? Excel does not use that.
It actually uses ODBC down below. Some drivers do export ADO apis, rest can bridge thru ODBC.

0
 

Author Closing Comment

by:rharivenkatesh
ID: 31503790
Partial
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I promised to write further about my project, and here I am.  First, I needed to setup the Primary Server.  You can read how in this article: Setup FreeBSD Server with full HDD encryption (http://www.experts-exchange.com/OS/Unix/BSD/FreeBSD/A_3660-S…
Using libpcap/Jpcap to capture and send packets on Solaris version (10/11) Library used: 1.      Libpcap (http://www.tcpdump.org) Version 1.2 2.      Jpcap(http://netresearch.ics.uci.edu/kfujii/Jpcap/doc/index.html) Version 0.6 Prerequisite: 1.      GCC …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question