AnsweredAssumed Answered

@rows_dropped variable

Question asked by MinaSalama on Apr 20, 2017
Latest reply on Apr 23, 2017 by MinaSalama


I have already confiigured RDBMS interface to read data from a SQL DB using the distribution tag approach. I am interested to detect instances when not all the rows queried, are not distributed.


Based on the user guide, I can use the @rows_dropped variable for that. However, there are no details about this variable. I am not sure if it is a SQL variable or PI variable?

I am also wondering if I can reference this variable in AF. I am thinking of using this variable to trigger an AF event. is that doable or is there an alternate approach for that?


Thanks in advance,