I know datakey is unique in tdataseg table, but can anybody confirm if datakey is unique across all tdataseg tables? In other words, if we open view vdata, will all datakeys be different?
or is unique in combination with partition key?
Thanks in advance!
Datakey is not unique across all the tDataSeg partitions. Each table will begin at 1 and increment as each transaction is added. (I checked on an old V9 demo app i have) but would assume it has not changed in V11).this means that in the view the datakey values can be duplicated.
Also, the key to each table is only Datakey, not Datakey / Partitionkey, so if there are multiple locations on a particular tdataseg partiton, the datakey will just increment regardless of the partitionkey.