Search found 2 matches

by AxBad
Fri Jan 25, 2008 9:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookink for a compendium of Message IDs (-> Messag Handle
Replies: 1
Views: 1165

Lookink for a compendium of Message IDs (-> Messag Handle

Hello everybody, does anybody know, how to get a complete listing of all existing message IDs including their meaning ? Maybe even clustered by reasons causing the messages or by any other meaningful criteria. I'm not talking abaout the content of SYS.MESSAGE, I'm talking about message IDs to be col...
by AxBad
Fri Jan 25, 2008 3:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: StringToDecimal
Replies: 7
Views: 3748

Hi,

did you already try Modify Stage using this specification :

column_out:decimal[8,0] = decimal_from_string(column_in)

If you don't specify [length,scale], you'll get unexspected results like e.g. NULL.

Hope this helps
Axel