DSXchange

Thanks for the replies

i am developing one more sequence which it checks the status of seq1 and runs job A.

i am trying to use UtilityGetRunJobInfo in routine activity and get the status of seq1. Unable to do it.

Can somebody help in this regard?

job1->job2-->job3-->job4
job5-->job6-->job7
job8-->job9

after job2 3 branches comes out of it.

whenever sequence exits (success or failure), i need job A to run then exit

let me rephrase my question.

i need to run Job A when all the jobs in the sequencer is successful or if any of the job aborts.

thanks.

Hi All,

i have 15 jobs. which runs in 5 streams(different branches) in a sequencer.
suppose a job aborts in the sequencer then i have to run job A and then exit sequence.

how can i achieve this?

Thanks.

it is required to debug sequence. Job2 takes around 1 hour to complete. so whenever i correct the errors in aborted sequence and run again, job2 starts again. so i wanted to skip this job and check other jobs in the sequence. as you said, i have used a additional trigger output to the to skip the job.

Hi All,

i have a sequencer as below:

job1--->job2--->job3

After job1 i want to skip job2 and run job3

how can achieve this?

thanks

removed the files in scratch space but still it gives 99% full (previously also)
Am i missing anything?

yes ray, you got it right all my jobs were fine during development.

when testing with large volume of data jobs are aborting with SIGBUS errors.
and scratch space full.

Is there any way i can clean up those files (aborted jobs) and run the jobs again.

Hi All,

How can i clear the files under scratch directory
can i just remove with rm command?

Thx

100 Marks....!!!!

After a close analysis here what is happening exactly. input sequential file property record delimiter = new line character field delimiter = tab final delimiter = none (the last row ends with a new line character) file has 3 columns col1 col2 col3 output produced has 4 columns with column col4 adde...

output produced is having an extra column Col4 and output produced is as below. Col1 Col2 Col3 Col4 c1val1 c2val1 c3txtval1\n c4val1\n c1val2 c2val2 c3txtval2\n c4val2\n c1val3 c2val3 c4txtval3\n c4val3\n c1val4 c2val4 \n c4val4\n this error is coming only for the last column. Column datatype is var...

A transformer in the job should reject NULL records for a tab delimited sequential file with the following format: Col1 Col2 Col3 c1val1 c2val1 c3txtval1 c1val2 c2val2 c3txtval2 c1val3 c2val3 c4txtval3 c1val4 c2val4 \n We have a problem when rejecting Values from Col3. When the first character of th...

[quote="sreelalpp"]Hi, I need to merge two sequential files. The records from the master link have duplicates in the Merging Key field. In the records in the update link has no duplicate. In the output, I am getting merged data only for the first among the duplicate entries in the master l...

[quote="sheema"]I thougt instead of using the Tbl2 as lookup the performance would be better if i do a left outer join.[/quote]

Check for duplicates. if both the files has duplicates then left outer join produces more rows.