Downloading to an Excel using net.data

Hello All,

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

Regards.
Hari.

What version od UNIX you are using (uname -a)

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?

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.

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

Regards.
Hari.

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

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?

http://www-01.ibm.com/software/data/net.data/

Sad - dinosaurs died before ice age...

WebSphere is different world - JDBC, java etc.

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.

Partial