If the new fields are defined with a default value, writes from a program that does not reference the fields will automagically put the default value into the new records. Will not affect updates.
Chris Bipes
Director of Information Services
CrossCheck, Inc.
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Justin Taylor
Sent: Friday, January 29, 2021 10:31 AM
To: MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: LVLCHK(*NO)
In my experience, existing read-only programs are unaffected. Existing programs that use RLA to do inserts/updates can fail, usually when a new numeric column is added. Since the program I/O buffer doesn't know about those new columns, it can't ensure valid data per the column data type.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
