If you’ve ever dealt with DB2 IDENTITY columns chances are you may have wanted to know what the currently assigned max value is for all of the IDENTITY columns in the DB. If so, you can use the following SQL to generate the SQL that will give you your answer. Hope it helps!
Like this? Consider joining my mailing list, or at least using my affiliate link when buying from Amazon 🙂
select 'select '''||trim(t.tabname)||''', '''||trim(c.colname)||''', max('||trim(c.colname)||') from '||trim(t.tabschema)||'.'||trim(t.tabname)||' for read only with ur;' from syscat.sequences s join syscat.tables t on (s.seqschema=t.tabschema and s.create_time=t.create_time) join syscat.columns c on (t.tabschema=c.tabschema and t.tabname=c.tabname) where s.seqname like 'SQL%' and c.identity='Y'
You or someone you know looking to buy or sell?