Posted by Erland Sommarskog on 02/28/06 01:10

Traveller (vavavoom_th14@yahoo.co.uk) writes:
> I am hoping some can help or point me in the right direction. We have
> recenlty installed SQL 2005 and are using integrated services using ole
> db connections. We are connecting to an Informix database.
>
> My questions is there a way I can pass through multiple sql statements
> when I create a OLE DB source to the Informix database.
> The reason I am doing this is we need to tell the Informix DB that we
> want to use "set isolation dirty read" as well as use the Parallel Data
> query part of informix.
>
> Please bear with me as I am just starting to use SQL 2005. I have not
> found a way to do this. Can anyone suggest something please.

I guess you should be able to do:

SELECT ... FROM OPENQUERY(INFORMIXSRV,
'Firststatement;
Secondstatment;
SELECT ... FROM tbl;'

But keep in mind that OPENQUERY is intended to be used for queries that
returns data in a tabular from that you can use in a SELECT statement,
and not for operations that perform updates. If that is what you are
looking into, it may be better to call a remote stored procedure. (Given
that Informix actually have stored procedures that is.)



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]