SQL identity column V4R5 howto?

["Goodbar, Loyd (ETS - Water Valley)" <LGoodbar@xxxxxxxxxxxxxx>]

I know at V4R5 SQL does not have identity (auto number, auto sequence, auto
increment) columns. We're waiting for our 810 upgrade with V5R2 for this,
but I don't have a timeframe yet (hopefully by Oct 31).

Has anyone done a stored procedure or trigger or trigger/dtaq process for
using identity columns in SQL at V4R5?

I was thinking that I could write a before trigger to pass the library,
file, field, and RRN of the row to a data queue. A data queue monitor would
get these and do a "+1" to the field to populate the identity column. This
would "guarantee" serialization of the autonumbering process.

I would probably need to write an on-change trigger to "prevent" renumbering
of the identity column on existing rows.

Any other ideas, besides waiting for V5R2?

Thanks,
Loyd



--  
Loyd Goodbar
Programmer/analyst
BorgWarner Incorporated
ETS/Water Valley
662-473-5713
lgoodbar@xxxxxxxxxxxxxx