<snip>

>>off the subject a bit, but what is a surrogate key and how are they used? looked in the developers guide but could find nothing.
>>
>>thanks - brenda

>'Surrogate' key means that its value does not carry any business sense, i.e. it's usually sequentally generated integer.

i see said the blind (and sad to be at work) women. back in my mainframe db2 days, we used the timestamp. it was unique and always in ascending order. it created a self maintained table (no table or index splits) since all new rows were added to the end.

thanks