# Descriptor\`s Uniqueness

**URL:** <https://techcommunity.softwareag.com/t/descriptor-s-uniqueness/198381>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Adabas-on-Mainframes, Adabas-Utilities-on-Mainframes\
**Created:** [March 2, 2018, 3:44pm UTC](https://techcommunity.softwareag.com/t/descriptor-s-uniqueness/198381 "2018-03-02T15:44:24Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nikolay\_Kuhta](https://avatars.discourse-cdn.com/v4/letter/n/35a633/32.png) [@Nikolay\_Kuhta](https://techcommunity.softwareag.com/u/Nikolay_Kuhta)\
**Post date:** [March 2, 2018, 3:44pm UTC](https://techcommunity.softwareag.com/t/descriptor-s-uniqueness/198381/1 "2018-03-02T15:44:24Z")

</div>

Hi guys,  
We have a quite large (~180M records) Adabas file with some super-descriptors on it.  
My question: is there any way - without making any changes on the file - to know that a specific super-descriptor contains only unique values (something like  
ADAINV INVERT FILES SUPDE=super-field,UQ, TEST  
(and RC = 0 if this is true  
or ABEND if this verification fails). I suspect it is NOT possible, but I am NOT an expert in this area.

Many thanks in advance.

---

<div class="post-metadata">

**Author:** ![Steve\_Robinson](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/steve_robinson/32/107_2.png) [@Steve\_Robinson](https://techcommunity.softwareag.com/u/Steve_Robinson)\
**Post date:** [March 3, 2018, 2:54am UTC](https://techcommunity.softwareag.com/t/descriptor-s-uniqueness/198381/2 "2018-03-03T02:54:34Z")

</div>

RESET #ANSWER  
HISTOGRAM FILE-OR-VIEW-NAME SUPER-NAME  
IF _NUMBER GT 1 /_ NON UNIQUE VALUE  
MOVE ‘NOT-U’ TO #ANSWER  
ESCAPE BOTTOM  
END-IF  
END-HISTOGRAM  
IF #ANSWER = ’ ’  
WRITE 'SUPER HAS ALL UNIQUE VALUES  
END-IF

---

<div class="post-metadata">

**Author:** ![Nikolay\_Kuhta](https://avatars.discourse-cdn.com/v4/letter/n/35a633/32.png) [@Nikolay\_Kuhta](https://techcommunity.softwareag.com/u/Nikolay_Kuhta)\
**Post date:** [March 5, 2018, 2:57pm UTC](https://techcommunity.softwareag.com/t/descriptor-s-uniqueness/198381/3 "2018-03-05T14:57:42Z")

</div>

Thank you very much, Steve  
(although I expected some rather “utilitarian” solution to such a problem) 🙂  
It looks like you just confirmed my negative assumption…

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 2, 2021, 3:40pm UTC](https://techcommunity.softwareag.com/t/descriptor-s-uniqueness/198381/4 "2021-04-02T15:40:14Z")

</div>