[Cialug] [OT] DB2

[david.stout at marshallnet.com]

Thank you for your post Tim. I just thought there was an easer way. 
Like the Alter table statment.
Thanks again.

David Stout
Data Repository & Reports


Tim Wilson <tim_linux at wilson-home.com> wrote:
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 
wrote:
> You are correct. That is the way we have to do it as well. I figured I would
> use a temp table.
>
>
> Claus 
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
_______________________________________________
Cialug mailing list
Cialug at cialug.org
http://cialug.org/mailman/listinfo/cialug