IBM Mainframe Forum

how to solve -805 ?
if u r telling tat change the name of plan or pgm , how ?

Hello,

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

i got -805 sqlcode error while binding an embedded sql pgm,, how to solve it ?

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.

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.

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.

-805 DBRM or package not found in plan. { re-bind ? }

any reason to resurrect paleontological topics
abends-sql-codes/topic309.html