RE: Query and SQL

["Schenck, Don" <Don.Schenck@xxxxxx>]

Valerio --

IF you have Microsoft Access, you can view SQL for queries there. Nice and
easy, and the SQL moves relatively cleanly to UDB/400.

-- Don

-----Original Message-----
From: Valerio Vincenti [mailto:VVincenti@spotsylvania.va.us]
Sent: Wednesday, May 19, 1999 1:55 PM
To: MIDRANGE-L@midrange.com
Subject: Query and SQL


Hi everyone !

I'm looking for a way to display the SQL statement generated by a query or,
even better, to convert a Query definition to a Query Manager Query.

In my opinion the user interface for Query is a lot more user friendly than
the one for SQL, so I think this could be useful to learn more about SQL in
a 'by example' fashion (sort of what happened when we used the RPG to ILE
conversion program to see what ILE looked like).



Valerio Vincenti
Programmer/Analyst
County of Spotsylvania, I.S. Department
Spotsylvania, VA 22553
Phone (540) 582-7055 Ext. 233
Fax (540) 582-6304
e-mail: vvincenti@spotsylvania.va.us


+---
| 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
+---