On Jun 27, 10:31 am, Lennart <Erik.Lennart.Jons...@[EMAIL PROTECTED]
> wrote:
[...]
> The other day I stumbled upon an error. The foreign keys
> are working as expected, but syscat.keycoluse.colseq indicates
> otherwise(I'm aware that syscat.references can be used instead, this
> is more of a nice to know thing)
Hmm, on second thought. Looking in:
SQL Reference Volume 1, Version 8. (havent checked 9.5 yet) in the
comment on syscat.references it says:
FK_COLNAMES:"List of foreign key column names. Warning: This column
will be removed in the future.Use SYSCAT.KEYCOLUSE for this
information."
PK_COLNAMES: "List of parent key column names. Warning: This column
will be removed in the future. Use SYSCAT.KEYCOLUSE for this
information."
But as shown in my earlier post, KEYCOLUSE.COLSEQ does not necessarily
reflect the colorder in the key. Reflections anyone?
/Lennart
[...]
|
