473,320 Members | 2,004 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

BEFORE OPTION

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
5 1512
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Fendi Baba | last post by:
The function is called from opencalendar(targetfield). Thanks for any hints on what could be the problem. .............................................................. var...
7
by: Robert Oschler | last post by:
I'm having a very painful time converting some Mozilla dynamic DOM code to work with Internet Explore. For example, given this code: -------------- selectBox=document.createElement("SELECT");...
7
by: Bryan D. | last post by:
Our application makes extensive use of C#'s event handling mechanism to communicate between classes. A problem has cropped in that it becomes difficult to know for sure that all observers of an...
2
by: martin | last post by:
Hi, I have a dropdown control tha is rendered with the follwoing HTML <select name="FirstStep:CmbTargetGroup" id="FirstStep_CmbTargetGroup" style="width:152px;"> <option...
2
by: Monty | last post by:
I use a SELECT dropdown as the nav interface for jumping to a chosen page number. When I setup up the SELECT element on the page, I want to show the user the current page number they are on, so, I...
1
by: J. Shane Kunkle | last post by:
A customer would like to redirect visitors to a "goodbye" page when they click on an outside link on their website. The website is quite large and I would rather not wade thru all the existing...
11
by: PokerMan | last post by:
Hi I have a situation where a method is fired from receiving a message from my server. On receiving this message it triggers a visual animation. So what happens when the server sends say 3...
9
by: Vanecelli | last post by:
Back again. Looking to check to see if an element has been output by a previous function before I do something in another function. Example: if (document.form1.Rank2==exist) { for (var...
6
by: webandwe | last post by:
Hi, My script lets you choose if you want to view table 1 or table 2 in mysql after you selected 1 or 2 from the drop down menu and press submit. The problem is if you run the script for the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.