Re: SQL vs. OS/400 queries



Bob,

Have you tried using QM queries as a replacement for Query/400.

I've found the prompted mode of QM to be close enough to Query/400 for
users to handle.

Charles



In article <c8ijlo$52ec$1@xxxxxxxxxxxxxxxxx>,
bobcomer_removeme_@xxxxxxxxxxxxxx says...
It doesn't seem quirky if you realize they designed the new engine for
SQL.

It sure does to me since the built in tools should use the best QM running.

IBM made the original engine work
for SQL, but this approach was not optimal at all times for SQL.

I have no problem with that statement, but there shouldn't have been a
reason to keep Query400 and opnqryf from using the new QM. Query400 is used
*extensively* out here and that's where we need performance enhancements.
Actually, I wouldn't mind a more powerful Query400, say one with an if
statement capability.

Now if some new UI (with an emphasis on USER) query tool were to come out to
replaces Query400 and does take advantage of the new QM, that would pretty
much render my argument moot, as I get what I want and you get what you
want...

- Bob Comer




.



Relevant Pages

  • Re: [Info-Ingres] FW: Ingres Development Sprint, June 2009.
    ... Merging RW and SQL ... ... there are loads of open source query tools out there. ... Every day I work with Ingres, Oracle, SQL Server, ... The query tool I use is DbVisualizer, made by Minq Software out of Stockholm. ...
    (comp.databases.ingres)
  • Re: General SQL/ODBC question
    ... Download WinSQL from http://www.synametrics.com/winsql. ... > I am trying to teach myself SQL programming on my home PC using Windows XP ... > a driver and a connection to a database here in order to use the Query Tool. ... I do not think I have the 'database' required. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Best Oracle front end / Query tool for power users
    ... visual query tool is good for novices and the SQL view provides more ... which is a problem for power users. ... Easy for novice user, but has advanced user features (ie - you can ... Brio/ Hyperion - This is probably my favorite query tool. ...
    (comp.databases.oracle.misc)
  • Crystal 10, Manually Changing, SQL Changes, Blank Report - bug?
    ... In Crystal 10, I have a report that runs well, but needs one more ... So I reloaded the original report that runs, and copied the SQL ... Crystal, and pasted it to my query tool, and it was broken. ... original SQL, and still broken. ...
    (microsoft.public.vb.crystal)

Loading