DSXchange

Is Business Glossary Anywhere installed on your local machine?

Is Business Glossary Anywhere installed on your local machine?

pandeesh wrote:you can easily look into the DS Administrator for project level handlers

True, but which of them is associated with which job (if any)?

Change the quote character in the Sequential File stage from double-quote to None.

There is nothing fully automatic, because it is not necessarily the case that every job will need to be changed. For example, a stage that selects particular columns from a table may not need to select the newly-added columns at all. The correct approach is to perform a where used analysis on the ta...

Please post the full error message, including any error code.

bind19 or bind20, depending on your version of DB2. This is a DB2 command, not a DataStage command.

One way is to look at the job logs. If there is a message handler (or more than one) defined, then there will be an entry soon after the "job starting" event. If any message handler is invoked there is another log entry near the end of the job run summarising which message handlers were in...

What version? Recent versions allow multiple readers per node to work with delimited formats.

How did you define the receiving column (in DataStage metadata) when you used the RAWTOHEX function?

Given that the original is CHAR(18), I'd suggest CHAR(36) or VARCHAR(36) would be appropriate - you'll be getting two hex characters per byte.

No, because the External Filter stage has to do something with the data on its input link and generate data onto its output link. You could possibly add another command in the pipeline, for example

Yes. You can do this in a job sequence. The other two values can be derived using the expressions that give the job parameters in a Job activity their values.

See it you can track down a Powerpoint presentation called Xmeta Repository 8.5 non-cluster V2
It is associated with PMR 27361,102,616 so you may be able to obtain it through IBM support.

Don't forget to schedule time to check prerequisites on the Linux machine and to perform a health check afterwards. Both of these can be undertaken using ISALite.

TMPDIR is the name of an environment variable.
$TMPDIR is a reference to the current value of that environment variable.

Any variation to that is laziness or ignorance.