Does anybody have any ideas why I can’t delete * from an openquery? My tests are weird results. With this:
Delete openquery ([SX3_UTPRODB3],'SELECT * FROM PUB.vendormaintenance where vendorkey = ''1''')
It deletes that one record.
With this:
Delete openquery ([SX3_UTPRODB3],'SELECT * FROM...