Determining Primary Keys from ODBC Openedge 10.2B

I am currently in the process of implementing an ActiveRecord driver for Yii2 such that I could leverage my progress databases in my Yii application through their recommended APIs. However, because in ActiveRecord requires a primary key to be set in order to function properly (it has to know what fields are the unique identifiers of the record), i'm stuck manually setting these on every model class I create. (The driver can be viewed at https://github.com/ExchangeCore/yii2-progress-driver/tree/10.2.x)

What I'd like to know is if I have overlooked some method or SYSPROGRESS table (or other ODBC function) that might actually have what fields are primary keys. I have some hope for the SYSINDEXES table, but i'm not sure how to properly identify which index is the primary key.

Continue reading...