BEFORE OPTION
Question posted by: rick
(Guest)
on
July 20th, 2007 09:35 PM
Hi
How can we add a column (alter) before certain column in DB2, just
like Informix has BEFORE OPTION
tHaNks
Rick
5
Answers Posted
rick wrote:
Quote:
Originally Posted by
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
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Serge Rielau wrote:
Quote:
Originally Posted by
rick wrote:
Quote:
Originally Posted by
>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
Join Bytes! (replace x with u to respond)
DA Morgan wrote:
Quote:
Originally Posted by
Serge Rielau wrote:
Quote:
Originally Posted by
>rick wrote:
Quote:
Originally Posted by
>>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?
You're no fun Serge: Because they can do it in Informix of course. <g>
I had an extra line that I removed
"I want what (s)he has" is not sufficient ... according to my mom
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Serge Rielau wrote:
Quote:
Originally Posted by
DA Morgan wrote:
Quote:
Originally Posted by
>Serge Rielau wrote:
Quote:
Originally Posted by
>>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?
>You're no fun Serge: Because they can do it in Informix of course. <g>
I had an extra line that I removed
"I want what (s)he has" is not sufficient ... according to my mom
Ok it is 10:20pm PDT and I'm checking email while finishing off a little
single malt. That makes it 1:20am EDT, Saturday morning, where you are.
If haven't anything better to do come on out here. We'll be sailing up
past Nanaimo in about three weeks and all computers and cell phones
will be left at the dock.
--
Daniel A. Morgan
University of Washington
Join Bytes! (replace x with u to respond)
On Jul 21, 12:46 am, DA Morgan <damor...@psoug.orgwrote:
Quote:
Originally Posted by
Serge Rielau wrote:
Quote:
Originally Posted by
rick wrote:
Quote:
Originally Posted by
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?
>
Quote:
Originally Posted by
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
|
|
|
What is Bytes?
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 197,039 network members.
Top Community Contributors
|
