Whats the error msg?
-----Original Message-----
From: Bruce Sorge [mailto:[EMAIL PROTECTED]
Sent: 03 May 2007 18:19
To: SQL
Subject: DB2 Query
I have this query that I generated in SQL Server that I want to use in
DB2,
but it is not working:
INSERT INTO tblCurrentCouncilMembers
(NC_ID, Member_ID, FirstName, LastName, HomePHone, WorkPhone, OrgPhone,
Email, Address, City, State, Zip, CompanyName, Address1W,
CityW, StateW, ZipW, WebAddress, WorkPhoneExt1, FaxNumber, CellPhone,
Organization, OrgPhone1, OrgExt1, Address1O, CityO, StateO, ZipO,
DateEntered, dateModified, LastModifiedBy, AddedBy)
(SELECT tblDone.NeighborhoodCouncil, tblDone.done_ID,
tblDone.FirstName,
tblDone.LastName, tblDone.HomePhone,
tblDone.WorkPhone1, tblDone.OrgPhone1,
tblDone.EmailAddress, tblDone.Address, tblDone.City, tblDone.State,
tblDone.Zip, tblDone.CompanyName,
tblDone.Address1W,
tblDone.CityW, tblDone.StateW, tblDone.ZipW,
tblDone.WebAddress, tblDone.WorkPhoneExt1,
tblDone.FaxNumber, tblDone.CellPhone, tblDone.Organization,
tblDone.OrgPhone1 AS OrgPhone,
tblDone.OrgPhoneExt1,
tblDone.Address1O, tblDone.CityO, tblDone.StateO, tblDone.ZipO,
tblDone.DateEntered, tblDone.DateModified,
tblDone.LastModifiedBy, tblDone.AddedBy
FROM tblDone FULL OUTER JOIN tblNC ON tblDone.done_ID =
tblNC.done_ID
WHERE tblDONE.NeighborhoodCouncil IS NOT NULL)
Can a DB2 expert point out to me what is wrong?
Thanks,
--
Bruce Sorge
"I'm a mawg: half man, half dog. I'm my own best friend!"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 and Flex 2
Build sales & marketing dashboard RIAâs for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT
Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2835
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
