How you add column in between a table?

[neeraja]

Hi,

Please let me "How to add column in between a table ? " kindly give a sample.

With regards,

Neeraja.

[DavidatK]

There really is no reason to add a new column in between two existing columns in DB2. You would have to unload the existing table. Delete it, re-define it with the new structure and reload the data.

When we add columns, we simply add to the end of the structure. The table does not have to be unloaded/reloaded. When you do the SELECT you declare the order you want to retrieve the columns.

Dave