DSXchange

DIGITS is a Transform, not a function. Makes the whole 'MCN' thing easier to understand in the job.

As I noted.

It's also good to note that it seems to be a platform specific issue, not a version specific one. Some platforms on the troublesome versions worked and some didn't. Best to check carefully beyond what it shows in the log as it always looks good there.

Spend a little time thinking about it. What marks the end of this part number? You'll need to find the position of 'P/N' in the field. Four positions from there the actual part number starts. It ends... where? The next space you encounter? The end of the string? A comma? All of the above? You're goi...

Unless you are very familiar with how this all works, I'd suggest you not manually create the expressions. Let the tool do it for you. Do you have an .xsd for this? That would be best but you can use a sample of the output file as well. Use the Manager to import that metadata and see what it generat...

I would think it's safe to say, that if you get a specific error stating something isn't allowed that you can't do it.

As long as your version of DataStage actually supports using job parameters in the Parameters field. There is a well know and often mentioned bug in some of the early 7.x versions where job parameters are translated in the log but are actually sent raw (untranslated) to the command itself. Seems to ...

Thanks, always forget that little tidbit.

I gave command as /DataStage/751A/Ascential/rm *.blp That didn't work because it's not a valid UNIX command. What would happen if you typed "/DataStage/751A/Ascential/rm *.blp" from the command line? Unless you have copied the 'rm' command such that it lives in that Ascential directory, you're goin...

'009'

If you have a single Sequencer set to Any in that flow, then the first time any one of the 1-4 jobs completes all four A - D jobs will run. Subsequent completions of the numbered jobs will trigger nothing. That's the way the Sequencer works, like a gate. And you tell it when to open the gate by sett...

The link is missing the "www" in front of the "dsxchange.com".

Search the forum for that particular error, it should turn up.

Why not just have a friendly chat with a System Admin? Or one of your coworkers there that speaks UNIX?

Source your dsenv file in the script.


That will ensure the enviroment is correct for the script.

Drop a Transformer next to the Reference Hashed file and link them together. Add a stage variable so the compiler won't complain. Set the constraint to @FALSE so no rows go down the link, as the mere fact it is there will open the hashed file. Make sure your metadata is correct in the link, but the ...