# Calling a SQL Stored procedure from a natural program

**URL:** <https://techcommunity.softwareag.com/t/calling-a-sql-stored-procedure-from-a-natural-program/91216>\
**Category:** Forum\
**Tags:** Adabas-Natural, Natural, Natural-on-Mainframes\
**Created:** [September 11, 2009, 6:25pm UTC](https://techcommunity.softwareag.com/t/calling-a-sql-stored-procedure-from-a-natural-program/91216 "2009-09-11T18:25:18Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mark3](https://avatars.discourse-cdn.com/v4/letter/m/ecb155/32.png) [@Mark3](https://techcommunity.softwareag.com/u/Mark3)\
**Post date:** [September 11, 2009, 6:25pm UTC](https://techcommunity.softwareag.com/t/calling-a-sql-stored-procedure-from-a-natural-program/91216/1 "2009-09-11T18:25:18Z")

</div>

I have a need to call a SQL Stored procedure from a natural program running in a mainframe environment. Can this be done

---

<div class="post-metadata">

**Author:** ![Finn\_the\_Dane1](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/finn_the_dane1/32/132_2.png) [@Finn\_the\_Dane1](https://techcommunity.softwareag.com/u/Finn_the_Dane1)\
**Post date:** [September 11, 2009, 6:32pm UTC](https://techcommunity.softwareag.com/t/calling-a-sql-stored-procedure-from-a-natural-program/91216/2 "2009-09-11T18:32:41Z")

</div>

Natural → DB2 both on mainframe ?  
Then the statement CALLDBPROC should be what yuou are looking.  
Finn

---

<div class="post-metadata">

**Author:** ![Mark3](https://avatars.discourse-cdn.com/v4/letter/m/ecb155/32.png) [@Mark3](https://techcommunity.softwareag.com/u/Mark3)\
**Post date:** [September 11, 2009, 6:41pm UTC](https://techcommunity.softwareag.com/t/calling-a-sql-stored-procedure-from-a-natural-program/91216/3 "2009-09-11T18:41:31Z")

</div>

Natural (adabas) on the mainframe → SQL server on the LAN - is there anyway to do this?

---

<div class="post-metadata">

**Author:** ![Finn\_the\_Dane1](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/finn_the_dane1/32/132_2.png) [@Finn\_the\_Dane1](https://techcommunity.softwareag.com/u/Finn_the_Dane1)\
**Post date:** [September 11, 2009, 6:55pm UTC](https://techcommunity.softwareag.com/t/calling-a-sql-stored-procedure-from-a-natural-program/91216/4 "2009-09-11T18:55:21Z")

</div>

Then you should have a look at this new product (not feature;-)  
Finn

## Marketing here: [http://www.softwareag.com/corporate/images/200804\_FS\_Natural\_SQLGateway\_e\_tcm16-39787.pdf](http://www.softwareag.com/corporate/images/200804_FS_Natural_SQLGateway_e_tcm16-39787.pdf)

Documentation here:  
Natural SQL Gateway  
With Natural SQL Gateway, a Natural user residing on z/OS can access data in an SQL database residing either on a UNIX or a Windows system.

[http://techcommunity.softwareag.com/ecosystem/documentation/natural/nat425mf/dbms/udb-over.htm#udb-over](http://techcommunity.softwareag.com/ecosystem/documentation/natural/nat425mf/dbms/udb-over.htm#udb-over)

---

<div class="post-metadata">

**Author:** ![Mark3](https://avatars.discourse-cdn.com/v4/letter/m/ecb155/32.png) [@Mark3](https://techcommunity.softwareag.com/u/Mark3)\
**Post date:** [September 11, 2009, 8:38pm UTC](https://techcommunity.softwareag.com/t/calling-a-sql-stored-procedure-from-a-natural-program/91216/5 "2009-09-11T20:38:12Z")

</div>

Thanks for your help Finn

---

<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:57pm UTC](https://techcommunity.softwareag.com/t/calling-a-sql-stored-procedure-from-a-natural-program/91216/6 "2021-04-02T14:57:30Z")

</div>