I'm hoping to navigate the INFORMATION_SCHEMA views (QSYS2 in DB2/400) to get table constraint information.
Currently I want to be able to get the primary key for a table - which is availabe in TABLE_CONSTRAINTS (QSYS2.SYSCST), where CONSTRAINT_TYPE = 'PRIMARY KEY'.
However, in the catalog I'm accessing, there are no entries for tables created through DDS - where I would expect to find PRIMARY KEY entries for key/unique fields defined in PF and LF source.
Is there any mapping between the DDS and constraint entries in the catalog?
I'm aware of API QSQGNDDL, but I'm aiming to get the information from the ANSI-standard views if I can.
Any pointers would be apprciated.