Need help ! SQL and Proc *C

iwbasts · May 16, 2006, 10:39pm

hi all !
Please help me
When I select data from oracle with proc * C prog.
I count the number of rows
For example the total rows is 1000000
but the number of result return is a limit number 5000 for ex
So How can I know this limit

system · May 17, 2006, 3:32am

check the environment variables like ROWCOUNT for database access and set them accordingly using EXEC SQL statements.

iwbasts · May 17, 2006, 5:50am

how to check ?

jim_mcnamara · May 17, 2006, 7:14am

ARRAYSIZE determines how fetches work.

If you post your SELECT statement then we can help.

iwbasts · May 18, 2006, 2:50am

I define the arraysize is 5000
The total rows is 2500
But cnt=sqlca.sqlerrd[2] just 550
How ?

Raom · May 18, 2006, 3:42am

yes ROWCOUNT is correct variable to rely on .