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 types of tables are there in the db2 database?

556


Is the primary key a clustered index?

611


What is the difference between dbm cfg and db cfg file in db2 ?

1006


What is package in db2 mainframe?

559


Is it possible using max on a char column?

609






Explain about dbrm.

609


Explain about rct.

652


What is dbrm library?

578


Explain about rct in db2?

640


What is iseries database?

597


How to rename a table in DB2 ?

639


What is the use of value function?

629


Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

1897


What is the use of db2 optimizer?

611


What is the clustering index in the db2 database?

584