I have a requirement, where my First job gives me a time stamp. Now I need to pass this on to the Second job , where it wuill be used in the ORA stage Query .
How do we go about this, thanks
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
Moderators: chulett, rschirm, roy
Hi Vinay,vinaymanchinila wrote:Hi,
I have a requirement, where my First job gives me a time stamp. Now I need to pass this on to the Second job , where it wuill be used in the ORA stage Query .
How do we go about this, thanks
In the hash file define two colums DummyKey and Date. In Job 1 hardcode the value of Dummy Key to 1 and pass your date value to column Date. In the sequencer Call UtilityHashLookUp using RoutineActivity Stage. It asks for three arguments values. Use the following:vinaymanchinila wrote: 1)Now how do I use the UtilityHashLookUp(HashName,'Value',1) in the seq
You can read help about this routine. As far as I remember you can pass the values to the parameters using pipe (|) delimited string.2) How do I pass this value to the second job activity.