Is there a way to set all generators to a value, for example i use the
following code to set a single table generator

SELECT MAX(ID) FROM ADDRESS INTO :ID;
ID = GEN_ID (GEN_ADDRESS_ID, ID - GEN_ID(GEN_ADDRESS_ID,0));

I want to scan all tables in the database and set all generators to the
table max value.All my generators are named as GEN_TABLENAME_ID

Thanks!

Muthu Annamalai