DSXchange

Hi, I never faced this problem before. I have a job where 3 sequential files are passed through a Link Collector, and the output is a hashed file (essentially to remove duplicate rows). SeqFile1--------\ SeqFile2--------LinkCollector----------HashedFile SeqFile3--------/ Each file has 2 input column...

I wish I had the fortune to have DS7.5.x available. My jobs are based on 7.0 version, hence there are no start loop and end loop stages. Besides, the number of iterations are not known, and so multiple instances may not be a good idea. In another post, Arnd suggested that I do it using creating my o...

Arnd, Thanks.
Yeah, that seems to be the only option that I have now. Will get back with the results.

gateleys

I have to extract 30 distinct columns if I used hash file what can be happen to the remaining rows Is there any option other than writing the sql query and the sinario is if if we want to select distinct on 25 columns what can we do any help would be apprecieated. thanks in advance. Why are you con...

Use StartLoop and EndLoop activities in a job sequence, toggle the file names as advised in the other post, and provide an appropriate exit condition. Thanks Ray, but StartLoop and EndLoop stages are not available in DS7.0. Is there any other way to run the same job, say n number of times, with var...

As you've described the algorithm the output file must end up exactly the same as the input file. Can you clarify the algorithm to show how it might be different? Ray, what I need to do is append the content of file2 (flat, with 1 column) to the tail of file1(flat, with same column definition as fi...

I have a job where both input and output are sequential files with the same column definitions- file1 ---->Tfr ----> file2 How can I run this file multiple times (say 10 times), one after the other such that in every other run, the 2 files switch their names? That is, if the above shown design is my...

The example that I had given was to abstract the other complexities of my logic from you guys and just exhibit the process wherein I was having a problem. In my job, the input file and the output file WILL BE different. But, right now, I just wanted help in splitting the file and appending them agai...

I have a file containing a single column with values such as- x av y b cc mmmm a x mmmm lt mmmm z mmmm ax The file needs to be parse such that the input is split into 2 files when the value 'mmmm' is encountered first time- 1st file -------- x av y b cc mmmm and the 2nd file ------------ a x mmmm lt...

Why don't you just go ahead and check if the services are up without restarting the server?

gateleys

There is some addition to this. There are three jobs that give a different compilation error each. RT_CONFIG89 RT_CONFIG90 RT_CONFIG91 I guess understanding the RT_CONFIG error shall sufficient. These hashed files keep runtime configuration information of the jobs 89, 90 and 91. There could be a pe...

Thanks for getting back and sharing your solution with the forum.

gateleys

Yes. When running in Designer, it runs correctly. Data flows between the stages. Don't have access to Informix right now, so can't test it on my side. But, i remember being able to view data even with the Informix stage. Or it could be that your jobs are parameterized with environment variable PROJ...

Thanks to All Gateleys, this is working fine. Can I get the name of the job also which has been failed in the sequence. The logic works in a way that if ANY of the jobs fail, then the sequence aborts. So, it is irrespective of which job failed, and hence the name is inconsequential. However, on the...

Have worked with Informix via ODBC, and had no issues. But, with the Informix stage, are you getting the data (although no view) passed on to downstream stages?

gateleys