Trying to write data to a Linked Server Table on a AS400 from a 2008 SQL Server R1
Posted on 2011-02-18
Hello everyone, thanks for you time. I have a very unique situation here. The company i work for has a IBM AS400 that is running Accounting systems on it. We have a Sales and Marketing system that is running a SQL Server 2008 R1. I have the AS400 as a linked the server and I can select*from from the table on the AS400 with zero problems. I have set a blank table on the AS400 and I have a view setup on the SQL Server to add data to the table on the AS400. I have done all of the PTF updates on the AS400 for the database and the hyper system. I am trying to write a statement that will select the data from the SQL view and place it in the table on the AS400. Here is what I have so far. I am a novice at SQL, I am more of a network engineer. Any help at all would be greatly appreciate. The following is the statement I have thus far, that is giving me syntax errors.
VALUES (<GLProject, varchar(20),>
INSERT INTO [AS400].[S069E014].[TSW].[GLTRN]
Thanks again for your time