How Many Rows Did SQL Fetch?
March 29, 2006 Hey, Ted
|
I am using SQL to load a subfile. Since there are 16 subfile records to a page, I fetch 16 database records into a data structure. However, the fetch does not always return 16 rows. Sometimes it returns fewer. How can I tell how many data structure occurrences were fetched? –Lynn You will need to check the SQLER3 field of the SQL Communications Area (SQLCA). I wrote about this field earlier in Four Hundred Guru. See “How Many Records Did SQL Delete?” Here’s an example I threw together that you can start from. It fetches seven records at a |
