Bruce Sorge wrote: > 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?
Drop the parenthesis around the select statement. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:2836 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
