DSXchange

I believe I used the word 'fun' not 'hard'... it is a great learning experience. And a fun problem to solve. :wink: Oh, and interesting factoid about DSWaitForJob(), I wonder if that has always been the case? For whatever reason and after that had-coded job control, it's something I ever realized or...

These are the times when I wish I still had a DataStage gig so I could test crap like this for myself. Ah, well. Still, nothing about this is unsolvable and I'm sure they will get the proper output... eventually.

Exactly, this all comes down to writing your own job control code. That's the only way to fire them off and not start to wait until all have started. The fun part of that would be keeping an array of handles in memory and checking them all properly over and over.

harikumar wrote:to link1
111
222

to link2
111
333

As noted, this explains nothing and just parrots your earlier example. Please detail for us in words how you decide what goes where.

I have cded into the directory where the dsjob is stored. i am trying to run it from there. Is this not right?? More to it than that, as Ray indicated. If you are in the directory and that directory (or the ".") is not in your PATH then it still won't find it. You would need to use: ./dsj...

OK, got the ASCII conversion thing wrong never having done any from a dang mainframe in my life (or any other native EBCDIC source). Sue me. :wink: And I went with the whole "00A" example because that was what was reported (and since recanted, I see) in the post I was responding to. Heck, ...

Yes, it would seem so. How does "iterating through a loop" get anything running simultaneously? Adding those two stages inside the loop doesn't change the basic functionality of the loop at all, each iteration still runs one job and it all happens in a sequential fashion.

I believe it should, no-one has contradicted that yet but you really should be reporting / confirming this with your official support provider - both for your current version and any future versions. Horse's mouth and all that.

Please read the original post a little more carefully.

I know how to run in loop (runs sequential) or run manually using invocation id 1 to 5. But I want to automate to run the number of times simultaneously depending on the passed parameter ParmA value.

That 'electrical plug' icon is the generic one it falls back on when it can't find the proper one to display. We've seen it when there are memory issues on the client - does this happen to other people as well or just you? If it's just you, sometimes getting out of everything and rebooting your PC c...

That's the problem, they want all records for the key to be written to the same file, not just the last one which is what they are currently getting via the Folder stage. I thought the Folder did all records automatically, so either there's a bug in their version, it has somehow been implemented inc...

In other words, you convert them.

No 'reference' condition required, make both lookups as normal and then check the results, typically in a constraint. You want records where the first lookup succeeds and the second one fails.

Use the appropriate conversion function, they're all listed in the online help and the pdf documentation. They all start with "StringTo" by the way.

Google is your friend.