Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Posts
    3

    Unanswered: DB2 equivalent of Oracle %ROWCOUNT attribute?

    Is there an equivalent to the Oracle %ROWCOUNT attribute in DB2.

    In a DB2 stored procedure I want to obtain the number of rows deleted by a delete statement. Is it possible to do this?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    The sqlerrd(3) in the SQLCA. This is documented in the SQL Reference Guide.

Posting Permissions

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