Re: Re[2]: SQL spool file

Eric,

My purpose was to offer an SQL based Query tool that would complement SQL
based STRSQL which is definitely not an end-user tool.

I can't stand here and defend QM as the ultimate tool (it is included with
the SQL Development kit so no additional cost for what you get) as I must
confess to using Operations Navigator, "Run SQL Scripts" more and more. The
data is presented in a tabular format and, as you probably know, you can
use SQL to change the column headings and to pretty up the individual
column values.

Going further, I have found using embedded SQL in RPG programs to be an
even better way to manage queries.

When I do use QM in my job (not often), I always use the SQL query creation
mode versus prompting. I find that the prompting mode is not as easy to use
once you are comfortable with SQL. If this is what you mean when you say
that the documentation  is "cryptic", you may be right based on what you
need to do.

If you care to give me a query that you'd like to spruce up, I'd be glad to
give it my best shot to see whether I could come up with something
acceptable to you using both QM and Ops. Nav.

Bob

Bob Slaney/Atlanta/IBM @ IBMUS (Lotus Notes)
VM id: WTSCPOK.RJSLANEY@VM
Internet id: rjslaney@us.ibm.com
Tieline 596-3022 Direct (770)835-3022
Fax tie 596-3912 Direct (770)835-3912

IBM Learning Services
AS/400 Course Materials Development
IBM Corp.
3100 Windy Hill Road
Atlanta, GA 30339
Internal Zip WE3A1

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