RE: embedded SQL versus Query

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

OPNQRYF is also always going to be executed using the older CQE - it 
will not "benefit" from the newer techniques used in the SQE. But 
mileage varies in all this.

At 11:30 AM 12/21/2005, you wrote:

>         First thought right off would be the limitations of the query400
> program.  You can do more in embedded SQL.  Query400 also requires huge
> overhead if it's run interactively and so would be slower.  Query400 is a
> great tool for programmers that don't know SQL to get a view of how say a
> record selection over a particular table would look with a limited amount of
> coding.  Personally, if available, I will us SQL (embedded or not) or OP
> NQRYF if it's for a program.
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Douglas W. Palme
> Sent: Wednesday, December 21, 2005 11:05 AM
> To: Mid Range List
> Subject: embedded SQL versus Query
>
> Are there any performance issues to consider when looking at embedded SQL
> versus Query400?
>
> It seems that Query400 might actually run faster, but I can definitely see
> the advantages of creating an SQL statement on the fly per se.
>
> Thoughts, comments? Tell me I'm nuts....ok skip the last one, that's a
> given.
>
>
> If you bought it, it was hauled by a truck - somewhere, sometime.
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.