# Data extract ways **URL:** \ **Category:** Forum\ **Tags:** Adabas-Natural, Adabas, Adabas-on-Mainframes, Adabas-Utilities-on-Mainframes\ **Created:** [August 13, 2010, 2:09pm UTC](https://techcommunity.softwareag.com/t/data-extract-ways/94353 "2010-08-13T14:09:32Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Ats](https://avatars.discourse-cdn.com/v4/letter/a/da6949/32.png) [@Ats](https://techcommunity.softwareag.com/u/Ats)\ **Post date:** [August 13, 2010, 2:09pm UTC](https://techcommunity.softwareag.com/t/data-extract-ways/94353/1 "2010-08-13T14:09:32Z")
Hi All, I am looking if it is possible to extract data in a comma separated file on Mainframe using ADAULD/ADACMP combo? If not, what could be the other ways except writing a Natural program? ---
**Author:** ![Matthias1](https://avatars.discourse-cdn.com/v4/letter/m/9fc348/32.png) [@Matthias1](https://techcommunity.softwareag.com/u/Matthias1)\ **Post date:** [August 13, 2010, 2:29pm UTC](https://techcommunity.softwareag.com/t/data-extract-ways/94353/2 "2010-08-13T14:29:31Z")
ADACMP on Open Systems knows an option called SEPARATOR. But I don’t know if this options is available on Mainframe… ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [August 13, 2010, 3:01pm UTC](https://techcommunity.softwareag.com/t/data-extract-ways/94353/3 "2010-08-13T15:01:41Z")
No, there is not such an option available on mainframe ☹ What you can do is to specify with the FORMAT parameter which fields you like to see in which sequence on the seq file. The fields are in the standard length, i.e. alpha fields will be filled with blank if the value itself is smaller. But what you do not get is the ´comma´, this sounds like some programming effort. Maybe some other customer can help ? ---
**Author:** ![Matthias1](https://avatars.discourse-cdn.com/v4/letter/m/9fc348/32.png) [@Matthias1](https://techcommunity.softwareag.com/u/Matthias1)\ **Post date:** [August 13, 2010, 4:03pm UTC](https://techcommunity.softwareag.com/t/data-extract-ways/94353/4 "2010-08-13T16:03:49Z")
Here’s a similiar discussion - hope that helps: [http://tech.forums.softwareag.com/viewtopic.php?t=13936](http://tech.forums.softwareag.com/viewtopic.php?t=13936) ---
**Author:** ![Ats](https://avatars.discourse-cdn.com/v4/letter/a/da6949/32.png) [@Ats](https://techcommunity.softwareag.com/u/Ats)\ **Post date:** [August 13, 2010, 4:49pm UTC](https://techcommunity.softwareag.com/t/data-extract-ways/94353/5 "2010-08-13T16:49:25Z")
Thanks for the details! If I go with ADACMP FORMAT combo may be that could work but the limitation is that it would require application knowledge to know how many occurences for each MU/PE or a program to read the entire file and record the greatest C\* value for each repeating group. Hope I am in right direction :? ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [August 13, 2010, 5:39pm UTC](https://techcommunity.softwareag.com/t/data-extract-ways/94353/6 "2010-08-13T17:39:01Z")
Hi Ats, you are absolutely correct ! That´s another challenge ( 😉 ) for you to overcome. Maybe this helps: Run ADACMP DECOMPRESS with format=‘XXC’ (XX is the name of the PE) and you receive a counter for each record for the occurence of the PE in hex format. The maximum of this counter is the maximum occurence of the PE. So maybe two ADACMP DECOMPRESS steps ?! First to find out maximum PE occurence and then second with this value ? Someone else who has another idea :?: Regards, Uschi ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [August 18, 2010, 3:48pm UTC](https://techcommunity.softwareag.com/t/data-extract-ways/94353/7 "2010-08-18T15:48:44Z")
The Adabas SOA Gateway would allow you to do that very easily. ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [August 19, 2010, 3:51am UTC](https://techcommunity.softwareag.com/t/data-extract-ways/94353/8 "2010-08-19T03:51:33Z")
With SCC Toolkit you can do that very easily (and it’s free!): Step 1: Generate a Natural program to produce PE/MU occurrence statistics (except it doesn’t support MU within PE - yet) Step 2: Generate a Natural program to produce a comma-delimited extract file. [http://scctoolkit.atspace.com/](http://scctoolkit.atspace.com/) ---
**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, 2:58pm UTC](https://techcommunity.softwareag.com/t/data-extract-ways/94353/9 "2021-04-02T14:58:53Z")