# NAT3700 Error -204 with SQLSTATE 42704 from call to DB2

**URL:** <https://techcommunity.softwareag.com/t/nat3700-error-204-with-sqlstate-42704-from-call-to-db2/292883>\
**Category:** Forum\
**Tags:** Adabas-Natural, Natural, Natural-on-Mainframes\
**Created:** [March 7, 2024, 9:47pm UTC](https://techcommunity.softwareag.com/t/nat3700-error-204-with-sqlstate-42704-from-call-to-db2/292883 "2024-03-07T21:47:59Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kusumam\_A\_M](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/kusumam_a_m/32/31865_2.png) [@Kusumam\_A\_M](https://techcommunity.softwareag.com/u/Kusumam_A_M)\
**Post date:** [March 7, 2024, 9:47pm UTC](https://techcommunity.softwareag.com/t/nat3700-error-204-with-sqlstate-42704-from-call-to-db2/292883/1 "2024-03-07T21:47:59Z")

</div>

Please let me know why below error occurs while a user access a DB2 Table through a Natural Program in a batch job.  
NAT3700 Error -204 with SQLSTATE 42704 from call to DB2.

From DB2 side, this table has necessary access and definitions to execute.  
In Natural Security, this table’s DDM have PUBL access and also all the columns are incorporated in table’s DDM. Last generation of this DDM was done in 2003.

---

<div class="post-metadata">

**Author:** ![Douglas\_Kelly](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/douglas_kelly/32/102_2.png) [@Douglas\_Kelly](https://techcommunity.softwareag.com/u/Douglas_Kelly)\
**Post date:** [March 7, 2024, 10:09pm UTC](https://techcommunity.softwareag.com/t/nat3700-error-204-with-sqlstate-42704-from-call-to-db2/292883/2 "2024-03-07T22:09:47Z")

</div>

This is likely a DB2 issue as “SQLSTATE 42704” is a DB2 error. Please check IBM documentation such as [https://www.ibm.com/support/pages/db2-sql-error-sqlcode-204-sqlstate42704-when-connecting-new-controller-db](https://www.ibm.com/support/pages/db2-sql-error-sqlcode-204-sqlstate42704-when-connecting-new-controller-db) for assistance.

---

<div class="post-metadata">

**Author:** ![Dion\_Kejlberg](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/dion_kejlberg/32/525_2.png) [@Dion\_Kejlberg](https://techcommunity.softwareag.com/u/Dion_Kejlberg)\
**Post date:** [March 8, 2024, 7:14am UTC](https://techcommunity.softwareag.com/t/nat3700-error-204-with-sqlstate-42704-from-call-to-db2/292883/3 "2024-03-08T07:14:44Z")

</div>

Hi

 ![](https://global.discourse-cdn.com/techcommunity/original/3X/d/1/d157db0ac9fdbddef5edacaae0088f7e7b70ed2e.png)

Natural programs using DB2 needs to be BINDed.

---

<div class="post-metadata">

**Author:** ![Daniel\_Wilson](https://avatars.discourse-cdn.com/v4/letter/d/94ad74/32.png) [@Daniel\_Wilson](https://techcommunity.softwareag.com/u/Daniel_Wilson)\
**Post date:** [March 8, 2024, 1:52pm UTC](https://techcommunity.softwareag.com/t/nat3700-error-204-with-sqlstate-42704-from-call-to-db2/292883/4 "2024-03-08T13:52:20Z")

</div>

> -204 name IS AN UNDEFINED NAME

---

<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:** [September 4, 2024, 1:52pm UTC](https://techcommunity.softwareag.com/t/nat3700-error-204-with-sqlstate-42704-from-call-to-db2/292883/5 "2024-09-04T13:52:23Z")

</div>

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.
