MVSFORUMS.com

Nic Clouston · Posted: Fri Jun 15, 2007 4:00 am Post subject:

Still awaiting your solution. I want to know if it was just a typo on your part - everyone does this - or whether ther is some weird thing we have to keep an eye out for.
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

satyenderd · Beginner Joined: 26 Aug 2005 Posts: 144 Topics: 73

-805 ->DBRM OR PACKAGE NAME NOT FOUND IN PLAN plan-name.

Solution:

Recompile the program and keep a new copy..

Reasons:

_________________
Satya

Nic Clouston · Posted: Tue Jul 10, 2007 12:52 pm Post subject:

satyenderd

Rexx is not, usually, compiled and if it was it does not have a DB2 precompiler to create a DBRM. It use dynamic SQL. To get a DBRM/PACKAGE a PREPARE satement is used. The probable cause here is that the table refered to is not on the DB2 subsystem defined. But as the OP has not come back with a response I guess we will never know if he just made a silly mistake, like we all do, or had something more interesting that we should all be aware of.
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

Nic Clouston · Posted: Tue Jul 10, 2007 12:53 pm Post subject:

satyender

Rexx is not, usually, compiled and if it was it does not have a DB2 precompiler to create a DBRM. It use dynamic SQL. To get a DBRM/PACKAGE a PREPARE satement is used. The probable cause here is that the table refered to is not on the DB2 subsystem defined. But as the OP has not come back with a response I guess we will never know if he just made a silly mistake, like we all do, or had something more interesting that we should all be aware of.
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.