MVSFORUMS.com

[deepatred]

Hi,

When DELETE using a cursor is done, does it delete record from cursor or the actual table?
DELETE FROM table-name WHERE CURRENT OF cursor-name

if it deletes from actual table, is there a way by which we can delete a record from cursor only that does not affect table.

An immediate reply would be of much help.

Thanks,

[CZerfas]

You mean you want to exclude rows from the answer set of your query? Since SQL is a set oriented language, you have to code predicates in the WHERE clause to achieve that.

See also the threads dealing with eliminating duplicate rows; in DB2 this is not a trivia.

regards
Christian

[deepatred]

Hi,

My understanding is if in a DELETE command WHERE clause we specify current record of CURSOR then it deletes that record from the Actual table not locally from cursor.

But if we have used ORDER BY clause then cursor is not deletable, what does CURSOR is not deletable means?
Does it mean that it can not delete from actual table?

After opening the cursor is it possible to delete records from cursor since it is a temporary result set?

Thanks

[CZerfas]

If you understand the concept of a cursor as a "pointer to data rows", then using this cursor to delete rows is only possible, if the cursor points currently to a row in the regular table space.

If you use the ORDER BY clause, all the rows of the answer set have to be fetched into the DB2 sort pool and sorted there. With the first FETCH issued from your program with this cursor, you are no longer "pointing" to a data row, but to an area in the DB2 sort pool.

Deleting there makes no sense at all.

regards
Christian

[deepatred]

ok, thanks