<DIV>Where are you located?<BR><BR><B><I>Jon Clemons <clemdog@marshallnet.com></I></B> wrote:
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Come up here and I can fix that crazy want real quick:)<BR><BR>----- Original Message ----- <BR>From: "Dave J. Hala Jr." <DAVE@58GHZ.NET><BR>To: "Central Iowa Linux Users Group" <CIALUG@CIALUG.ORG><BR>Sent: Wednesday, September 21, 2005 9:51 AM<BR>Subject: Re: [Cialug] DB2<BR><BR><BR>> Now that makes me want to switch from Mysql to DB2....<BR>><BR>><BR>> On Wed, 2005-09-21 at 09:48, Tim Wilson wrote:<BR>>> It is true, it depends on the version of DB2. In our update scripts,<BR>>> any time we have to add or delete a column, we go through these steps:<BR>>> 1. ALTER TABLE table DROP CONSTRAINT constraint; (Do this for each <BR>>> constraint).<BR>>> 2. RENAME TABLE table TO oldtable;<BR>>> 3. CREATE TABLE table ...<BR>>> 4. INSERT INTO table ... SELECT ... FROM oldtable;<BR>>> 5. DROP TABLE oldtable;<BR>>><BR>>> On
9/21/05, David Stout <RAGBRAI65@YAHOO.COM>wrote:<BR>>> ><BR>>> > There is no Primary or Foreign Key on this column.<BR>>> > I have the same privileges as admin<BR>>> ><BR>>> > Dave Weis <DJWEIS@INTERNETSOLVER.COM>wrote:<BR>>> ><BR>>> > Try<BR>>> > ALTER TABLE payroll DROP company_id<BR>>> > If it's a key as the name implies it might have constraints from other<BR>>> > tables preventing it from being dropped at all.<BR>>> ><BR>>> > On Wed, 21 Sep 2005, David Stout wrote:<BR>>> ><BR>>> > > I tryed this<BR>>> > ><BR>>> > > ALTER TABLE PAYROLL<BR>>> > > DROP COLUMN COMPANY_ID<BR>>> > ><BR>>> > > and got this<BR>>> > ><BR>>> > ><BR>>> > > Error: SQL0104N An unexpected token "COLUMN" was found following <BR>>> > > "TABLE<BR>>> > PAYROLL DROP".
Expected tokens may include: "CONSTRAINT". <BR>>> > SQLSTATE=42601<BR>>> > ><BR>>> > > (State:42601, Native Code: FFFFFF98)<BR>>> > ><BR>>> > ><BR>>> > > "Nathan C. Smith" wrote:<BR>>> > > 'Alter table' in SQL?<BR>>> > ><BR>>> > > -----Original Message-----<BR>>> > > From: David Stout [mailto:ragbrai65@yahoo.com]<BR>>> > > Sent: Wednesday, September 21, 2005 8:59 AM<BR>>> > > To: cialug@cialug.org<BR>>> > > Subject: [Cialug] DB2<BR>>> > ><BR>>> > ><BR>>> > ! > I need a little help does anyone know If you can delete a column <BR>>> > from a<BR>>> > table in DB2. If so what is the syntax?<BR>>> > ><BR>>> > ><BR>>> > > David Stout<BR>>> > > BTS Billing Team<BR>>> > > Data Repository & Reports<BR>>> >
><BR>>> > > ---------------------------------<BR>>> > > Yahoo! for Good<BR>>> > > Click here to donate to the Hurricane Katrina relief effort.<BR>>> > _______________________________________________<BR>>> > > Cialug mailing list<BR>>> > > Cialug@cialug.org<BR>>> > > http://cialug.org/mailman/listinfo/cialug<BR>>> > ><BR>>> > ><BR>>> > > David Stout<BR>>> > > BTS Billing Team<BR>>> > > Data Repository & Reports<BR>>> > ><BR>>> > > ---------------------------------<BR>>> > > Yahoo! for Good<BR>>> > > Click here to donate to the Hurricane Katrina relief effort.<BR>>> ><BR>>> > --<BR>>> > Dave Weis<BR>>> > djweis@internetsolver.com<BR>>> > http://www.internetsolver.com/<BR>>> ><BR>>> >
_______________________________________________<BR>>> > Cialug mailing list<BR>>> > Cialug@cialug.org<BR>>> > http://cialug.org/mailman/listinfo/cialug<BR>>> ><BR>>> ><BR>>> > David Stout<BR>>> > BTS Billing Team<BR>>> > Data Repository & Reports<BR>>> ><BR>>> > ________________________________<BR>>> > Yahoo! for Good<BR>>> > Click here to donate to the Hurricane Katrina relief effort.<BR>>> ><BR>>> ><BR>>> > _______________________________________________<BR>>> > Cialug mailing list<BR>>> > Cialug@cialug.org<BR>>> > http://cialug.org/mailman/listinfo/cialug<BR>>> ><BR>>> ><BR>>> ><BR>>><BR>>><BR>>> --<BR>>> Tim<BR>>> _______________________________________________<BR>>> Cialug mailing list<BR>>> Cialug@cialug.org<BR>>>
http://cialug.org/mailman/listinfo/cialug<BR>> -- <BR>><BR>> Open Source Information Systems, Inc. (OSIS)<BR>> Dave J. Hala Jr., President <DAVE@OSIS.US><BR>> 641.485.1606<BR>><BR>> _______________________________________________<BR>> Cialug mailing list<BR>> Cialug@cialug.org<BR>> http://cialug.org/mailman/listinfo/cialug<BR>> <BR><BR><BR>_______________________________________________<BR>Cialug mailing list<BR>Cialug@cialug.org<BR>http://cialug.org/mailman/listinfo/cialug<BR></BLOCKQUOTE></DIV><BR><BR>David Stout<br>BTS Billing Team<br>Data Repository & Reports<p>
<hr size=1>Yahoo! for Good<br>
<a href="http://store.yahoo.com/redcross-donate3/">Click here to donate</a> to the Hurricane Katrina relief effort.