Re: SQL order by question

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxx>]

DAsmussen@aol.com wrote:

> I too am a proponent of specifying the physical file in an SQL statement, but
> this can
> cause problems in tuning should you recompile a logical for performance and
> then have the aforementioned n logicals recompiled for a different reason.
> Programs that once ran well suddenly start dying, and nobody knows why because
> the guy/girl that recompiled the original logical for performance didn't
> document it adequately and has since taken that $30K signing bonus to work
> somewhere else.

Well, yes, but the program still runs.  If you point to a logical and it
goes
away, the program does *not* run.

The idea here is that logicals are used to tune performance, and not
create an
execution dependancy upon their existance.

--
===========================================================
R. Bruce Hoffman, Jr. -- IBM Certified AS/400 Administrator

-- The sum of all human knowledge is a fixed constant.
    It's the population that keeps growing!
begin:          vcard
fn:             R. Bruce Hoffman, Jr.
n:              ;R. Bruce Hoffman, Jr.
adr:            991 Lucon Road;;;Schwenksville;PA;19473;USA
email;internet: rbruceh@ibm.net
title:          Independant AS/400 Consultant
tel;work:       610-222-9707
tel;fax:        610-222-9717
x-mozilla-cpt:  ;0
x-mozilla-html: FALSE
version:        2.1
end:            vcard


begin:          vcard
fn:             R. Bruce Hoffman, Jr.
n:              ;R. Bruce Hoffman, Jr.
adr:            991 Lucon Road;;;Schwenksville;PA;19473;USA
email;internet: rbruceh@ibm.net
title:          Independant AS/400 Consultant
tel;work:       610-222-9707
tel;fax:        610-222-9717
x-mozilla-cpt:  ;0
x-mozilla-html: FALSE
version:        2.1
end:            vcard