Question
Kevin Pickering · Jul 14

ODBC OPENQUERY INFORMATION_SCHEMA.COLUMNS

Apologies if this isn't the correct forum but here goes..

I'm accessing an Intersystems database from MS SQL Server using Intersystems ODBC driver and using OPENQUERY statement to read metadata of tables using

SELECT * FROM OPENQUERY([<linked server name>], 'SELECT * FROM INFORMATION_SCHEMA.COLUMNS')

but I get an error message saying INFORMATION_SCHEMA.COLUMNS cannot be found.

Intersystems SQL documentation does reference this table so is there some other way to access this table or is it maybe a permissions issue?

 

00
3 0 3 60
Log in or sign up to continue

Hi Kevin.

What version of Caché or InterSystems IRIS do you have? INFORMATION_SCHEMA.COLUMNS seem to be available only since Caché 2015.2

Hi Alexander and thanks for the reply.

I can't say for sure which version I'm querying against as it is an external supplier providing our health data but the ODBC driver version is 2012.02.00.638 which suggests that it won't be available if Cache needs to be 2015 and above. That would clear that up...

The difficulty of finding people willing to learn and program with objectscript is becoming a challenge anywhere in the world. Here at the hospital in Brazil, it was necessary to train a totally new person who learned to like script objects