Page 1 of 1

How to solve -805 error?

PostPosted: Tue Oct 30, 2007 8:36 pm
by abkumarch
how to solve -805 ?
if u r telling tat change the name of plan or pgm , how ?

Re: How to solve -805 error?

PostPosted: Wed Oct 31, 2007 2:26 am
by dick scherrer
Hello,

If you post complete info, we can better provide help.

Re: How to solve -805 error?

PostPosted: Wed Oct 31, 2007 4:41 pm
by abkumarch
i got -805 sqlcode error while binding an embedded sql pgm,, how to solve it ?

Re: How to solve -805 error?

PostPosted: Wed Oct 31, 2007 9:39 pm
by dick scherrer
Hello,

To repeat
If you post complete info, we can better provide help.
You have not provided the complete info. More diagnostic info was presented when you received this error and you need to post it here.

Re: How to solve -805 error?

PostPosted: Mon Nov 09, 2009 5:41 pm
by abhishek.kumar
The plan name you are reffering does not exists, check that you are referring to the correct plan name in SYSIN parameter

//SYSIN DD *
DSN SYSTEM(DB2B)
RUN PROGRAM(ABC) PLAN(ABC)
END

PLEASE MAKE SURE THAT PLAN NAME IS CORRECT WHICH YOU HAVE CREATED.

Re: How to solve -805 error?

PostPosted: Thu Feb 28, 2013 8:15 pm
by pmartyn
On the abend you should see a timestamp that corresponds to the plan/package in error. to deterine if it is missing you can either go to the DBRM LIBS and search or the DB2 catalog in the DBRM table. Even if found you may have the timestamp mis-match. You might have to have the DBA examine the versions and see why your version is missing (fell off the end maybe?). You may just need to re-compile/bind your program to pick up the latest version.

Re: How to solve -805 error?

PostPosted: Thu Feb 28, 2013 8:25 pm
by c62ap90
-805 DBRM or package not found in plan. { re-bind ? }

Re: How to solve -805 error?

PostPosted: Thu Feb 28, 2013 8:33 pm
by enrico-sorichetti
any reason to resurrect paleontological topics :geek:
abends-sql-codes/topic309.html