RE: when to use a function or file for information

We have this issue all the time. What I am working towards is a single development file lib that is identical to production. Now programmer put changed files into their own work library and all the objects they are changing. Their development library is ahead of the general development library until they are ready to install. Then they install to the general Development library and test. From there they promote to production or QA depending on the scope of the project.

Chris Bipes
Director of Information Services
CrossCheck, Inc.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jonathan Mason
Sent: Tuesday, March 23, 2010 8:01 AM
To: Midrange Systems Technical Discussion
Subject: Re: when to use a function or file for information

Hi David

Surely if the value could be identified by referring to the CustomerType
then you wouldn't need the extra field anyway.

Really what it comes down to is basic change control for your system.
Anybody making a modification to a file should be running some kind of
impact analysis to identify which other objects (programs, queries, etc
) make use of the file so any changes or recompilations could be
actioned.

There are many change management tools out there and I'm sure if you
asked our host, Mr Gibbs, he could recommend a very good one that we
also use.