[Cialug] DB2

[Dave J. Hala Jr.]

Whaddya gonna do, show me a quote for the support contract and a 250
user license? Besides, why would I wanna come up there on a Wednesday? I
think I should wait until "free lunch friday"...

:) Dave





On Wed, 2005-09-21 at 09:50, Jon Clemons wrote:
> Come up here and I can fix that crazy want real quick:)
> 
> ----- Original Message ----- 
> From: "Dave J. Hala Jr." <dave at 58ghz.net>
> To: "Central Iowa Linux Users Group" <cialug at cialug.org>
> Sent: Wednesday, September 21, 2005 9:51 AM
> Subject: Re: [Cialug] DB2
> 
> 
> > Now that makes me want to switch from Mysql to DB2....
> >
> >
> > On Wed, 2005-09-21 at 09:48, Tim Wilson wrote:
> >> 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
> >> _______________________________________________
> >> Cialug mailing list
> >> Cialug at cialug.org
> >> http://cialug.org/mailman/listinfo/cialug
> > -- 
> >
> > Open Source Information Systems, Inc. (OSIS)
> > Dave J. Hala Jr., President <dave at osis.us>
> > 641.485.1606
> >
> > _______________________________________________
> > Cialug mailing list
> > Cialug at cialug.org
> > http://cialug.org/mailman/listinfo/cialug
> > 
> 
> 
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug
-- 

Open Source Information Systems, Inc. (OSIS)
Dave J. Hala Jr., President <dave at osis.us>
641.485.1606