I am using the CA class and have a strange thing happening.

I use CursorFill to create a cursor that is basically a parameterized view. I edit a Memo field in my cursor and issue a TABLEUPDATE.

The next time I issue a CursorFill() the memo comes back as empty. It does this for all subsequent CursorFills even if the parameter is changed to a different key, even if I close the cursor, and even if I completely release the CA object and create a new one.

However if I do another query on the table using SQLEXEC() the next time I issue a CursorFill the updated memo field is returned. I can add a small Select command in the AfterUpdate() but it is not an ideal solution.

This could be another DB2 oddity.