DSXchange

Don't kill anything you don't understand. There are better ways, beginning with issuing a Stop Job request.

From Director choose Cleanup Resources.

OK it was ExecSH. Can you inspect the job log where ExecSH posts the command that it executed, and verify that the job parameter references were resolved correctly? Post the command that was actually executed. Did the command execute correctly? Did the job finish OK? What happens if you execute this...

You can't in a job.

Even in a job sequence, you will need a fairly tricky set of nested condition activities inside a loop or two.

Hack the Repository. You did ask for the easiest. For me that would be the easiest. Next easiest is probably a global search-and-replace in an export file. Sounds like an opportunity to preach the benefits of strong metadata management (and a tool like IBM Business Glossary plus someone with very go...

But only up to volume 72 of Part XII - the rest is IBM Confidential.

Yen Buddhists are like Zen Buddhists, only much larger begging bowls.

(Terry Pratchett)
(not my name either)

What happens if you run that sed command over the file in UNIX, without DataStage in the mix? Are the internal spaces trimmed or unaffected?

Trying to isolate the location of the problem.

The subject specifies "in UNIX". I stand by my original assertion.

There IS a Quote function - I use it a lot.

Quote is not in DSParams, but you can put it there so that it should compile and run successfully. But DQuote or SQuote will serve as well for the current purpose.

Yes, of course it's possible. You need one Transformer stage to generate the stage variable value. That goes on the output link as an extra column along with all the columns from in input link. In a separate, downstream Transformer stage you perform the lookup, using the extra column as the referenc...

If you generate a report of the job (second tool from the right in Designer toolbar) the report will include all the constraints and stage variable and output column derivation expressions. That's all you can get out of DataStage because that's all that's in there. Unless, of course, you have been p...

Much is about to change. I'm in Dallas this week and learning about the plans. There will be a big announcement - and probably an overdue Newsletter - in July.

sqlldr: Command not found

Says it all. Your PATH environment variable does not include the $ORACLE_HOME/bin directory and/or your ORACLE_HOME environment variable is not set.

/opt/Ascential/Datastage/main/Ascential/DataStage/DSEngine/bin/aCC: Command not found You appear not to have an aCC command in the indicated location. You appear to have a composite or double pathname happening! Are you using parameters to specify the location of the compiler? Check the value of APT...

If you change a job that contains a Transformer or Build stage, but the change does not involve these stages, then a compile does not re-generate and re-compile the C++ code associated with them - there is no point. This means that the compilation finishes rather more quickly. A Force compile forces...