DSXchange

I'm curious who's version of SQL you're working with that takes care of NULL comparisons "implicitly"?

A "truncate load" doesn't change the fact that you have to handle the partitioning properly to avoid the lock issues you are seeing when running in parallel. Try using a hash partition over the fields that make up the primary key for the table.

The one without the invocation has the status "Finished". And it shows mixed lines from the 2 sequences when they run in parallel. That means you ran the MI job without an Invocation ID which is not something you generally should be doing, as while it runs no "real" invocations ...

Not sure how I can be "wrong" when the they in this forum is me. Can't answer your question as I don't know. I for one would never use anything like what you're calling "long" invocation ids nor ones that matched the name of the job itself. I prefer to keep them short, simple and...

That would imply to me that your partitioning is not correct. What have you specified?

If by that you mean that you think the Execute Command stage runs the command on the Client, you'd be mistaken... it runs it on the Server just like your routine does.

The Execute Command stage. It allows one to run something from the command line directly (like orchadmin) - no routine required.

The best way? Let the stage generate it so you get the bind parameters correct and then... tweak it.

If you still want some help with this, I'd imagine you'd need to post the Perl script you have that is attempting to run a DataStage job so we can see how it manages that (via dsjob I assume) and what is throwing the error.

"runscript"? Not something I've ever heard of.

The literal answer to your question is no, not out of the box - but that doesn't mean you couldn't have created one in your environment.

Yes, if you want to ensure that only successful lookups go down the link.

First, please don't "Reply with quote" all the time, there's no need to do that the vast majority of the time. Do it when it makes sense, otherwise use the perfectly lovely Reply to topic link that is always there as well. It will save me from much of the clean-up work I'm always needing t...

:idea: I edited your derivation and formatted it to better show the structure and then used 'code' tags to preserve it here. So, according to the code it should return a "5" if both H.2 = 'OS' and A.5 ='CJ'. Are you saying both do and yet it returns some other value? I'd suggest you step t...

OK. So what is "F4301"? If that's your source you'll need to leave off the "where" clause and let it stream everything into your job. Then the Hashed File lookup will do the four "equals" and you can check the results. After that you should just need your "if-then-...

Off you go to your own topic... Sorry ? Simple. You jumped on the end of someone else's post, not to help out but to add your own problem to the mix. That's frowned on here so I split your posts out and created a new topic that you now own and linked your first post back to the original jacked post...