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!"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ
Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2834
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
