Page 1 of 1

Duplicate records in a csdb

Posted: May 25th, 2019, 9:30 am
by AriSilva
Hi folks,
I was having trouble with two records with the same ID, but with different contents. They were in different backup files, so, I executed a batch cspro program changing the ID of one of them, and did a concatenation to put them together, but the concat output told me that they were still duplicated.
I assumed that it was because of the internal cspro key the records have in the csdb, so, I converted one of the files to .dat and reconverted it back to .csdb, and it worked.
I wonder if there is some way to have access to that internal identification key.
Best
Ari

Re: Duplicate records in a csdb

Posted: May 29th, 2019, 11:59 am
by Gregory Martin
You can access the key by calling this:
uuid(DICT_NAME)
However, you can't change it in logic, so the above is mostly just for informational purposes (or if you're working with paradata reports).