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?)
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 |
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
What does a deadlock mean in DB2?
Return code 100 means?
What is reorg and runstats in db2?
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
What is a lock?
What is the difference between SYNONYM and ALIAS?
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 difference between a package and a plan?
6 Answers Infosys, L&T, Mphasis,
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
What is null indicator in db2?
how to get duplicate records from tables?write qurey for this?