You have chosen to sponsor your bid up to a maximum amount of .
There's a SQL function that needs to be translated into RPG (or C) language.
All the functionality in translated function has to be exactly as in the original. In the bidding, please mention the language you'll use for the outcome (RPG or C).
Below please review the original SQL function.
drop function dbo.PMT
create function dbo.PMT
-- Datetype for @rate changed to float
returns numeric (38,9)
declare @pmt numeric (38,9)
declare @WK_periods float,
-- Convert data for calculation
select @WK_periods = @periods,
@WK_principal = @principal,
@WK_One = 1
select @pmt =
-- Do all multiplication before division
( @WK_principal * (@rate*power(@WK_One+@rate,@WK_periods)))