%DecDiv meta-SQL element

Syntax

%DecDiv(a,b)

Description

The %DecDiv meta-SQL function returns a number representing the value of a divided by b, where a and b are numeric expressions.

If the result needs to be picked up by a bind variable, pick it up using the Character type or PIC X(50).

Parameters

Parameter	Description
a	Specify the dividend as a number.
b	Specify the divisor as a number.

Example

%DecDiv(1000.0, :1) 

In the example, :1 is a bind variable in SQLExec PeopleCode.