RE: Referential Integrity Constraints may enhance performance!

["Murphy, Mark" <MurphyM@xxxxxxxxxx>]

You're right, typo.  I don't use STRQRY much.

BTW, Squirrel has a button on it to store the result set in a table (which creates that table first).
I just tried it, somewhat flakey, you have to type the insert clause for some reason, but other than
that it works just as quickly as STRSQL, and you don't have to change your session to write to the
temporary file, and then back again.  It just generates (most of) the appropriate SQL, and you click
run.

Try it I bet you'll like it.

BTW, I found a PC replacement for STRQRY as well from JasperReports called iReport.  Also a JDBC
reporting tool.  Very slick, and uses SQL to define the dataset to report over like QMQRY.

http://jasperforge.org/jaspersoft/opensource/business_intelligence/ireport/

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Joe Pluta
Sent: Wednesday, April 02, 2008 3:47 PM
To: Midrange Systems Technical Discussion
Subject: Re: Referential Integrity Constraints may enhance performance!

Murphy, Mark wrote:
> Don't really need STRQRY now that I have found Squirrel.
>
> http://squirrel-sql.sourceforge.net/
>
> This plus the jtopen drivers works better than the STRSQL page for my money, and I can access all
> databases in the organization with it as long as they have a JDBC driver available.
>   
Nope, this is not STRSQL, this is STRQRY.  STRQRY is the way you create 
and use *QRYDFN objects, which make it very easy to create and maintain 
database queries.

STRSQL is part of the SQL Tools LPP, 5722ST1, and that hasn't changed.

And while I do love PC-based query tools, STRSQL is often faster and a 
lot easier to use for certain things, like to create temporary files.

Joe