You can do arithmetic with numeric fields and decimal constants (+n and −n) using the operators MIN (minimum), MAX (maximum), DIV (division), MUL (multiplication), MOD (modulus), ADD (addition) and SUB (subtraction). The order of evaluation precedence for the operators is as follows, but can be changed by using parentheses: 1. MIN and MAX 2. MUL, DIV and MOD 3. ADD and SUB

Joined: 15 Feb 2005 Posts: 7130 Location: San Jose, CA

Posted: Sat Sep 05, 2009 5:53 am Post subject:

Quote:

Can we do the divide operation in sort? For ex, I have to divide the numeric column by 4 for particular record.

You should have given more details. However, as an example, if you want to divide the ZD value in positions 11-15 by 4, you could use DFSORT control statements like this: