My theory was right.

Thank you John

Hi John,

Maybe it is because it has the same value.

Row1 has the same value with Row2

Maybe it needs to have a column with unique value

DELETE FROM A

FROM OPENQUERY(DB2400_WRITEPROD, 'Select * from PALTEMP.CNTUPDR') A

JOIN dbo.Client_Contact_Details_Update B ON A.CONTPNO = B.CONTPNO

DELETE OPENQUERY (DB2400_WRITEPROD, 'Select * from PALTEMP.CNTUPDR')

WHERE CONTPNO IN(SELECT CONTPNO FROM dbo.Client_Contact_Details_Update)

i've...

It is actually weird, i can use

DELETE openquery(DB2400_WRITEPROD, 'Select * from PALTEMP.CNTUPDR')

if the data is below 30, if it is higher than 30. the error occur.

Hi John,

I am using as/400 as linked server.

Library name: PALTEMP

File name: CNTUPDR

DB2400_WRITEPROD

My colleague who handles as/400 said that the database itself is the PALTEMP.

or is there any other way to...

Hi John,

Thank you for the fast response.

I've tried your solution and it gives me an error of

An invalid schema or catalog was specified for the provider "MSDASQL" for linked server...