• Subject: Re: CHGPF Question
  • From: DAsmussen@xxxxxxx
  • Date: Fri, 19 Sep 1997 01:04:28 -0400 (EDT)

Art,

In a message dated 97-09-19 00:22:18 EDT, you write:

> > > My quick answer: No Don't.
>  > > Database changes should always be done with deliberate care.
>  
>  During the UPS strike, a customer of mine called Monday morning that he
>  had just landed a major account.  He needed some software changes
>  immediately.  One of the changes required adding a field to a file.
>  Should I tell the customer that changes to the database require more
>  care than that, turn down the business?  No.  It has to be done.  Just
>  do it (That's a great slogan, someone should use that)
>  
>  Got to go with LVLCHK(*NO).  Remember to compile all programs that add
>  or update that file.  It'll work smooth.
>  
>  Art (seat of my pants) Tostaine, Jr.

Those pants must be awfully tight!  ARE YOU NUTS????!!!!  How does CHGPF
alter this over just adding the field and compiling the file (other than
making sure you save the data)?  How does the speed difference between
compiling the file and using CHGPF make or break taking the customer's
business?  How much MONEY is the customer going to lose because YOU missed a
program that added to or updated the file?  THAT's what LVLCHK is FOR!!!

If you already know what programs add/update the file, why DON'T you know
which ones access it at all (HINT:  DSPPGMREF to an outfile)?  If you know
both, what the heck is the big deal with re-compiling them ALL?  Yes database
changes require careful consideration, but simply adding a field is NOT
rocket science!

I disagree VEHEMENTLY with using LVLCHK(*NO) under ANY circumstances.  I'll
make the same challenge that I did with GOTO -- show me a SINGLE example
under which it would be valid, and I'll admit my mistake (haven't gotten one
in almost a year on GOTO yet, but you're welcome to try with LVLCHK).
 Otherwise, I've still got a couple of customers with S/34's in their
warehouse that they're trying to get rid of -- ITS database should suit you
just fine...IF you can afford the electricity to run it :-).

JMHO,

Dean Asmussen
Enterprise Systems Consulting, Inc.
Fuquay-Varina, NC  USA
E-Mail:  DAsmussen@AOL.COM

"BPCS -- Better Programs Coming Soon."
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator: david@midrange.com
+---


This thread ...

Follow-Ups:

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].