[Cialug] [OT] DB2

[Tim Wilson]

Like I said in my post: drop any constraints, rename the table, create
a new version with the new column(s), copy the data over from the old,
then drop the old table.  Same amount of steps (fewer if there aren't
any constraints), but only one create, and only one loading of data. 
Should run faster too.

On 9/21/05, David Stout <address removed by user> wrote:
> You are correct. That is the way we have to do it as well. I figured I would
> use a temp table.
>
>
> Claus <address removed by user> wrote:
> At my work the DB2 gurus require us to drop/create a table in order to
> remove a column. Not sure if it's due to a technical or political
> reason. But in either case it's quite simple to do so. Of course you
> have unload the data before the drop and to reformat the data before
> loading.
>
> Claus
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug
>
>
> David Stout
> BTS Billing Team
> Data Repository & Reports
>
>  ________________________________
> Yahoo! for Good
>  Click here to donate to the Hurricane Katrina relief effort.
>
>
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug
>
>
>


--
Tim