Insert and Update AS-400 Table, From SQL Server
Posted on 2005-05-02
I gather this is a common problem. I setup an ODBC connector on my SQL Server machine, pointing to a library
on our AS-400. I can import tables from the AS-400 to SQL Server. I can execute the following SQL, to update
a table on the AS400:
set OLDATE = 20050101
Unfortunately, however, when I try reading a value from a SQL Svr, then use it to update the AS400, I keep
getting an error that says there is no searchable column or something like that. Searching via Google, I see
lots of people have run into this problem, but so far, have found no answers.
Anyone know how to update an AS400 table with data from SQL Server?