Well, I think we're talking apples and oranges. This is what we tried in DB2: in SQL Server we tried to use OpenQuery to send more than one statement at once to DB2, and it just silently ignored the second statement. However, we /could/ do two separate OpenQuery statements in the same SQL script.
This works: Select * from openquery (db2prodss, ' Select * from ZPFCSAD.TVCHFACC where voucher in (''0012'',''0014'') ') Select * from openquery (db2prodss, ' Delete ZPFCSAD.TVCHFACC ') This doesn't: Select * from openquery (db2prodss, ' Select * from ZPFCSAD.TVCHFACC where voucher in (''0012'',''0014''); Delete ZPFCSAD.TVCHFACC; ') I may have some syntax errors there, I just threw it in as a quick example. > -----Original Message----- > From: Dave Watts [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 04, 2006 11:29 AM > > > I was told by someone that develops on Oracle that multiple > > queries are not supported, but I suppose he could have been > > wrong. > > You can run an SQL batch through SQL*Plus and see for > yourself. That's just > another Oracle client. And I'm pretty sure that you can run > SQL batches > against DB2 with some client, too. Otherwise, it would be difficult to > script database creation, etc. This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236925 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54