User Profile

Collapse

Profile Sidebar

Collapse
gkarun
gkarun
Last Activity: May 23 '07, 11:37 AM
Joined: May 17 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • gkarun
    replied to To get the number of rows affected by a cursor open
    in DB2
    Hi frozenmist,

    That will not solve my problem. I want to know whether any register value or so is there to store the total number of matching rows for a SELECT query.
    Suppose my SELECT query select 100 rows from a 1000 row table, is there any system managed code (like SQLCODE or SQLERRD) contains the value 100 there.
    I referred the following link.
    http://publib.boulder. ibm.com/infocenter/iseries/v5r3/index.jsp?topic =/db2/rbafzmstfieldde scsqlca.htm...
    See more | Go to post

      Leave a comment:

    • gkarun
      started a topic To get the number of rows affected by a cursor open
      in DB2

      To get the number of rows affected by a cursor open

      Hi,

      I have a cursor opened by a PREPARE statement. I need the total number of rows whcih will be fetched by that cursor. Now I am taking the total number by a COUNT(*) of that dynamic SQL. As COUNT(*) affects the performance, I would like to get the same along with the PREPARE statement.

      Will any value in the SQLERRD table gives the total number fetched ? If so please specify how it can be done.

      Thanks...
      See more | Go to post
      No activity results to display
      Show More
      Working...