Insert/Update syntax for Linked Server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Insert/Update syntax for Linked Server

Author

Topic

olivarez
Starting Member

1 Post

Posted - 2002-04-05 : 21:21:42

I have a SQL Server 2000 server linked to an AS400. I am able to query the data on the AS400 from SQL Server but I now need to manipulate the data on the AS400. For instance, I can submit:

select * from openquery(QS36F,'select * from QS36F.TESTTBL')

and get the results for the single record that exists.

I now need to insert a new record but can't find the syntax. I tried to update the record with the following:

update openquery(QS36F,'select * from QS36F.TESTTBL') set COLA=100

but getting errors. Any ideas on either INSERT or UPDATE?

Edited by - olivarez on 04/06/2002 11:04:39

yakoo
Constraint Violating Yak Guru

312 Posts

Posted - 2002-04-06 : 14:37:45

use the 4 part name qualifier which is server.database.user.table


UPDATE QS36F.mydatabase.dbo.TESTTBL SET COLA=100

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources