IBM Mainframe Forum

Hi
i have a requirement. I have 5 columns in a Table.
like
C1 C2 C3 C4 C5
i want to insert a new column in between C2 and C3 how do it .What could be the query>
Please give me some suggestion.


Thanks in Advance.

Hello,

Change the CREATE TABLE, but there is probably no reason to do so. . .

Why do you care that this new column be defined between c2 and c3? When columns are used in a query, there is no necessary placement.