MVSFORUMS.com

jajularamesh · Beginner Joined: 14 Apr 2006 Posts: 87 Topics: 33

can anyone please let me know the actual difference between sqlcode -805 and -818

i have binded a cobol db2 program with a wrong DBRM lib and expecting sqlcode -818 as there will be a Timestamp mis match but i am actually getting -805.

can anyone explain me the reason for this....

Nic Clouston · Posted: Tue Feb 20, 2007 4:09 am Post subject:

According to Quickref a -805 is plan/package not found a -818 is a timestamp problem. You may get the -818 if you resolve the -805 so that it can look at your plan/package!
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

blitz2 · Beginner Joined: 23 Jan 2007 Posts: 84 Topics: 14

Did you modify any sql statements in the program?
________
Yamaha SW396

Nithisha · Posted: Wed Feb 21, 2007 11:59 am Post subject: difference -805 and -818

The -805 occurs when you have not specified the plan name during the precompilation.
where as -818 occurs when there is mis match in sql and no sql process while creating the load module during the precompile process.

Thanks
nithisha

.