Solved

Downloading to an Excel using net.data

Posted on 2008-10-07
11
603 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
  • 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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

In a recent article here at Experts Exchange (http://www.experts-exchange.com/articles/18880/PaperPort-14-in-Windows-10-A-First-Look.html), I discussed my nine-month sandbox testing of the Windows 10 Technical Preview, specifically with respect to r…
Windows 10 is here and for most admins this means frustration and challenges getting that first working Windows 10 image. As in my previous sysprep articles, I've put together a simple help guide to get you through this process. The aim is to achiev…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

810 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