Default decimal separator and Parallel Transform Functions
Posted: Wed Nov 28, 2018 8:08 am
Hi!
I'm new to DataStage Development, and I need to change the default decimal separator used on datastage to '.' dot (either at Job or project levels), since the OS default is ',' comma. But after changing the configuration as described on the documentation, the Num function used in a Transformer stage is still using ',' comma (the default as defined by the OS). For instance, Num(3,01) evaluates as 1 (True) but Num(3.01) returns 0 (False). What am I doing wrong? Is there something i'm not understanding or considering?
Any help I can get is welcome and appreciated.
Thank you!
PS: These are the steps I followed to configure the decimal separator:
https://www.ibm.com/support/knowledgece ... Level.html
https://www.ibm.com/support/knowledgece ... Level.html
I'm new to DataStage Development, and I need to change the default decimal separator used on datastage to '.' dot (either at Job or project levels), since the OS default is ',' comma. But after changing the configuration as described on the documentation, the Num function used in a Transformer stage is still using ',' comma (the default as defined by the OS). For instance, Num(3,01) evaluates as 1 (True) but Num(3.01) returns 0 (False). What am I doing wrong? Is there something i'm not understanding or considering?
Any help I can get is welcome and appreciated.
Thank you!
PS: These are the steps I followed to configure the decimal separator:
https://www.ibm.com/support/knowledgece ... Level.html
https://www.ibm.com/support/knowledgece ... Level.html