Try enclosing 0 between quotes like this:
if sTargAmt < '0':
fdmResult = "24000"
I'm not sure with the explanation but since you are getting the AMOUNTX as a string, you should either convert it into an integer first OR you can try the method above.
1 person found this helpful
I would suggest you use SQL Script rather than Jython one
CASE WHEN AMOUNTX < 0 THEN '24000' END
easier and performs better
'0' worked! That was easy to change. Thank you.