Interested to Buy Any Domain ? << Click Here >> for more details...
How to solved 818 error
- 4 Answers
- 14735 Views
- Keane India Ltd, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nimsatprasad
>> -818 time stamp mismatch.
>> This is generated when the consistency tokens in the
DBRM and the load module are different.
>> So rebind the Cobol+Db2 program then successfully we run
the program.
| Is This Answer Correct ? | 15 Yes | 3 No |
Answer / steve
Check that the DBRMLIB being used in the bind has a time
stamp for the abending program that matches the LOADLIB.
Sometimes all we need to do is point to the correct
libraries. If that does not work then a rebind or
precompile, compile, relink and then rebind will work. The
last option always works, but many times an interviewer
wants to know if we understand what causes an -818. If we
just say we would recompile, link and bind we do not
demonstrate understanding of the root cause.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / as
I guess rebinding wont help in this scenario (because
rebind doesnt genearate new consistency tokens). We need to
pre-compile and compile the program again.
| Is This Answer Correct ? | 6 Yes | 4 No |
Answer / guest
-818 is a plan with matching contoken is missing. A bind of
the required DBRM/package to a plan will solve the problem.
| Is This Answer Correct ? | 2 Yes | 1 No |
in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
What is null in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
what are bind concepts in db2 cobol?
What is host variable in db2 cobol?
can we drop column from a table
What are foreign keys?
How to select the duplicate rows from a table?
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
What is Reorg Recovery? when will you run it?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
COBOL 
