Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a question.
t[DB]Output component have NB_LINE_(update/insert,delete,rejected) row, but t[DB]Row component doesn't have those NB_LINE, only have "ERROR_MESSAGE,QUERY".
How to get NB_LINE or deleted row count from the tPostgresPlusRow component?
My query just " delete from [table] where a = 'some value' -->> want to get deleted row count.
Thanks,
Hello,
There is no global variable like ((Integer)globalMap.get("tPostgresPlusOutput_1_NB_LINE_DELETED")) available if you use tPostgresPlusRow to execute the statements, if you want to count the number of rows are deleted or updated, you have to use tPostgresPlusOutput to do it.
Best regards
Sabrina