How to resolve -818 sql code in DB2?

Answer Posted / arunshan

this is timestamp mismatch this will come only when you
directely bind the dbrm in to plan..
to rectify that check whether you have binded the correct dbrm.

if not rebind it again.

Is This Answer Correct ?    10 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is dbrm?

852


Explain in detail about buffer manager and its functionalities?

780


Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

7380


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

969


What is the difference between oracle and db2?

788


What is the maximum size of a char data type in db2?

769


What is a buffer in memory?

790


Mention the downsides of page level lock.

909


How does coalesce work?

751


What is null indicator in cobol db2?

774


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

971


What is copy pending status in db2?

864


What is data manager?

795


How many types of page locks can be held in db2?

799


What is a db2 tablespace?

780