# ADABAS NATIVE SQL and VISTA incompatible

**URL:** <https://techcommunity.softwareag.com/t/adabas-native-sql-and-vista-incompatible/57916>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Adabas-Add-on-Products, Adabas-Distributed-Data\
**Created:** [March 10, 2006, 11:09pm UTC](https://techcommunity.softwareag.com/t/adabas-native-sql-and-vista-incompatible/57916 "2006-03-10T23:09:03Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![James\_Poole](https://avatars.discourse-cdn.com/v4/letter/j/c77e96/32.png) [@James\_Poole](https://techcommunity.softwareag.com/u/James_Poole)\
**Post date:** [March 10, 2006, 11:09pm UTC](https://techcommunity.softwareag.com/t/adabas-native-sql-and-vista-incompatible/57916/1 "2006-03-10T23:09:03Z")

</div>

No need for a reply.

This is a fyi for those few shops that might actually have Adabas Native SQL and VISTA.

Per Denver SAG LOG #599898, and several months of arguing, the SQL developers have finally conceded that these products are not compatible (see specifics next paragraph). Our offered solution was rejected (to disable the extra check).  
We received the traditional response to Adabas Native SQL problems: Change Enhancement.

We were trying to consolidate a messy development environment of 22 FDIC files across 22 databases into one database and a few FDIC files (yes, our shop is that messy). VISTA was to be a critical component of  
mapping the FDIC files to avoid any application changes. With VISTA and remapping, the SQL compiles all receive SQL error 0217. So much for VISTA for this solution, we are going through the application change route.

Part of the reply was that this ADAGLOB record check against the FDIC  
control record was a safety check to avoid problems with GFORMAT and  
GCID generations. However, the DB/FNR uniquely qualifies the GCID being generated and does need to do this check.

---

<div class="post-metadata">

**Author:** ![John4096](https://avatars.discourse-cdn.com/v4/letter/j/d26b3c/32.png) [@John4096](https://techcommunity.softwareag.com/u/John4096)\
**Post date:** [March 11, 2006, 7:58pm UTC](https://techcommunity.softwareag.com/t/adabas-native-sql-and-vista-incompatible/57916/2 "2006-03-11T19:58:46Z")

</div>

Would a custom “zap” to disable the unnecessary check be of help? If so, contact me off list to discuss. (@gmail.com)

---

<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:38pm UTC](https://techcommunity.softwareag.com/t/adabas-native-sql-and-vista-incompatible/57916/3 "2021-04-02T14:38:56Z")

</div>


