<DIV>
<DIV>Thank to all who replied I have figured it out.</DIV>
<DIV>I have to:</DIV>
<DIV> </DIV>
<DIV><FONT face=Helv size=2>
<P>Create a temp table.</P>
<P>Copy to the temp table from the original tabled, drop original, and</P>
<P>select into new original from the temp table.</P></FONT><BR><BR><B><I>David Champion <dave@visionary.com></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">I think Jon was joking.<BR><BR>We might need to start putting <HUMOR></HUMOR>tags around stuff today. :p<BR><BR>Back to your original topic: Are you sure that by dropping your ID <BR>column that you're not going to cause a problem with a relationship / <BR>constraint / trigger? Relational Databases can be tricky if you don't <BR>know what you're doing... you could cause a lot of trouble.<BR><BR>-dc<BR><BR>David Stout wrote:<BR>> Where are you located?<BR>> <BR>> Jon Clemons <CLEMDOG@MARSHALLNET.COM>wrote:Come up here and I can fix that crazy want real quick:)<BR>> <BR>> ----- Original Message ----- <BR>> From: "Dave J. Hala Jr." <BR>> To: "Central Iowa Linux Users Group" <BR>> Sent: Wednesday, September 21, 2005 9:51 AM<BR>> Subject: Re: [Cialug] DB2<BR>> <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>>><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 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 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>>>>><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>>>>><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>>>>><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>>>>>_______________________________________________<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>>><BR>>>Open Source Information Systems, Inc. (OSIS)<BR>>>Dave J. Hala Jr., President <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>> _______________________________________________<BR>> Cialug mailing list<BR>> Cialug@cialug.org<BR>> http://cialug.org/mailman/listinfo/cialug<BR>> <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>> <BR>> _______________________________________________<BR>> Cialug mailing list<BR>> Cialug@cialug.org<BR>> http://cialug.org/mailman/listinfo/cialug<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>__________________________________________________<br>Do You Yahoo!?<br>Tired of spam? Yahoo! Mail has the best spam protection around <br>http://mail.yahoo.com