Re: Deploying DB2 Table Changes

[Richard Schoen <richard@xxxxxxxxxxxxxxxxx>]

Cool. 

Are there any obvious instances to be aware of where ALTER TABLE might fail ?

Regards,
Richard Schoen
Web: http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx

----------------------------------------------------------------------

message: 1
date: Sun, 28 Nov 2021 21:23:14 -0300
from: Raul Alberto Jager Weiler <raul.jager@xxxxxxxxx>
subject: Re: Deploying DB2 Table Changes

You can add a column in any place using ALTER TABLE, the option is "BEFORE fieldname"


On Wed, Nov 24, 2021 at 3:23 PM Vern Hamberg via MIDRANGE-L < midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

> Hi Richard
>
> At least since V5R2, the CHGPF command lets you specify a source 
> member that has the changes, the data will be copied, changes made, 
> then data copied back - at least, that's the effect.
>
> If DDL with SQL, ALTER TABLE gives some options - deleting, changing, 
> and adding columns can be done - adding has to be at the end, IIRC.
>
> Cheers
> Vern
>
> On 11/24/2021 8:37 AM, Alan Shore via MIDRANGE-L wrote:
> > Hi Richard
> > The answer to your question is tape recording number 26 It depends 
> > First - what release are you on? If you are on an extremely old
> (decades) release, you may have no choice
> > What change are you doing?
> > Adding one or more new fields?
> > Changing an existing field - if so - from what to what