MVSFORUMS.com

NASCAR9 · Posted: Tue Jan 11, 2005 12:54 pm Post subject: DB2 Drop Column

I've already searched, came up empty. Can a column be altered/dropped from a table?

NASCAR9 · Posted: Tue Jan 11, 2005 1:00 pm Post subject:

I found this: It is not possible to rearrange or delete columns in a table without dropping the entire table. You can, however, create a view on the table, which includes only the columns you want, in the order you want. This has the same effect as redefining the table.
I hope this is not true.
_________________
Thanks,
NASCAR9

kolusu · Posted: Tue Jan 11, 2005 4:11 pm Post subject:

NASCAR9,

Renjitji · Beginner Joined: 01 Feb 2005 Posts: 2 Topics: 0

Hope columns can be dropped from tables in subsequent versions. Oracle had a similar siutation but now after version 8 they have 2 ways of dropping columns and can alter(increase) the length of columns.

It would be better if the people posting could mention the version or platform they are working on.

Thank you

Renjith

NASCAR9 · Posted: Wed Feb 02, 2005 10:42 am Post subject:

Renjitji, zOS/390 V 7.2 DB2, migrating to 8.X