[Cialug] [OT] DB2

[David Stout]

You are correct. That is the way we have to do it as well. I figured I would use a temp table.

Claus <cniesen at gmx.net> 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. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://cialug.org/pipermail/cialug/attachments/20050921/16ffa011/attachment.htm