Re: DDL table add key column?

[Justin Taylor <jtaylor.0ab@xxxxxxxxx>]

Thank you


date: Fri, 27 Aug 2021 07:19:51 +0200
> from: "Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>
> subject: RE: DDL table add key column?
>
> SQL tables do not include keys ... unique keys on an SQL Table are
> implemented over a primary key constraint or over an additional unique key
> index.
> Since you are not changing any columns and not adding or removing any
> columns, adding a key column will not affect any RPG program, even if the
> table is not defined with level check *NO.
>
> In either way I'd change the table to level check *YES, check the RPG
> programs and recompile them.
>
> Mit freundlichen Gr??en / Best regards
>
> Birgitta Hauser
>
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> Brown)
> "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and losing them? Not training them
> and keeping them!"
> ?Train people well enough so they can leave, treat them well enough so they
> don't want to.? (Richard Branson)