# Support for multivalue fields

**URL:** <https://techcommunity.softwareag.com/t/support-for-multivalue-fields/58166>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Adabas-Add-on-Products, SQL-Access, Mainframe-Integration, CONNX\
**Created:** [November 2, 2006, 9:34pm UTC](https://techcommunity.softwareag.com/t/support-for-multivalue-fields/58166 "2006-11-02T21:34:14Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Edwin\_van\_Asch](https://avatars.discourse-cdn.com/v4/letter/e/9e8a1a/32.png) [@Edwin\_van\_Asch](https://techcommunity.softwareag.com/u/Edwin_van_Asch)\
**Post date:** [November 2, 2006, 9:34pm UTC](https://techcommunity.softwareag.com/t/support-for-multivalue-fields/58166/1 "2006-11-02T21:34:14Z")

</div>

We are working on a prospect for SQL gateway who is also looking at Treehouse.

This customer has a question about SQL Gateway:

Does the SQL gateway have support for multi value fields and for periodic groups (and MV-fields inside periodic groups).

if so how do we support this ?

---

<div class="post-metadata">

**Author:** ![SM1](https://avatars.discourse-cdn.com/v4/letter/s/9de0a6/32.png) [@SM1](https://techcommunity.softwareag.com/u/SM1)\
**Post date:** [May 20, 2007, 12:03pm UTC](https://techcommunity.softwareag.com/t/support-for-multivalue-fields/58166/2 "2007-05-20T12:03:48Z")

</div>

Yes. ADASQL v-6.5.2 does support MU/PE and MU within PE. We have tested this with ADASQL-652 on M/F with NATURAL-414+PREDICT-451. Using the SYSTRANS of Natural the DDMs were exported onto a sequential dataset, then FTP on a flat-file, which is then imported on CONNX Data Dictionary under WinXP). While importing the CONNX gives you the option of including the no. of occurences. The Default value is ‘5’.

---

<div class="post-metadata">

**Author:** ![Luis\_B1](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/luis_b1/32/32713_2.png) [@Luis\_B1](https://techcommunity.softwareag.com/u/Luis_B1)\
**Post date:** [December 17, 2007, 9:22pm UTC](https://techcommunity.softwareag.com/t/support-for-multivalue-fields/58166/3 "2007-12-17T21:22:55Z")

</div>

You can work with multiple value and periodic fields in two ways:  
If you create the data dictionary from a SYSTRANS file, when Adabas SQL Gateway found a file with MU/PE fields creates two types of “views” for this file:  
1.- A flat file view, which means all the occurences of the MU/PE in the original file are “flattened”, you get a new file with all single fields in the original table and the MU/PE fields repeated as many times as occurences have the original MU/PE field. (ie. if you have a periodic field named “date” - 30 occurs, the flat file contains 30 single fields named “date1”, “date2” … “date30”).  
2.- The Gateway creates too “rotated tables”, which means to normalize the file structure. For each file with MU/PE fields the Gateway creates a root table with non repetitive fields plus one table for each MU/PE field. This files are linked within the ISN field of the root table.  
My recommendation is to work with the second option (rotated tables), I try this and works fine.  
I hope this could help, sorry for my bad english.

Luis B. 🙂

---

<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, 2:39pm UTC](https://techcommunity.softwareag.com/t/support-for-multivalue-fields/58166/4 "2021-04-02T14:39:05Z")

</div>