RE: Betterment of AS/400 - Query/400

[Dan Thomas <DThomas@xxxxxxxxxxx>]

Thanks for the offer (questions about SQL/400).  
1) Is there a way, using prompted queries to do a summary query, meaning do
not display each record but rather summary totals only?  
2) Is there a way in report forms to make the default for indenting
something other than 2 spaces?
3) Is there a way in prompted queries to do an outer join?  If not, once
you've done the convert to SQL command, what exactly is involved in
converting to outer join (I've read the manual but still cannot get it to
work).

> -----Original Message-----
> From: Simon Brunning [SMTP:simon@brunncon.freeserve.co.uk]
> Sent: Friday, February 26, 1999 1:00 PM
> To:   MIDRANGE-L@midrange.com
> Subject:      Re: Betterment of AS/400 - Query/400
> 
> 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.
> 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.
> 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.
> If anyone has any SQL questions, I'll be happy to try and help.
> 
> Hold fast,
> Simon Brunning.
> 
> eMail: simon@brunncon.freeserve.co.uk
> Phone: 07050 042338
> +---
> | 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
> +---
+---
| 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
+---