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
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
Number of rows in SQL table
Collapse
X
-
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