# DB2 -204 error for a new program

**URL:** <https://techcommunity.softwareag.com/t/db2-204-error-for-a-new-program/93493>\
**Category:** Forum\
**Tags:** Adabas-Natural, Natural, Natural-on-Mainframes, Natural-Database-and-TP-Monitor-Interfaces-on-Mainframes\
**Created:** [April 30, 2010, 1:08pm UTC](https://techcommunity.softwareag.com/t/db2-204-error-for-a-new-program/93493 "2010-04-30T13:08:44Z")\
**Posts on this page:** 2\
**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, 1:08pm UTC](https://techcommunity.softwareag.com/t/db2-204-error-for-a-new-program/93493/1 "2010-04-30T13:08:44Z")

</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:** ![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/93493/2 "2021-04-02T14:58:26Z")

</div>


