Re: [Bulk] Alter table Label on change File Level ID

Jack:

That should not affect the record format level ID, because that is based
only on the field types, lengths, decimal places, and the total # of
fields, and the record format name, AFAIK. In particular, anything like an
ALTER TABLE to add a new column, that would change the record length, would
also change the record format level ID.

If the record length is unchanged, and the number of fields and their
positions in the record buffer is unchanged, and field types and lengths
did not change, the record format level ID would not change, because
previously compiled programs would not be impacted by those changes...

To be absolutely certain, use CRTDUPOBJ on the file in question, with
DATA(*NO) to copy it to another library or QTEMP, and then issue the ALTER
TABLE against that copy of the database file, and verify that the record
format level ID has not changed, e.g. with DSPFFD.

HTH,

Mark S. Waterbury

On 5/22/2016 6:31 PM, Jack Tucky wrote:

I'd like to change a label on a column. The file was created many years
ago with DDS.

Will the file level check change? This is what I want to do.

label on column library/file (column text is 'new label')

Thanks, Jack

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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.