DSXchange

You probably should take that error to your support provider. Is the 5.8 version of SunOS listed as being officially supported?

Already been discussed. Search.

You certainly are allowed to restart a checkpointed job with different parameters, but it will log an extra message about the fact that they are different. Now, whether that will work properly or not based on your jobs is a whole 'nuther kettle of fish.

Yup, the moment someone replies you cannot delete. And you don't need to click submit twice to double or triple post, it happens automatically when there's a delay posting. If the 'Submit' doesn't immediately complete, I always go back and check the thread for duplicates and delete any it decided to...

Kryt0n wrote:Certainly trimming and uppercasing will reduce it a touch

If a 'touch' is around 75% then I agree.

I would think that if one were on an MPP or Massively Parallel Processing system, one would know it. Dollars to doughnuts you are on an SMP system.

Seems like many of the checks could be simplified if you stripped spaces and up-cased the value before checking, then you could do one check rather than the four you are currently doing.

I was thinking that if the number was small enough, one could create that many output links from a transformer and then merge them back together after that.

You just run it again if you want it to restart from the point of failure.

OK, then reset it is.

Resetting an Aborted Sequence clears all the checkpoints, so it would start over from the beginning. Run it without the reset as long as the status is 'Aborted/Restartable'. And there's a dsjob option of -run -mode RESET if you need to reset one from the command line. Note that it doesn't actually r...

If you are writing XML to your dataset, then you need to be using the XML Output stage. And no, you need to split the field before you generate the XML.

Mostly not work.

Click the Help button in the OCI stage then go to the 'Connecting to an Oracle Database' section, there's an explanation there. More would need to come from your DBA.

Do you know what the maximum installment count can be?

You are reading XML? Writing XML? Both?

Regardless, that 'split' will need to happen either in a Transformer or in a custom XSLT in an XML stage.