By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,611 Members | 1,693 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,611 IT Pros & Developers. It's quick & easy.

BEFORE OPTION

P: n/a
Hi

How can we add a column (alter) before certain column in DB2, just
like Informix has BEFORE OPTION

tHaNks
Rick

Jul 20 '07 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Jul 21 '07 #2

P: n/a
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
da******@x.washington.edu (replace x with u to respond)
Jul 21 '07 #3

P: n/a
DA Morgan wrote:
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?
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
Jul 21 '07 #4

P: n/a
Serge Rielau wrote:
DA Morgan wrote:
>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?
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
da******@x.washington.edu (replace x with u to respond)
Jul 21 '07 #5

P: n/a
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

Aug 2 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.