• Subject: Re: SQL order by question
  • From: "R. Bruce Hoffman, Jr." <rbruceh@xxxxxxx>
  • Date: Fri, 22 Jan 1999 09:19:41 -0500

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


This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].