I have a job where using transformer update a table and after the update need to send a notification to other server using FTP with a table name. This FTP should go when ever the update is successful on Table. How do we achieve this, i tried using Link Output variable validating Update Link SQLSTATE = 0 , it didn't work. If i don't provide any constraints FTP process is working with the number of records which got updated in Table, but my requirement is just sent one row with Table name.
Thanks
FTP a string only when Update is Successful!!
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Consider setting up the FTP as a shell script invoked from an after-stage or after-job subroutine. Within that routine you can make your success tests to decide whether to invoke the script. The table name can be supplied (possibly as a job parameter) through the Input Value field when invoking the subroutine, and as a command line argument ($1) to the shell script.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.