CODEWITHSUNDEEP
javasqlvbaodbclotus-notes
Michael
Michael

Reputation: 21

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 manager get all the column names?) I just don't know how.

I'm only familiar with doing this in DB2.

Upvotes: 2

Views: 788

Answers (1)

Ken Pespisa
Ken Pespisa

Reputation: 22284

The ODBC function SqlColumns will return the column names. More info can be found here in the NotesSQL documentation.

Upvotes: 2

Related Questions