DSXchange

OK, pending rant averted. [sigh] As noted, when you get all desperate for a solution and the community of volunteers here aren't coming through for you fast enough, open a case with your official support provider. That why your company pays them a rather tidy sum of money. BTW, I'm not here for the ...

No, you won't. What makes you think you need to aggregate each column separately? Send them all in the link and only one record will come out since you'll be doing no grouping, only summing and counting.

IsValid() can check for a number of different things, including valid integer values. Search the forums for examples.

Nick, you just repeated everything from your existing post on this problem into a brand new thread. There's absolutely no need for shenanigans like that which just leads to confusion with disjointed conversations going on in two different places.

http://www.dsxchange.com/viewtopic.php?p=305800

Bejeebus, stop whining and have some patience. Oh, wait. !!!

Twice in one post.

Yes, a search for "NuTCRACKER not properly installed" here seems to imply a faulty installation that needs to be repeated.

Your best source for "routine material" are the ones supplied with the product. Navigate to them in the Manager and double-click on them, that will give you access to the source and documentation for each. There is no book other than the BASIC pdf in your Docs directory, but since basically BASIC is...

i have 3 seq file stage and all of them are in the append mode writing to the SAME file. Your problem, in caps, above. Sequential files, anywhere on any platform or tool, are by their very nature sequential media and that name was not chosen lightly. While they can support multiple reader processes...

That's really all there is to it, a pointer to the top level installation folder that lower level components can then leverage. Nothing more mysterious than that.

From the Manager in your dev project, export the Stage Type in question (CUserVarsActivity) to a .dsx file and then import it into your production project. I would think that would fix whatever is wrong, if the only problem is that one stage type and something more sinister isn't going on.

Either bump the maximum number of sessions allowed or don't run as many jobs at the same time.

Send those columns to an Aggregator, sum, write to a different file and then append (cat x >> y) that file to your 'main' file after job.

So, two problems?

1. Define two fields on the link from the transformer. Set their derivations to the Job Parameters. Use in the proc.

2. Your proc is broken, either by bad params or faulty code I would guess.

I don't believe that you can do what you want without "using sequence or changing the calling jobs", something that you've ruled out. So it seems like it may be time to change the rules.

Post your SQL.