fetchNumRows ???

[akkakm]

Hello every one,

Can anyone tell me what does it mean fetchNumRows = 74 after each select ? sometimes fetchNumRows = 99, 100
Exemple: SELECT * FROM PRODDTA.F4102 WHERE ( IBMCU = ' CSM' AND IBITM = 141.000000 )
Jun 21 10:33:18 ** 1112/1528 ORACLE DBFetch: Invoke OCI Fetch fetchNumRows = 74

Many thanks
Mo - Developper OW xe

 

[SULLY1]

Mo

I think this is a sequencial read thru the database. You will see fetchNumRows = 100 for every 100 records read unless the file has less than 100 records.

Patty

 

[akkakm]

Thanks for your answer, it seems to me that is logic what you said.