Sir, all those fields in the where clause are the indexes. I think indexes in AS 400 are just the same with keys in SQL. Sir, to tell you...

Client Access ODBC Driver (32-bit)!

Sir, can you recommend me some other driver(s)?

Yes Sir, i can succesfully make a select statement using openquery or using the fully qualified table name. When i added a link server on our SQL, i used an...

Sir, i tried using fully qualified table name like this :

 

select * from LEAVESBOX.S102CCCM.LVSDEVLIB.LVSNP

select statements worked but when i tried the insert or update statements...

Mr. Allen Cui,

as you requested, i have installed and run the MS DTC (Distributed Transaction Coordinator ) service of MS SQL and run the script below:

...

i have tried the example refered to me by allen.

 

begin tran

SET QUOTED_IDENTIFIER OFF

SET XACT_ABORT ON

declare @cmd varchar(2500) 



Select @cmd = 'Update openquery(LEAVESBOX,''Select SNER,SNBHNO,SNEN,SNLC,SNASDT,SNAEDT,SNUPD...