DSXchange

Turn off the Compiler options you've turned on, that gives you explicit control over things. Then use the appropriate triggers to keep aborts from stopping things (Unconditional, for example) and perhaps a Terminator when it actually is time to shut things down. As noted, the problem will be restar...

Turn off the Compiler options you've turned on, that gives you explicit control over things. Then use the appropriate triggers to keep aborts from stopping things (Unconditional, for example) and perhaps a Terminator when it actually is time to shut things down. As noted, the problem will be restar...

How about it? Curious what my motivation would be to continue to help when honest attempts to do so get rated as 'Off-topic/Superfluous'? A little thin-skinned on my part, granted, but it's been one of those days. Sorry, I just tried this forum featured and accidentally click on the rate. I didn't ...

Not possible if you want the automatic checkpoint restart capability. You can make that happen with the proper triggers but then restarting it is on you as well. ... Yes,it's okay if it's not automatically restart from the checkpoint. but when I restart the sequence, I want it to restart from A whi...

So, by 'get aborted also' you actually mean 'do not run', yes? And if you truly want them to be independent, make them so - use two separate Sequence jobs. ... Yes, they do not run. and I want them to still running because they don't have any dependencies with the aborted job. actually this is not ...

is it a single sequencer that running a and d jobs above? no... job A and D using different sequencer but in a same sequential job and not dependent each other. is it possible tu use a sequential job like this? so what I want is, if: A is aborted C is finished then B is aborted but D and E is still...

But, the other problem which is raised is: my sequence will abort as soon as it reached the aborted job stage. Why is that? It should just restart the sequence from that point, reset the aborted job and go. What kind of 'abort' are we talking about here? Can you post the actual errors involved? :? ...

But, the other problem which is raised is: my sequence will abort as soon as it reached the aborted job stage. Why is that? It should just restart the sequence from that point, reset the aborted job and go. What kind of 'abort' are we talking about here? Can you post the actual errors involved? :? ...

Hi all, I have a question. is it possible for datastage sequence to run a job from certain checkpoint and trigger all the undone job? My objective is : when any of my job at the sequence get abborted, I want my sequence only restart from certain aborted job activities and trigger all activities whic...

Hi all, is it possible for us to create a job using sequential file stage, but what we want is, the file is only created if there is any output row to the file. if there is no output rows to the file (0 row), the stage should not create the file. if it is possible, what method should I use? and the ...

ray.wurlod wrote:It is not possible in a single parallel job. You would need two jobs. ...

Ok,thanks very much for the info

Hi, I have a question.. I have 4 stage in a parallel job. Sequential File -> Transformer -> ODBC Stage | v Sequential File Both output link from the transformer is stream link. My question is, it is possible for transformer to finish the output link to ODBC stage first, then continue to sequential f...

thanks God, everything has been solved.. :) if anyone find this post and facing the same problem, the solution is please check the directory and file name whether it is at the correct location. In my case, I have an additional / at my file path, and it makes the DS can't find the right file. Why the...

nope, my job only has 3 stages. 1. sequential file as source file which read file with pattern *customer.txt 2. transformer to map the columns 3. ODBC stage as the database target if I set the $APT_IMPORT_PATTERN_USES_FILESET = False, it works and I can view data n run the job.. but the problem is, ...

no, my filename is ended with .txt and there is only .txt file at the source folder

fyi, my file location is /transport/*tblcustomer.txt
thanks,
Caterin