Hi,
Is there way to trap the load DB utility messages/logs in the file. For the DBOutputTable component, there are two output ports present. How can I use them to trap the messages/logs.
Also, in case of error/failures where the SQL messages can be written and from which port.
I have tried small exercise and able to load the records however it doesnt any logs about no. of records read/updated/inserted etc...
Thnk you
Is there way to trap the load DB utility messages/logs in the file. For the DBOutputTable component, there are two output ports present. How can I use them to trap the messages/logs.
Also, in case of error/failures where the SQL messages can be written and from which port.
I have tried small exercise and able to load the records however it doesnt any logs about no. of records read/updated/inserted etc...
Thnk you
-
Hello,
Please find attached example graph. Error codes and messages are sent to output port 0. If you want know amount of records saved successfully and amount of errors, just look on the little blue information numbers above edges after your graph finishes. The number on the input edge of DBOutputWriter is the total number of records. The number on the output edge is the total number of errors. Subtract them and you will get the total number of records saved correctly. Or you can automatize this by using Aggregate components with sum function.
Regards,
Please sign in to leave a comment.
Comments 1