Currently when launching a datareader using a procedure and with a button in a screen, to my knowledge there no way to display directly in the screen the result to the end user in term of row rejected and integrated. Or even prompt a pop up with a "Do you want to continue?" message when a reject happen in order to prevent losing time on calculating wrong data.
For that reason, it would be a nice idea to have the possibility access technical/system cube(s) within our current database, in particular the total rows, and rejected rows. For example, with a cube having following entities :
- Data Reader (automated populated entity with all the data reader name)
- Informations (Row total, Row valid, Row rejected, time in sec)
Hi Nicolas CHIGROS,
you can access this information by loading the Board database log file immediately after running the data reader. It contains the number of rows (rejected, valid, time in sec). When you activate the decicated log file option for the data reader you will also receive a log file with the rejected records.
Hope this helps.
BR
Sebastian