informix tüm tablolarda eklenmemiş bir alanı bulma

SELECT tabname
  FROM database_name:systables t1
 WHERE 
 t1.tabid >= 100
  AND NOT EXISTS (SELECT *
                     FROM database_name:syscolumns c 
                    WHERE c.tabid = t1.tabid and  c.colname = 'adddate'
                  )
order by 1;