dimanche 24 juillet 2016

Odbc & Sql connection in one query

I wanna select some records from the informix database via Odbc connection and insert them to a Sql database table.

INSERT INTO SAS.dbo.disconnectiontemp 
        (meterno) 
SELECT DISTINCT met_number                 
FROM   Bills.dbadmin.MeterData 

I've searched regrading that, but they didn't solve my issue. Is it possible to have both connections at one place?
Any help or suggestions would be appreciated. Thanks

Aucun commentaire:

Enregistrer un commentaire