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.