SQLForeignKeys ODBC call

Question posted by: robert (Guest) on November 12th, 2005 06:02 AM

i use AQT mostly, and it uses ODBC and this call to show foreign key info.
what it gets back is the PK of the referenced table, not the target column(s)
of the foreign key. is this a shortcoming of ODBC, or the DB2 driver?
reading the SYSIBM columns i can get the true picture, but i'm not sure
whether the AQT folks are up to that; i suspect that normal user priviledges
would prevent even reading those tables (i guess i'm special).

DB2/V6/390
AQT on win2k

thanks,
robert

Quote | Subscribe