Transact SQL

Posted in 2004

Michael Andreas — Thu, 11 Mar 2004 10:11:24 +0100 — source: Usenet: comp.databases.informix

Hi, the following command is correct in other db's but informix allways reports a message "syntax error" why? INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0','C:\\Access.mdb';'admin';'', tab) SELECT * FROM tab;

↪ replying to Michael Andreas

Serge Rielau — Thu, 11 Mar 2004 08:05:58 -0500 — source: Usenet: comp.databases.informix

Michael Andreas wrote: > Hi, > > the following command is correct in other db's You mean it works in SQL Server, SQL Server and also SQL Server? > but informix allways reports a message "syntax error" > why? Because it's proprietary? > > INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0',> 'C:\\Access.mdb';'admin';'', tab) SELECT * FROM tab; > > Can you explain what OPENROWSET(...) does? This may be services by an external table in Informix (?) Cheers Serge -- Serge Rielau DB2 SQL Compiler Development IBM Toronto Lab