Re: Betterment of AS/400 - Query/400

Simon,

At 06:00 PM 2/26/99 +0000, you wrote:
>All this Query/400 wish-list stuff. None of this will never happen. Why?
>Because *all* of this stuff is already available in SQL/400.

 That is not accurate.  They are 2 distinct products (w/ some overlap).
Neither is a substitute for the other.  

 SQL/400 output formatting stinks.  The prompter is also the pits.  It
requires far too much knowledge of SQL syntax and barely helps you out.  It
also doesn't doesn't make it easy to run in batch.  It doesn't allow
totaling on a function (i.e. getting a final total of SUM( AMT ) ) or
assigning work variables.  I can go on and on.  IMHO, SQL/400 will never
get those features because IBM tends to stick (close) to the ANSI standard
for SQL. 

 On the flip side, Query/400 doesn't allow updating / deleting records.

>Ever since I can remember, IBM has been shoveling new features into SQL.
>*None* of them have made it into Query/400. In fact, over the last eight
>years or so, I can't think of a single new Query/400 feature.

 I think that this is pathetic.

>All I can do is recommend is that you buy SQL/400, and take the time to
>learn it. The prompting is rubbish, but with a DSPFFD by your side, you can
>do stuff that Query can't even dream of.

 And vice-versa (see above.)

 -mark

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---