using String Math functions

asitagrawal · Post by **asitagrawal** » Sat Aug 18, 2007 8:22 am

Hi,

I am facing problems with Decimal numbers arithmetic operations, esp for (23,3) format decimal numbers.

The forum search results guide me to the usage of String Math functions, like, SDIV and SMUL etc.
I tested them using a routine and the results are correct.

But I am unable to use these functions on the Field Derivation. Can't I use them there ? Can these be used only using a Routine ?

chulett · Post by **chulett** » Sat Aug 18, 2007 9:10 am

I've only used them in routines. I'm not positive but have you tried just typing them in and compiling the job regardless of the fact that it stays red in the derivation?

Sometimes that's just a matter of the function not being in the DSParams file so it's not recognized as valid but works fine when the job runs. And sometimes it just means you need to put it in a routine.

If the job compiles and runs, put an annotation in on the subject so no-one freaks out when they find 'invalid' syntax in the job.

asitagrawal · Post by **asitagrawal** » Sat Aug 18, 2007 10:20 am

Thanks Chulett !!

The job is getting compliled without any warnings.. So now I am proceeding with using SDIV etc
Is it not possible to add the function to DSParams ??

Has any one faced such requirement ?

chulett · Post by **chulett** » Sat Aug 18, 2007 10:25 am

Sure... a search on DSParams should turn up conversations where that is discussed. Just a simple exercise with a text editor.