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 |
What is a dbrm in db2?
What is the difference between SYNONYM and ALIAS?
What is a page?
What os does db2 run on?
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
What does it mean if the null indicator has -1, 0, -2?
How to check last update on table in db2?
COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
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 do I add a column in db2?
What is cursor stability?