DSXchange

Thanks for the reply. I did think the same but just wanted to see if I was missing any possible setting to make the sequence end gracefully rather than abort. That is a master sequence with no parent and needs manual intervention to reset.

Anyway, thanks for your interest.

I did un-check the 'automatically handle exceptions'. No problems with restartability.

Hi Ray, If it is something that I can control, that would have been my first choice. To give more details, there is a job that is being called under ex handle stream. If that job is not in runnable state or if one of its parameters can't be set, that results in exception under the ex handle stream. ...

Hi, I have spotted a strange, but not impossible, scenario in a job sequence that has a user defined exception handler. When an exception occurs in a job sequence, the code under exception handler gets executed. But the interesting thing to know is what happens when the code under that ex handler en...

You can try doing it in Unix (assuming that your environment is unix). an awk script can brilliantly come to your rescue. But if you need column names, that will be complex as the selection of columns is dynamic here. You can alternatively use Craig's solution which has been discussed in one of my p...

Thanks all for the replies. Sorry for late reply. @Ray, It's a nice approach. I was also thinking of column export and import stages for similar approach. I was wondering, however, how can we generate record of column names in the latter case (while processing row#1). I guess for this we might need ...

Hi All, I have a specific requirement of adding a column conditionally to a target sequential file. I am looking for the best way of doing it. To put it in detail, the source can have two columns Col1, Col2. Col1 always goes to target file (which is a sequential file) but Col2 should be added to tar...