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 the use of value function?

727


How to check sequence on a table in db2?

691


What is null in db2?

652


Is it possible to create an Instance in DB2 using DB2 Control Center ?

713


What is schema in db2?

665






What is load utility in db2?

758


What are db2 objects?

717


What is bind and rebind in db2?

737


before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

1807


When reorg is used?

761


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

1897


What is the use of with ur in db2?

702


What is precompiler in db2?

669


How to fetch the last row from the table in SQL (db2)?

1149


Where can you declare a cursor in a cobol-db2 program?

676