RE: [EXTERNAL] Re: Expanding a field in a file or adding a new field to the file

Thanks for the reply Vernon
We have Implementer - but there is still a need to analyze everything

Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
‘If you're going through hell, keep going.’
Winston Churchill


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Vernon Hamberg
Sent: Wednesday, July 31, 2019 12:00 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: [EXTERNAL] Re: Expanding a field in a file or adding a new field to the file

By "this" I meant option 1.

Oy! Too early here!

Vern

On 7/31/2019 10:56 AM, Vernon Hamberg wrote:

I think I would go with this - especially if you have change
management software such as Implementer, Turnover, Aldon, or Midrange
Dynamics or -- there are some others.

Those will take care of the dependencies and pull any affected
programs into the build.

HTH
Vern

On 7/31/2019 8:10 AM, Rob Berendt wrote:

I think either/or would work.  Since you plan on recompiling all
programs anyway.

I guess I would expand the existing column.  Why waste the space in
the table by leaving the old column in there and add a new column?
I've worked with a major ERP package which expanded many of their
columns.  Even columns like the key to the item master.

You could make the new column variable length and use the ALLOCATE to
accommodate the "usual" size.  This way if you change the size again
(encryption, etc) you are covered.

Rob Berendt

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com