# DB2 -204 error for a new program

**URL:** <https://techcommunity.softwareag.com/t/db2-204-error-for-a-new-program/93499>\
**Category:** Forum\
**Tags:** Adabas-Natural, Natural, Natural-on-Mainframes\
**Created:** [April 30, 2010, 3:22pm UTC](https://techcommunity.softwareag.com/t/db2-204-error-for-a-new-program/93499 "2010-04-30T15:22:25Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ramya](https://avatars.discourse-cdn.com/v4/letter/r/e9c0ed/32.png) [@Ramya](https://techcommunity.softwareag.com/u/Ramya)\
**Post date:** [April 30, 2010, 3:22pm UTC](https://techcommunity.softwareag.com/t/db2-204-error-for-a-new-program/93499/1 "2010-04-30T15:22:25Z")

</div>

Hi

We have moved the new natural program code(Object) from testing region to production region .

So for the first time we didnot stowed the program in the production and ran the program , then we got the DB2 -204 error :

DB2 MESSAGE :  
SQLCODE = -204, ERROR: QPINCA.VIS\_PRODUCT\_TYPE IS AN UNDEFINED NAME  
SQLSTATE = 42704 SQLSTATE RETURN CODE

So then we have stowed the program in the production itsef and tried runing the job .  
But still we are getting the same DB2 error

VIS\_\* are the views to the production tables  
QPINC is the High level qualifier for the views  
QPINCA is the high level qualifier for the tables .

So it should be QPINC.VIS\_PRODUCT\_TYPE but not QPINCA.VIS\_PRODUCT\_TYPE

So how can i change the high level qualifier accessed by the views for this particular Natural program

But one more thing all other old Natural programs are running fine  
Can you please help me out.

---

<div class="post-metadata">

**Author:** ![Brian\_Johnson1](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/brian_johnson1/32/163_2.png) [@Brian\_Johnson1](https://techcommunity.softwareag.com/u/Brian_Johnson1)\
**Post date:** [April 30, 2010, 10:01pm UTC](https://techcommunity.softwareag.com/t/db2-204-error-for-a-new-program/93499/2 "2010-04-30T22:01:51Z")

</div>

For this and your other thread, are you sure the DBA promoted these table objects to production? Sounds like a missing table, according to my non-DB2 trained point of view.

---

<div class="post-metadata">

**Author:** ![Ramya](https://avatars.discourse-cdn.com/v4/letter/r/e9c0ed/32.png) [@Ramya](https://techcommunity.softwareag.com/u/Ramya)\
**Post date:** [May 1, 2010, 10:25am UTC](https://techcommunity.softwareag.com/t/db2-204-error-for-a-new-program/93499/3 "2010-05-01T10:25:21Z")

</div>

Hi

All the tables and also the views are present in the production  
As i posted earlier, i think its problem with the high level qualifier QPINCA .

We manually tried running the query using QPINCA.VIS\_PRODUCT\_TYPE , it is failing .  
But

1. If we run the query QPINC.VIS\_PRODUCT\_TYPE it is fetching the data…as QPINC is the SQLID for all the VIEWS of the DB2 TABLES

2)If we run the query QPINCA.TIS0012 (TIS0012 is the Table name for the VIEW VIS\_PRODUCT\_TYPE ) it is fetching the data … as QPINCA is the High level qualifier for all the DB2 Tables.

So how can we set the SQLID’s for the VIEWS the program is accessing .

So do we need to take care of any DB2 issues before stowing the modified NATURAL Program and creating the object.

Note : The same NATURAL program (Old Object code) is working fine.

---

<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:58pm UTC](https://techcommunity.softwareag.com/t/db2-204-error-for-a-new-program/93499/4 "2021-04-02T14:58:26Z")

</div>


