1

I am trying to write define a results field. first I want to divide 2 qty’s on hand inventory/units. Then I want to drop the whole number and only keep the decimal. Goal is to find how much partial product is left.

first expression is qtyinc. b.ifpic/c.igiord
second expression partial. substr(qtyinc,10,2)

I get a substr value not allowed.

I assume my second expression is incorrect but how do I write it to only keep the decimal numbers and throw out the whole

1 Spice up
2

What language? Most have a MOD operand that will return just the remainder of a division, in IBM landscape may also have a %REM operand for same.
The problem in your post is that you are trying to use a string operation (substr) on a numeric result. Cast that numeric result as a string and then substr() would work.
But that is irrelevant if you go the operand route and calc just the remainder in the first place.

3

How would you write the expression for the %Rem? would it be %Rem qtyinc? This is in wrkqry/AS400

4

%rem is not allowed in wrkqry. Returns error in expression at the %

5

Yeah, that %rem isn’t sql or wrkqry but another ibm namespace, but depending on the database you are accessing, it probably DOES have the MOD (modulo) operator of some sort. At least it should if it is any flavor of sql database. On MSSQL server, though, the MOD operator is just ‘%’, so 5 % 2 = 1. Curious if that works in wrkqry, not really familiar with its eccentricities or how to escape the % sign if needed.
But if it is, say, a mySQL database those will take MOD(x,y), x MOD y, or x % y. Any would work. You’ll have to check what the modulo operator is for your database queries.

6

It’s DB2 if that means anything to you. It does not like the % sign.

7

DB2 should be MOD(x,y) for the remainder.

8

That does not work either

9

Are you using RPG for programming in AS400 or is it a different language now?

I don’t know if a contact I have is still active on here and help or if they have left it all behind.