Hi,

I want to change the structure of some tables. (DB2 UDB 8.1 fp3 on aix 5.2)
There is no synthax to do it in SQL. (dropping and renaming columns)

So what are the steps ?
I assume that I can extract data in a flat file
Drop and recreate the tables
Reload data

Am I right ?




Stéphane Paquette<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />


Administrateur de bases de données

Database Administrator

Standard Life

www.standardlife.ca

Tél. (514) 499-7999 poste 7470 stephane.[Email address protected]



DB2 & UDB email list listserv db2-l LazyDBA home page