RE: Sorting

["Metz, Zak" <Zak_Metz@xxxxxx>]

If I were to use SQL, what is the most straightforward way to build the
SQL string and run it? Would that be embedded SQL with a prepare? If so,
I have no objection, or enlighten me of a better way?

Looks like either way I'm building a big string, whether it be SQL or an
OPNQRYF.

In regards to indexes, I really know nothing of how the file will need
to be sorted when it gets sorted, so I can't build any indexes ahead of
time.

Anyone know how the speed of an SQL or OPNQRYF solution will compare to
good 'ol FMTDTA?

Thanks to all!

> -----Original Message-----
> From: Chevalier, Rick
> 
> Why not use SQL?  It's lends itself to being built on the fly 
> and is less
> error prone than an OPNQRYF statement.  The performance would 
> be about the
> same I think.
NOTICE: This E-mail may contain confidential information. If you are not
the addressee or the intended recipient please do not read this E-mail
and please immediately delete this e-mail message and any attachments
from your workstation or network mail system. If you are the addressee
or the intended recipient and you save or print a copy of this E-mail,
please place it in an appropriate file, depending on whether
confidential information is contained in the message.