DSXchange

Hi,
I have a server sequencer job that is running in a loop, creating invocation name by the $counter.
The sequencer builds of 3 jobs:
1. write to an hash file one record.
2. Simple transformation job reading from DB and writing to another.
this job get a parameter from the function "UtilityHashLookup" to read the record written in the first job.
3. Update status/

most of the times, the process works well. Some times I see that the job starts and finished without doing anything, and the job executed without invocation name.

I think that the problem is in the routine.

Thanks.

What routine? Why not leverage USERSTATUS to pass the value, if you think that's the issue?

ps. UtilityHashLookup() will fail silently if not used properly, test your logic elsewhere to ensure it's doing what you think it is doing.

actiview wrote:Hi,
I have a server sequencer job that is running in a loop, creating invocation name by the $counter.
The sequencer builds of 3 jobs:
1. write to an hash file one record.
2. Simple transformation job reading from DB and writing to another.
this job get a parameter from the function "UtilityHashLookup" to read the record written in the first job.
3. Update status/

most of the times, the process works well. Some times I see that the job starts and finished without doing anything, and the job executed without invocation name.

I think that the problem is in the routine.

Thanks.

Hi,
You dint mention details about the job that is writing to hash file.
But you can think of embedding that logic in the second job itself.
If you provide more details, we can help you.