Error: SYSIBM.SYSDATABASE is an undeclared table

krishnadevanur · New User Joined: 02 Aug 2006 Posts: 8

Hi,

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 ?

Thanks,

Krishna

dick scherrer · Posted: Mon Feb 26, 2007 2:08 am

Hello,

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.

palas_08 · New User Joined: 26 Feb 2007 Posts: 9 Location: kolkatta

hi,

i think it will be sysibm.sysdummy1

vini_srcna · Posted: Tue Mar 06, 2007 3:23 pm

Can you be more specific. What exactly you are trying to do and what you need. If you just need CURRENT DATE - 7 DAYS then use the register SYSIBM.SYSDUMMY1.

You may not have access to the catalog tables in production.
If am right you might have got this error while during BIND. What is the SQLCODE..? Is that -204 ..? or -550 series.