What is error -818 in db2.
where can you find the timestamp of the DBRM and the source
code.( precompile puts the timestamp on dbrm and source code
correct?)
- 2 Answers
- 10748 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
The error -818 is due to timestamp mismatch of the DBRM and
the source code. Basically same time stamp is marked in
DBRM and source code during pre compilation.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ajai
We can find the timestamp of the DBRM in SYSIBM.SYSPLAN and
timestamp of Sourcecode in Loadlib (inside soureccode to
search the pgm name).
| Is This Answer Correct ? | 2 Yes | 0 No |
How do you define a correlated name?
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
Explain db2.
What is sqlca’s maximum length?
What does it mean if the null indicator has -1, 0, -2?
What's the maximum number of characters that a tablename can have?
what is the use of bind parameter, Replace?
Explain the use of the WHERE clause?
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.
How is the SUBSTR keyword used in sql?
How to resolve -504 sql code in DB2?
What is Reorg Recovery? when will you run it?
COBOL 
