Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

Number of rows in SQL table

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Number of rows in SQL table

    Michael, I don't have the exact answer but if you examine the subfields in the SQLCA data structure just after your SQL SELECT statement executes, one of those subfields contains the number of rows selected. You should be able to determine which field in debug. Chris

  • #2
    Number of rows in SQL table

    I have a RPG program with embedded SQL where I am using SQL to read through a file with a scrollable cursor. I would like to know if there is a way to retrieve the number or rows that SQL has selected from my file (table). I know you can use the COUNT(*) function but, this would require that I create a separate SELECT statement for just this in my RPG program, and I wanted to save from having to do this. Michael Soucy

    Comment


    • #3
      Number of rows in SQL table

      Chris, Thanks. I'll look, and see what I can find.

      Comment

      Working...
      X