which scalar function has to be used to convert 18 character string to numeric value? Which scalar function has to be used to conver 24 character string to numeric value?
DB2 has about 150 scalar functions and for most of them it is clear what they do by name like abs() or substr(). I suggest you browse over them and see if anything fits, read the ones you don't understand. Maybe something like DECIMAL() or CAST(xxxx as DECIMAL(24,0)) would do trick, What do you think?