# ADA SQL

**URL:** <https://techcommunity.softwareag.com/t/ada-sql/57891>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Adabas-on-Mainframes, Adabas-Basics-on-Mainframes\
**Created:** [March 2, 2006, 6:56pm UTC](https://techcommunity.softwareag.com/t/ada-sql/57891 "2006-03-02T18:56:24Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![SPS](https://avatars.discourse-cdn.com/v4/letter/s/b38774/32.png) [@SPS](https://techcommunity.softwareag.com/u/SPS)\
**Post date:** [March 2, 2006, 6:56pm UTC](https://techcommunity.softwareag.com/t/ada-sql/57891/1 "2006-03-02T18:56:24Z")

</div>

How ADA SQL is used for ADABAS access? Is it better to use ADA SQL instead of NATURAL?

---

<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:** [March 2, 2006, 8:17pm UTC](https://techcommunity.softwareag.com/t/ada-sql/57891/2 "2006-03-02T20:17:26Z")

</div>

This is no “either / or”, these are different options for different purposes.

NATURAL is a 4GL development and runtime system, available on many platforms.

There are two “Adabas SQLs”:

Adabas native SQL is a SQL precompiler which translates SQL syntax to Adabas calls.

Adabas SQL Gateway provides ODBC, JDBC etc. interfaces to Adabas.

The newest addition to the family is the Adabas SOA Gateway which provides SOAP access to Adabas.

So, depending on the task at hand, there’s always a solution 😉

---

<div class="post-metadata">

**Author:** ![Claire\_Wilson](https://avatars.discourse-cdn.com/v4/letter/c/8baadc/32.png) [@Claire\_Wilson](https://techcommunity.softwareag.com/u/Claire_Wilson)\
**Post date:** [March 17, 2006, 3:48pm UTC](https://techcommunity.softwareag.com/t/ada-sql/57891/3 "2006-03-17T15:48:32Z")

</div>

We have a lot of batch cobol with ADABAS direct calls. I am looking at replacing them with SQL. Will I need this SQL Gateway to allow me to do that ?  
Thanks, Claire

---

<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:** [March 17, 2006, 7:58pm UTC](https://techcommunity.softwareag.com/t/ada-sql/57891/4 "2006-03-17T19:58:23Z")

</div>

Claire,

no, Adabas Native SQL is what you need for this.

If you have access to ServLine24 you will find the documentation here:

[http://servline24.softwareag.com/document/java/sql231/overview.htm](http://servline24.softwareag.com/document/java/sql231/overview.htm)

---

<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/ada-sql/57891/5 "2021-04-02T14:38:55Z")

</div>