There's a new ROWID data type in V5R2 that can be used to have DB2 generate a 40-byte unique identifier for each new row in a table. You might also consider writing a Before Insert trigger that "intercepts" the insert request and computes a unique identifier for that row.
================================== MORE INFORMATION ON THIS TOPIC ==================================
Search400.com's targeted search engine: Get relevant information on DB2/400.
The Best Web Links: tips, tutorials and more.
Check out this online event, Getting the Most out of SQL & DB2 UDB for the iSeries.
This was first published in June 2003