What are you trying to change.
There are limitations. The text below is from the manual and this is what
DB2 says you can alter.
Adding one or more columns to a table

Adding or dropping a primary key

Adding or dropping one or more unique or referential constraints

Adding or dropping one or more check constraint definitions

Adding or dropping a drop table restriction

Altering the length of a VARCHAR column

Altering a reference type column to add a scope

Altering the generation expression of a generated column

Altering one or more check or referential constraints attributes

Adding or dropping a partitioning key

Changing table attributes such as the data capture option, pctfree, lock
size,

or append mode.

Setting the table to not logged initially state.

Regards

-Bimal

----- Original Message -----
From: "Stephane Paquette "
<db2udbdba-ezmlmshield-x30238958.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, October 28, 2004 12:18 PM
Subject: Altering tables


> 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]
>
>
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>


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