# Store/Insert-SQL

**URL:** <https://techcommunity.softwareag.com/t/store-insert-sql/102342>\
**Category:** Forum\
**Tags:** Adabas-Natural, Natural, Natural-on-Linux\
**Created:** [February 12, 2013, 11:44am UTC](https://techcommunity.softwareag.com/t/store-insert-sql/102342 "2013-02-12T11:44:03Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Claudio\_Muller](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/claudio_muller/32/518_2.png) [@Claudio\_Muller](https://techcommunity.softwareag.com/u/Claudio_Muller)\
**Post date:** [February 12, 2013, 11:44am UTC](https://techcommunity.softwareag.com/t/store-insert-sql/102342/1 "2013-02-12T11:44:03Z")

</div>

I want to know if I understood well.

Store works to insert records into banks and banks Adabas SQL also?

Insert-SQL only works with SQL database?

To access any SQL database with Natural Entire Access is required (paid)?

---

<div class="post-metadata">

**Author:** ![Nikolay\_Kuhta](https://avatars.discourse-cdn.com/v4/letter/n/35a633/32.png) [@Nikolay\_Kuhta](https://techcommunity.softwareag.com/u/Nikolay_Kuhta)\
**Post date:** [February 12, 2013, 3:41pm UTC](https://techcommunity.softwareag.com/t/store-insert-sql/102342/2 "2013-02-12T15:41:37Z")

</div>

Sorry, Claudio, but (this is my humble opinion) it looks like this time your questions are too vague …  
Do you really want/need to access “ANY SQL database with Natural Entire Access” ? What do you mean by “SQL database”? I think you are rising some points of rather academic interest with your “ONLY” and “ANY”; why don`t you want to be more specific?

This is just my own opinion - I stress it, of course 🙂  
Best regards,  
NK

---

<div class="post-metadata">

**Author:** ![Claudio\_Muller](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/claudio_muller/32/518_2.png) [@Claudio\_Muller](https://techcommunity.softwareag.com/u/Claudio_Muller)\
**Post date:** [February 12, 2013, 4:14pm UTC](https://techcommunity.softwareag.com/t/store-insert-sql/102342/3 "2013-02-12T16:14:10Z")

</div>

Sorry and thank you.

“Store” works to insert records into Adabas and mysql/sqlserver also?

“Insert-SQL” only works with mysql? or Adabas also?

I hope it is clear now.

---

<div class="post-metadata">

**Author:** ![Nikolay\_Kuhta](https://avatars.discourse-cdn.com/v4/letter/n/35a633/32.png) [@Nikolay\_Kuhta](https://techcommunity.softwareag.com/u/Nikolay_Kuhta)\
**Post date:** [February 12, 2013, 4:42pm UTC](https://techcommunity.softwareag.com/t/store-insert-sql/102342/4 "2013-02-12T16:42:26Z")

</div>

Well, it is certainly more clear now indeed 🙂  
As for STORE, it works perfectly fine to add (or “insert” if you insist) a record into an Adabas file, and you may read here about it:  
[http://techcommunity.softwareag.com/ecosystem/documentation/natural/nat511uvm/top/5499crossplat/5501sm/6025store.htm](http://techcommunity.softwareag.com/ecosystem/documentation/natural/nat511uvm/top/5499crossplat/5501sm/6025store.htm)

As for MySQL / SQL Server you should rather ask those specialists I’m afraid.

The following link would give you a lot of info about  
“Insert-SQL” regarding Adabas database; I regret but I have no clue as for MySQL, sorry  
[http://techcommunity.softwareag.com/ecosystem/documentation/natural/nat426mf/sm/insert\_sql.htm](http://techcommunity.softwareag.com/ecosystem/documentation/natural/nat426mf/sm/insert_sql.htm)

---

<div class="post-metadata">

**Author:** ![Ralph\_Zbrog](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/ralph_zbrog/32/78_2.png) [@Ralph\_Zbrog](https://techcommunity.softwareag.com/u/Ralph_Zbrog)\
**Post date:** [February 12, 2013, 5:07pm UTC](https://techcommunity.softwareag.com/t/store-insert-sql/102342/5 "2013-02-12T17:07:00Z")

</div>

My understanding is that INSERT works only with SQL databases, but STORE works with SQL and Adabas databases. Perhaps INSERT would work with Adabas if Adabas SQL Gateway were present.

---

<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, 3:02pm UTC](https://techcommunity.softwareag.com/t/store-insert-sql/102342/6 "2021-04-02T15:02:53Z")

</div>