[Cialug] DB2

Tim Wilson tim_linux at wilson-home.com
Wed Sep 21 09:48:14 CDT 2005


It is true, it depends on the version of DB2.  In our update scripts,
any time we have to add or delete a column, we go through these steps:
1. ALTER TABLE table DROP CONSTRAINT constraint; (Do this for each constraint).
2. RENAME TABLE table TO oldtable;
3. CREATE TABLE table ...
4. INSERT INTO table ... SELECT ... FROM oldtable;
5. DROP TABLE oldtable;

On 9/21/05, David Stout <ragbrai65 at yahoo.com> wrote:
>
> There is no Primary or Foreign Key on this column.
> I have the same privileges as admin
>
> Dave Weis <djweis at internetsolver.com> wrote:
>
> Try
> ALTER TABLE payroll DROP company_id
> If it's a key as the name implies it might have constraints from other
> tables preventing it from being dropped at all.
>
> On Wed, 21 Sep 2005, David Stout wrote:
>
> > I tryed this
> >
> > ALTER TABLE PAYROLL
> > DROP COLUMN COMPANY_ID
> >
> > and got this
> >
> >
> > Error: SQL0104N An unexpected token "COLUMN" was found following "TABLE
> PAYROLL DROP". Expected tokens may include: "CONSTRAINT". SQLSTATE=42601
> >
> > (State:42601, Native Code: FFFFFF98)
> >
> >
> > "Nathan C. Smith" wrote:
> > 'Alter table' in SQL?
> >
> > -----Original Message-----
> > From: David Stout [mailto:ragbrai65 at yahoo.com]
> > Sent: Wednesday, September 21, 2005 8:59 AM
> > To: cialug at cialug.org
> > Subject: [Cialug] DB2
> >
> >
> ! > I need a little help does anyone know If you can delete a column from a
> table in DB2. If so what is the syntax?
> >
> >
> > David Stout
> > BTS Billing Team
> > Data Repository & Reports
> >
> > ---------------------------------
> > Yahoo! for Good
> > Click here to donate to the Hurricane Katrina relief effort.
> _______________________________________________
> > Cialug mailing list
> > Cialug at cialug.org
> > http://cialug.org/mailman/listinfo/cialug
> >
> >
> > David Stout
> > BTS Billing Team
> > Data Repository & Reports
> >
> > ---------------------------------
> > Yahoo! for Good
> > Click here to donate to the Hurricane Katrina relief effort.
>
> --
> Dave Weis
> djweis at internetsolver.com
> http://www.internetsolver.com/
>
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug
>
>
> David Stout
> BTS Billing Team
> Data Repository & Reports
>
>  ________________________________
> Yahoo! for Good
>  Click here to donate to the Hurricane Katrina relief effort.
>
>
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug
>
>
>


--
Tim


More information about the Cialug mailing list