How to get lotus db column names for a view using ODBC
I currently have an ODBC connection setup to a Lotus Notes db using the NotesSQL Driver which is used to create reports in Cognos BI 8.4. I need to query for the programmatic column names (field names) in a view that I've imported into Cognos Framework Manager, since I need a dynamic way of getting all them, but can't figure out how.
There has to be some sort of SQL to do this (other wise how does Cognos Framework manage开发者_运维知识库r get all the column names?) I just don't know how.
I'm only familiar with doing this in DB2.
The ODBC function SqlColumns
will return the column names. More info can be found here in the NotesSQL documentation.
精彩评论