Hi,

I am trying to set some generator values using a SELECT MAX(ID) FROM
MYTABLE?
Can this be done? or some automatic way for this?

I was thinking of some code like this:
SET GENERATOR GEN_MY_TABLE_ID TO SELECT MAX(ID) FROM MYTABLE

Regards,

Luis