Solved

Downloading to an Excel using net.data

Posted on 2008-10-07
11
604 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
Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

 
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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Java performance on Solaris - Managing CPUs There are various resource controls in operating system which directly/indirectly influence the performance of application. one of the most important resource controls is "CPU".   In a multithreaded…
Windows 7 does not have the best desktop search built in. This is something Windows 7 users have struggled with. You type something in, and your search results don’t always match what you are looking for, or it doesn’t actually work at all. There ar…
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…
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.

827 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