Good morning. i have a server job, writing to oracle tables.
if a record is rejected, i send mail using DSSendMailTester(), and set the error variable in the userStatus with setUserStatus()...
in the sequence job, i get the userStatus and pass it to a new server job, because i want to get the userStatus's value and write log to the db...
now the situation is: new job, with a variable with errorLog value... how can i get that variable and write it to db?
That variable will be passed as an Parameter to the next job. You can make you of the parameter in transformer stage or even in you DB stage to write in to table.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
ok... that was what i thought... but... the new server job... can not have just transformer and oci stage...
should have something before transformer.... what?
It is possible to have a job which has a transform stage as the source. You need to define at least one stage variable and also put a constraint on the output so that the job finishes. But this is exactly what you are trying to do - write just one record to your database with the value of the parameter.
The simple solution as been shared. If you are not comfortable, you can aslo have another DS stage with user defined query as "SELECT #PARAMETER# from DUAL"; and pass this value to the consecutive DB stage.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Using a User Variables activity upstream of these other activities is an erudite manner in which to expose the values to those other activities in a consistent and easily-maintained way.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.