Quelqu'un utilise cette fonction et peut me donner des infos ? :D
Pb utilisation StringToDecimal fonction
Moderators: chulett, rschirm, roy
Pb utilisation StringToDecimal fonction
J'ai besoin de convertir dans une variable d'un stage Transformer un champs "varchar" en "decimal". Je pensais utiliser la fonction "StringToDecimal" mais Datastage ne la reconnait pas, elle apparait en rouge !
Quelqu'un utilise cette fonction et peut me donner des infos ? :D
Quelqu'un utilise cette fonction et peut me donner des infos ? :D
</a>(best to stick in English in this forum)
In Server jobs the conversion from a string to a decimal can be done differently. There are really no explicit data types and if you have a string that you wish to treat as a number you can just use it in a numeric function and let DataStage do an implicit conversion for you. This implicit conversion works very well but can cause problems if the number cannot be converted, i.e. "123:4". In that case you can use one of the options with the ICONV or FMT functions.
In Server jobs the conversion from a string to a decimal can be done differently. There are really no explicit data types and if you have a string that you wish to treat as a number you can just use it in a numeric function and let DataStage do an implicit conversion for you. This implicit conversion works very well but can cause problems if the number cannot be converted, i.e. "123:4". In that case you can use one of the options with the ICONV or FMT functions.