Select 
       case 
         when (mn.minix = si.name and sk.colseq = 1) then si.tbname
         else ' '
        end  table_nme,
       case 
         when (sk.colseq = 1) then si.name 
         else ' '
       end index_nme,
       sk.colname, 
       case
          when sc.coltype = 'CHAR' 
         then  strip(sc.coltype) || '(' || varchar(sc.length) || ')' 
          when sc.coltype = 'FLOAT' and sc.length = 2
         then  'DOUBLE'
          when sc.coltype = 'VARCHAR' 
         then  strip(sc.coltype) || '(' || varchar(sc.length) || ')'
          when sc.coltype = 'DECIMAL' 
         then  strip(sc.coltype) || '(' || varchar(sc.length) || ', ' 
                || varchar(scale) || ')'
         else  sc.coltype 
       end    as coltype,      
       sk.colseq,
       case 
         when (sk.colseq = 1) 
         then '      ' || si.UNIQUERULE
         else ' '
       end UNIQUERULE
 from sysibm.sysindexes  si
   join
      sysibm.syskeys     sk 
   on si.name       = sk.ixname
   join  
      sysibm.syscolumns  sc 
   on sc.tbname   = si.tbname    
      and
      sc.name       = sk.colname
	and
	sc.tbcreator = si.tbcreator
   join table
      (select min(name) minix, tbname
         from sysibm.sysindexes mn
         where   mn.tbcreator = sc.tbcreator 
         group by tbname) mn
   on
       mn.tbname = si.tbname    
           
where     si.tbname in (ucase('Yours_TBL_NAME'))                         
	    and
            si.tbcreator = 'Yours_TBL_CREATOR'
order by si.tbname, si.name, sk.colseq;
with ur;

si.tbname in 
(ucase('Yours_TBL_1'), ucase('Yours_TBL_2'), ...)