how to get the foreign keys in AS400table 1

[dboira]

the microsoft ADO 2.7 dll can not obtain the foreing keys of an AS400 table. I think that it's possible using the Client Access Express dll; adding it in a references of a visual basic project. So in the cwbDatabaseCatalog class there is the cwbdbRetrieveForeingKeysInfo method. could tell me someone how is the correct implementation to obtain the foreing keys of a table using this method?

 

[fredericofonseca]

do a select from
select * from sysibm/SQLFOREIGNKEYS
look at the records and then reduce the select so that only the table you wish is returned.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[dboira]

I have solved it similary; making a query to a catalog tables and the where for the corresponding table on column TABLE_NAME

Thanks