Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009
    Posts
    1

    Question Unanswered: Error on positioned delete of multiple fetch

    I am using cursor as below
    “Declare cursor C1
    rowset positioning
    with hold for
    Select columns-list from table-name
    for update .. ”

    “ DELETE FROM table-name
    WHERE CURRENT OF C1 FOR ROW :IDX OF ROWSET“
    I am getting error on positioned delete of multiple fetch. The SQLCODE=-904 ie unavailable resource (showing table space name). I am fetching 100 rows at a time and I am getting error after processing few rows. What could be the reason to this?.

  2. #2
    Join Date
    Feb 2009
    Posts
    114
    I suspect tablespace became unavailable for reason other than your cursor processing. Either that or there has to be more in the SQLCA that describes the error.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •