I have compiled a cobol program in test region and I binded the program in test region and it was successful.
But when I tried to compile in production region I am getting MAXCC = 12 saying that SYSIBM.SYSDATABASE ( I have used a query: SELECT CURRENT DATE - 7 DAYS FROM SYSIBM.SYSDATABASE WHERE NAME = 'DB014289') is an undeclared table.
How to resolve this issue ?
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
This sounds like a DB2 question, rather than a Natural/MQSeries question.
Maybe a moderator will move it if it is DB2 related.
Please find some other JCL that works to compile/bind in your production environment. It may be that your list of libraries is does not include everything needed for production.
If it works in test and fails in production, the fix will be site-specific. Have you ever used this table in production? Youmight try the query vis SPUFI or QMF to be sure your query will work in productions.
What step gets the RC=12? If you post your jcl and all of the error information, that will help.