Openquery insert into syntax

[marta05]

Hi;

I am trying to update the info on db2 from sql server.
I created a link server and I can get the information by running the following query:

select * from openquery(rftest1, 'select * from aqua.aqua.itin')

I would like to insert information into the itin table in db2 from sql, however.

What is the syntax please???

-Marta

 

[SonOfEmidec1100]

I havent used openquery but based on openrowset syntax I think this would work.

INSERT INTO db2..itin
SELECT A.*
FROM openquery(rftest1, 'select * from aqua.aqua.itin') AS A

 

[danno64]

I just figured this out today. Try this:
INSERT INTO OPENQUERY(rftest1, 'SELECT field1, field2, fieldN FROM aqua.aqua.itin) SELECT field1, field2, fieldN FROM sqlTable WHERE ...continue WHERE clause....