DSXchange

Waiting to see the list_readu result...

Dump the score of your job and find out where this particular operator is coming from.
Then it might make more sense to try to diagnose/explain the message.

No.

Looks like a case of "they're generating the alert no matter what", I guess in case the user supplies a string that can't be converted to decimal. Safely ignorable in my opinion; I'd emplace a message handler to demote its severity because of that.

It is not strictly the compiling that is different, it is the code that is generated that is different.

What is the data type of the input column? If this can potentially contain a a string that is too large for Decimal(17,2) - in this case more than 18 characters long - then DataStage will always generate this alert warning.

How do you know that the stage variable derivation is working? You strip the "," characters in the inner Convert() expression then attempt to convert "," to "," in the outer Convert() expression. What problem (if any) are you having with the derivation expression? What is it producing? What do you e...

All the answers are there. All you need to do is buy yourself a premium membership, or get your employer to buy it. Premium membership is not expensive, at less than 30c (Rs12) per day. It gives you access to the entirety of premium posters' posts, as well as other benefits. Premium membership is on...

R/3 is not the same thing as ECC, which is probably why the question was asked. Please refrain from answering unless you do actually know the answer. Please also refrain from replying in an untimely fashion unless you have something new to contribute. And please don't "shout" (all capitals). It's qu...

That is simply incorrect.

However it is necessary in the Sequential File to state how NULL is to be represented in the file. This can be done globally (for all fields) or on a per-field basis.

1) No effect. Something failed, no rows were affected. The message itself tells you this. 2) Maybe but probably not. The Oracle table has one of these data types, your job has the other. Some Decimal values are compatible with Double (for sufficiently small Double and appropriate Decimal precision) ...

Maybe but, if the data type is Char(10) - which the framework calls string[10] - it will immediately be refilled with the character specified by the APT_STRING_PADCHAR environment variable. The effect is that you can't really trim a Char data type. Trim is only really sensible with VarChar. The fram...

You're joking, surely? Every UNIX command can be used with DataStage. Nor did you specify where you want them sent. Bill Gates, perhaps, to try to convince him that UNIX is best? Sheesh. There is no-one on the DSXchange user list called plz. I suspect you meant to use the word "please". We strive to...

If -wait or -jobstatus is specified dsjob -run does not return until the job status changes from "Running". In your example JobName1 runs first, then JobName2 through JobName6 run simultaneously. JobName7 runs only after JobName6 finishes (irrespective of the run status of JobName2 through JobName5)...

To get nulls use left outer join rather than inner join, and make sure that all pertinent columns (including on the intermediate and right inputs) are marked as Nullable.