NAT3700 Error -204 with SQLSTATE 42704 from call to DB2

, ,
1

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.

2

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 for assistance.

1 Like
3

Hi

image001.png829×179 2.01 KB

Natural programs using DB2 needs to be BINDed.

4

-204 name IS AN UNDEFINED NAME