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
- 10137 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 |
what is the sqlcode -501
What is the maximum size of a char data type in db2?
What is the difference between cursor and select statement?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
how 2 resolve the -311 sqlcode
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
what is Static and dynamic linking
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
How to find schema of a table in db2?
How does one remove entries from the SCT02 table?
How are write I/Os from the buffer pool executed?
COBOL 
