is it possible to delete a column of a table! if so how can i?

thanx

At least in DB2 for z/os there is no SQL-statement to drop a column from a table. You have to DROP and reCREATE it

Whether this works depends on your DB2 version and underlying platform.

It works on DB2 V9 for UNIX, Linux, Windows. If you don't have version 9, you have to drop the table and recreate it without the column. If that is not possible, the just ignore the column since DB2 (or Oracle) doesn't actually physically remove it from each row when you drop a column (at least until you do a reorg).

im using z/os so can't i even do it with the alter command?
i suppose i can create a new column with the alter though? isn't it?

ALTER TABLE (it's a SQL statement - not a command) on DB2 z/OS does not allow you to drop a column. Adding a column is supported, however.

Superfluous columns in a table are normally not a problem for DML access.
If it's important to "hide" a particular column, you may RENAME the original table and CREATE a VIEW with the old table name, referring the new table name, where that view has one column less than the table.

Hi,
is there SYSPROC.ALTOBJ system store procedure on DB2/zOS? This store procedure exist from v8 on LUW and can be helpful.
Hope this helps,
Grofaty