DSXchange

Hi, We redid it from scratch keeping 3 jobs in parallel and then only get to know that more than 3 jobs its failing otherwise not. Thanks & Regards Koti Rebuild your Job Sequence from scratch, and see if it give you the same error. Is anyone of the jobs renamed or missing, i think its not abel t...

thumsup9 wrote:Is anyone of the jobs renamed or missing, i think its not abel to attach the job. Can you please post the complete error message.

Hi
The jobs are not renamed neither they are missing.
And the error we got is what i already pasted. It is not giving any more information.

Thanks & Regards
Koti

Hi all, We have a sequence where we used to run morethan 3 jobs in parallel stream. And it used to work as we want. It used to work across all our environments (like dev,test....). But now the same sequence is failing with some fatal error like below. "SSeq..JobControl (fatal error from JobCont...

Hello Kim The reason for my trying out this approach is to fetch all the sequences that calls a job directly or indirectly. For instance if a job A has been called in SeqQ and SeqQ has been called in SeqMain1 then if JobA is passed as an argument to this routine it should return SeqQ,SeqMain1 If it ...

kduke wrote:You maybe looping back on yourself. So you are in an infinite loop.

hi

I was hoping that this statement would coz control to return to the calling function and therefore end the loop

If Index(x,"0 records",1) Then
Return(Ans)
End

I dont see why it wud continue in a loop

thnx

As noted earlier, it's then up to you to put the data together in such a fashion as to identify sub-sub-sequences and lower. The query does not do that. It can be done with a routine. Hello I have been trying to fetch the all calling sequences ( direct/indirect ) of a job using a routine with the S...

Hello I have successfully excuted cmds related to the computation of statistics in the Oracle OCI stage (Datastage Server Edition) however while trying the same in the parallel edition's db2 stage I'm getting the following error... Tgt_Stg_Na_Gif_Event_Hist_Vin_Tab,0: Warning: jGIF_STG_GIF_EVENT_HIS...

hello I've been trying to install the Multi Client Manager to allow for multi versioned clients...however during the installtion it asks for : "Please enter the username and password to be used by the service. This user must have administrator access to the local machine." Even though I pu...

How can I compare current record with previous record in stage variable? Can stage variable store previous record value or it is reset for every new record? I tried searching but couldnt get to the right topic ...If any one has the link or keyword to search would be of great help. Life of the stage...

ArndW wrote:using "JobName.InstanceName"; perhaps that will work in this case as well.

JobName.InstanceName

Where Instancename can be treated as a variable to be concatenated with the Jobname name.

Search this forum - Lots of posts on this

ArndW wrote:

dwblore wrote:..WHOLE message quoted

Lesson learnt

Always realize better ways of doing things out here

Thnx

Hi Had thought on similar lines: what I could also do is this: from the present lookup file De HJ Create a new lookup -> New School 1 De;HJ;... add a dummy column to the source with the value of 1 do a lookup on the new lookup file and bring in the school column - which contains all the lookup value...

Still I couldnt understand how you manage to lookup RobDeW with HJ? We're fine with the first match in our case - the 'HJ' is not needed Considering that the first lookup value was lets say 'UI' then since UI and HJ are not contained in the source records(school field) - we wud get a null result se...

Does this work? WHERE key LIKE '%?%' Note that you can not do this with a hashed file, which can only do WHERE key = 'value'. Hi Unfortunately its the revers we're looking for WHERE key LIKE '%?%' key values - De HJ while values coming into ? DeNobili RobDeW I was trying something like this: SELECT...

Hello This is my requirement ================= Source Seq File ================= School Address --------- +++++ Qwds POLS DeNobili BVDFD RobDeW DFDSF Xrewq ================ Lookup Table in DB2 ================ SchoolName -------------- De HJ Output School Address --------- +++++ DeNobili BVDFD RobDe...