In a transfomer i'm using this logic
Code: Select all
if svMKeys=1
then if (vers_Tr01.C_CDACOLONNE="DOSSIER" AND vers_Tr01.L_CDADATASTRING="TXREGATTENDU")
then svDataNumber
else svcol22
else if (vers_Tr01.C_CDACOLONNE="DOSSIER" AND vers_Tr01.L_CDADATASTRING="TXREGATTENDU")
then svDataNumber
else setnull()
The first time svcol22 is set to null (that what i want) , the next time it change from null to 0.00 with the warning Numeric string expected of the appropriate decimal precision . Use default value.
Numeric string expected . Use default value.
In other word i'm losing the value of svcol22 when it contains a null
A easiest example
Code: Select all
if @INROWNUM=1 then setnull() else svcol22
Peek_559,0: RowNum:2 svcol22: 0000000000000,00
Peek_559,0: RowNum:3 svcol22: 0000000000000,00
Thank you