On Jul 21, 12:46 am, DA Morgan <damor...@psoug.orgwrote:
Serge Rielau wrote:
rick wrote:
How can we add a column (alter) before certain column in DB2, just
like Informix has BEFORE OPTION
You cannot. Why would you want to do that?
Cheers
Serge
You're no fun Serge: Because they can do it in Informix of course. <g>
--
Daniel A. Morgan
University of Washington
damor...@x.washington.edu (replace x with u to respond)
Hi serge
We have policy that certian columns should be at the end of the table,
since db2 doesnt allow this we had to drop table and recreate table.
But any way since db2 doesnt allow BEFORE we had to fight with
management and change the policy.
thanks for the reply tho..can I know why db2 doesnt not support this
feature ??
Thanks
RIK