How To Resolve -219 SQLCODE Error

Raphael Bacay · Posted: Thu Jul 26, 2007 8:06 am

Hello,

I am binding a group of programs but I come up with a -219 SQLCODE.
References say that "THE EXPLANATION TABLE IS NOT AVAILABLE".
I am not aware of this 'explanation table' and where to get it. Required response says to creat one but I don't know how it looks like.
I never encountered this error before so I would like to ask your expert advice on how to resolve this -219 SQLCODE error.

Regards.

kgumraj · Posted: Thu Jul 26, 2007 10:13 am

Hi,

Check the Bind parametes.
Check if EXPLAIN(YES)

Remove this and bind again, I feel you will not get this error.

if possible do post Bind step

Raphael Bacay · Posted: Thu Jul 26, 2007 12:02 pm

I tried this but it did not work. I think it has got something to do with the db region I am working with. I am still investigating the cause of this problem.

vicky10001 · Active User Joined: 13 Jul 2005 Posts: 136

DB2 attempted a positioned UPDATE or DELETE was attempted on a row that no longer matches its previous condition. The column values in the result table row do not match the current values in the base table row because the row was updated between the time it was inserted into the result table and the positioned update or delete was executed. cursor-name Name of the cursor used for the positioned update or delete.

Raphael Bacay · Posted: Wed Aug 01, 2007 4:10 pm

I got the cause of it. My mainframe id hasn't got update, insert and delete access in db region so I cannot bind properly. Thanks for all the advice.