I am trying to append rows to an AS400 table using an sql query on the SQL data.
insert openquery(AS400, 'select * from <as400file> where 1=0') VALUES (' ','J01499','JOE','BROWN','MR')
However, I am getting the following error message:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: Query cannot be updated because it contains no searchable columns to use as a key.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange::InsertRow returned 0x80004005: ].