I’m trying to capture data on dbExecute output port 1 (errors) along with other metadata fields that are passed in to it. The users guide says I have to have the 2 error fields, and any other field I want must have the same name / datatypes as the input metadata. On execution, I can get the errors coming out, but I am missing the input metadata. Attached is my graph, am I doing something wrong with it? Also, Is there a way to always get the status (error or success) coming out the port 1? It seems to only put data there if an error happens.
Hello,
I’m afraid I have no good news:
-
Input fields are propagated to output port only if DBExecute calls stored procedure, so it is not way to get the statements out. I’ve created an issue in our bug tracking system (http://bug.cloveretl.org/view.php?id=5737)
-
Getting the status is also not possible with DBExecute (I’ve also created a request: http://bug.cloveretl.org/view.php?id=5738). You could do it with Reformat or with your custom component that overrides the DBExecute.