DSXchange

Ray, aren't there like five (numbered 0 through 4) or some such semaphores available to the job control code? The only thing I ever recall using them was Ken Bland's "Job Control Utility" code where he'd pass stuff via them but it wasn't anything I ever ended up using on my own in all of t...

What delimiter did you specify in the Start Loop stage? A pipe? Sorry, not sure what else to say other than the only time it goes back around again is when it hits a delimiter.

Then it goes back to your "list of things" to iterate through - you have an extra delimiter at the end that you need to trim. That causes it to loop one last time with no valid values to parse.

No.

Not a syntax error, that "bad state" error means it is not runnable - could mean not compiled but more than likely it is already running. You said earlier that it was a multi-instance job but I don't see any evidence of that in the command string, if it was you would need to pass the Invoc...

You need to build them into the command line. Off the top of my head the syntax is -param parm=value for each name / value pair you need to pass in. So you would need three of them on the command line along with everything else. If that is what you tried and is not working for you, show us the exact...

Okay... can you detail for us how this "first stage" is retrieving the field called "ROW_ID"? It sounds like it simply doesn't exist in the table in this new schema you created, have you verified that it does? Did you not get any kind of ORA error as well? I thought at first you ...

So, which one of these two contrary statements in your original post is correct? How to convert 60 digit Alpha Numeric value to 40 digit? How to convert 60 to 40 digit Alpha numeric value?? For the first one, I'm not aware of any way to somehow "convert" a sixty character string into a for...

That doesn't make it Massively Parallel... how about answering my first question? The second was somewhat rhetorical. However, on the chance that your topology is an issue please clarify for us what you mean by "two box machine".

What he said.

Windows MPP?

To run a job in the loop without waiting, you can't use a Job Activity stage to run them as they have the wait built in. You'll need to use dsjob from the command line without either of the wait options to accomplish that.

All your error is saying at the moment is that your XML file cannot be found. Is that path correct and does the user your job runs under have the proper permissions required to read it?

It's been three months now... have you not engaged your official support provider to help with this?

Any routine that does not return a zero is assumed to have failed when you have that "Automatically handle" option enabled. You have to explicitly handle the "failure" so it (the sequence job) doesn't think it needs to handle it for you. The help text for that option explains the...