<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2722" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Marshalltown </FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=ragbrai65@yahoo.com href="mailto:ragbrai65@yahoo.com">David Stout</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=cialug@cialug.org
href="mailto:cialug@cialug.org">Central Iowa Linux Users Group</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, September 21, 2005 10:12
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Cialug] DB2</DIV>
<DIV><BR></DIV>
<DIV>Where are you located?<BR><BR><B><I>Jon Clemons <<A
href="mailto:clemdog@marshallnet.com">clemdog@marshallnet.com</A>></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.
<P>
<HR>
<P></P>_______________________________________________<BR>Cialug mailing
list<BR>Cialug@cialug.org<BR>http://cialug.org/mailman/listinfo/cialug<BR></BLOCKQUOTE></BODY></HTML>