F
Fernando Souza
Guest
The issue with RECID on a partitioned table is that it can no longer identify a record by itself (assuming you know which table it belongs to). We advise people not to use it in their application code as you could end up finding the wrong record. However, in the context you describe, where you know the record you are looking for and just want to find the related _Lock record, you can still call RECID and get the record's recid but you need also the partition id to find the right entry in the _Lock table. The _lock-partitionid is the field you need to look at. And you can get the partition-id of a record using the BUFFER-PARTITION-ID() function.
Continue reading...
Continue reading...