var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: IBM DB2 working with indexes
DB21085I Instance "db2inst" uses DB2 code release "SQL07025" with level
identifier "03060105" and informational tokens "DB2 v220.127.116.11", "s020616" and
Hi, I'm trying to figure out, how to select all the tables from db which have at least one unique index.
Maybe someone could help.
My V7 memory is rather rusty, since it went out of support about 3 years ago. But try something like "select distinct tabschema,tabname from syscat.indexes where uniquerule in ('P','U')".
Thanks, that filled the gap I was stuck on.