Re: GUI alternative to IBM Query

["Sarah Poger Gladstone" <listmember@xxxxxxxxxxxxxx>]

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.