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?
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