Is it possible to define an auto-incremental coloumn which increments by 'group' ?

I want to create a version log for an old table (uniquely keyed 'HOWTONO') which contains records with 'How to' data in the form of short code-fields and some long fields with text.  I intend to trigger updates, inserts  and deletions from this table, and use SQL in the trigger pgm to INSERT a record in a new  SQL-defined table  'VERSIONS'.

This new file shall be keyed by (HOWTONO + versionnumber).

Is it possible to define the 'versionnumber'-coloumn such that it is incrementet [strong]within[/strong] the group of a [strong]single[/strong] HOWTONO number?

 

 



Software/Hardware used:
9407/M15 (Power6) running V6R1