DSXchange

I just mean "CR/LF" as in a Carriage Return / Line Feed pair rather than a literal if that's what you tried. Sometimes you need the hex values or "\r\n" or who knows what. Or just play the @FM field mark game Ray posted.

Rather than the grep, what about using ls -m which generates the output in a single comma delimited string?

Not sure exactly what you are trying but the record delimiter on Windows is two characters: a CR/LF pair.

Yay me! :D

Sorry, didn't even look at the actual code for sense making.

Dang... been a long time but try:

I was assuming the child / sub-sequences were checkpointed as well...

What is your target? Saying "DataStage" there doesn't really mean anything. To verify that the extraction is the bottleneck, add a contraint out of the transformer of @FALSE so nothing passes to the target and then see what the speed is.

Make sure your child sequences abort as well when there's a problem. That will be communicated upstream so your main sequence can be aborted as well. Then a restart will find its way back down the rabbit hole to where it needs to restart no matter how deep it needs to go.

Yup, already noted that. However, a default value will only help if you leave the column out of the DML. If you send a NULL, that's what it will attempt to insert.

Specify for us what kind of "null handling" you want to do and then perhaps people can let you know if there is a way to handle that under RCP.

There are no "performance impacts" for using checkpoints in a sequence job. And I can't imagine the need to re-invent the wheel or the additional complexity that would add when almost literally all you have to do is check a box. Everything will automatically get a checkpoint but you do hav...

Right, what you posted doesn't change my answer as that is what controls file creation permissions.

What "Oracle database" are you upgrading? Are you talking your XMETA repository, your target / sources, both?

http://en.wikipedia.org/wiki/Umask

Set per user. On UNIX it is typically set in a user's .profile but for DataStage it would be in the dsenv file.

Excellent... thanks for posting that.