View previous topic :: View next topic
|
Author |
Message |
jajularamesh
New User
Joined: 21 Nov 2005 Posts: 8
|
|
|
|
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.... |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
Found here: http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/DSNMC0F7/2.1.7?DT=20000424164500
-805
Explanation: An application program attempted to use a DBRM or package 'location-name.collection-id.dbrm-name.consistency-token' that was not found.
-818
Explanation: The SQL precompiler places timestamp 'y' in the DBRM, and time stamp 'x' in the parameter list in the application program for each SQL statement. At BIND time, DB2 stores the DBRM timestamp for run-time use. At run-time, timestamp 'x', for the SQL statement being processed, is compared with timestamp 'y' derived from the DBRM 'z' at BIND time. If the two timestamps do not match, the DBRM and the application program were not the result of the same precompile. |
|
Back to top |
|
|
prakash271082
New User
Joined: 09 Sep 2005 Posts: 53
|
|
|
|
The reason being the program name not found in plan... |
|
Back to top |
|
|
|