Upgrade AS400 from SQL 2000

I am trying to update something in AS400 from SQL Server 2000 via openquery as shown below.

UPDATE
OPENQUERY(odbcname, 'SELECT * FROM "libname"."filename" WITH NC')
SET NBFLAG01=1
WHERE NBFLAG01 <> 1

      

Here is the error I am getting.

"OLE DB provider 'MSDASQL' reported an error.  
[OLE/DB provider returned message: Insufficient base table information for updating or refreshing.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange::SetData returned 0x80004005:   ].

      

0


source to share


1 answer


Try to list your fields. If anything, fix it as a problem.



+1


source







All Articles