|
|
|
|
|
|
| Author |
Message |
Serge Rielau
*nix forums Guru
Joined: 29 Apr 2005
Posts: 1583
|
 Posted: Fri Feb 25, 2005 8:10 pm Post subject:
Re: How to I delete a column from a table in DB2 on AIX or Window Environment
|
|
|
Mark A wrote:
| Quote: | "Serge Rielau" <srielau@ca.ibm.com> wrote in message
snip
The tooling team took great care to not force the GUI onto anyone.
snip
Cheers
Serge
Unfortunately, the development team has been a very good job of not forcing
the GUI onto anyone for a long time.
The GUI for OS/2 Database Manager (circa 1990) was much better.
Now that's a whole different can of tuna.  |
(Un)fortunately out of my control.
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab |
|
| Back to top |
|
 |
Vincent M
*nix forums Guru
Joined: 22 Feb 2005
Posts: 1332
|
| Posted: Fri Feb 25, 2005 8:33 pm Post subject:
Re: How to I delete a column from a table in DB2 on AIX or Window Environment
|
|
|
"Serge Rielau" <srielau@ca.ibm.com> wrote in message
news:389iguF5j3u5sU1@individual.net...
| Quote: | Now that's a whole different can of tuna.
(Un)fortunately out of my control.
Cheers
Serge
|
Can anyone from the Toronto Lab explain to me why it so difficult to build
the Control Center so that it remembers directory paths, for backup paths,
loads, etc (Separate paths for each function and each database)? This is GUI
101.
Every time a new DB2 release comes out, I pray for it to be there, but alas,
disappointment again in 8.2. It looks like they rewrote the directory path
browser, and it is a little better, but still slower than molasses, and it
can't remember directory paths from previous sessions.
The MS and Oracle marketing people are giddy with joy once again. |
|
| Back to top |
|
|
Dave Benjamin
*nix forums addict
Joined: 26 Apr 2005
Posts: 74
|
| Posted: Fri Feb 25, 2005 9:04 pm Post subject:
Re: How to I delete a column from a table in DB2 on AIX or Window Environment
|
|
|
Mark A wrote:
| Quote: | Look like the only way to delete a collumn on db2 V8 is
1) export the table with out that column
2) drop all contraint relate to that table
3) drop table
4) add table wit out that column
5) add contraints relate to that table back
6) import the file of step 1
any comments
Correct for DB2 for LUW. TEh control center automates thse steps.
Including fixing up authorization dependent objects.
I believe that DB2 V 8.2 is needed for the Control Center enhancements to
automate the dropping of a column. They use a stored procedure to do this,
so it could be done with a script if you could figure out the input parms.
Hint: use Show SQL in Control Center.
|
I think you might be right. Even if I select a column in the "alter
table" screen, the "remove" button never un-dims. I'm using 8.1.
Dave |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Thu Jan 08, 2009 2:25 am | All times are GMT
|
|
Debt Consolidation | Personal Injury Attorney Los Angeles | Credit Card | Mortgages | Guitar Lessons
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
IBM DB2
