Re: GUI alternative to IBM Query

Another option with Excel ( any version) is to use the "Get External
Data" feature to point to a URL. This means you can turn off ODBC/JDBC
access entirely, and simply provide a different URL to each dataset
folks might need.   I did this at my last office, and it worked very
well.  Although older versions of Excel ( such as Excel 97 ) do not
deal well with large data sets using HTTPS.     I even automated the
setup for folks not well-versed in Excel by creating an IQY file and
hyperlinking to it from a webpage.  If you want to test this out, try
this hyperlink:
http://www.poger.net/utils/sample1.iqy

If you have Excel 2000 or better, the file should open into Excel
automatcally. With Excel 97, you have to manually import the file
after downloading it.

-Sarah


On 8/2/06, lgoodbar@xxxxxxxxxxxxxx <lgoodbar@xxxxxxxxxxxxxx> wrote:

I just tried with Excel 2003: Data, Get External Data, only references
tables, not stored procedures.

Loyd Goodbar
Senior programmer/analyst
BorgWarner
E/TS Water Valley
662-473-5713

-----Original Message-----
From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx]
Sent: Wednesday, August 02, 2006 15:33
To: Midrange Systems Technical Discussion
Subject: RE: GUI alternative to IBM Query

I don't recall a response to my question if called programs, stored
procedures, and the like are usable by PC based GUI tools.  I thought they
mainly "give me the file(s) to query" kinds of setup.

Rob Berendt

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.