DSXchange

Take a look at your data record based on the widths in the record schema. That these widths are specified means that this is how DataStage is parsing the record. In particular D will take only two characters from the record, and be padded with 28 pad characters.

No.

Renaming a category does not change each object's internal reference to that category. That's why renaming category is not even supported in the GUI.

You have executed DELETE FROM table WHERE condition and no row in the table meets the condition. DB2 has returned an informational message showing you that this has obtained. Because it is an "unusual" event, DataStage logs it as an alert (warning).

I think you mean "plug in". Yes you can - there is a Plug-In Stage Writers Guide available through your support provider. The stage itself is written in C (external to DataStage) and compiled and linked (again external to DataStage). It must be packaged and registered into DataStage. If you also wan...

You could also send email from the before-job subroutine that I mentioned earlier.

Your longer description is the correct way to do it, as evidenced by the fact that it works. Please mark the thread as Resolved.

Problem with grep/awk approach is that dsjob -logsum gives two lines per log entry.

Not if the Job activity has a Failure trigger leading the Notification activity.

No.

World Wildlife Fund ?

You could read it as a VarChar (or maybe even Char) and convert it to a conventional timestamp format.

(Which advice I am sure I have given in the past on DSXchange.)

That's a good trick. There's no such certification for DataStage mentioned on the IBM web site - currently the only version 8 certification mentioned there is Information Analyzer.

Not is like somebody's name - IS somebody's name.

And you are correct that Wurlod can be derogatory - just ask my former girlfriend!

Depending on what your criteria are, you could create a before-job subroutine in which setting ErrorCode to a non-zero value will cause the job to abort before it processes any rows.