Closed

Convert SQL function into RPG (or C) language

This project received 4 bids from talented freelancers with an average bid price of $30 USD.

Get free quotes for a project like this
Employer working
Project Budget
N/A
Total Bids
4
Project Description

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.

Thank you!

drop function [url removed, login to view]
go
create function [url removed, login to view]
(
-- Datetype for @rate changed to float
@rate float,
@periods smallint,
@principal numeric(20,2)
)
returns numeric (38,9)
as
begin
declare @pmt numeric (38,9)

declare @WK_periods float,
@WK_principal float,
@wk_One float,
@WK_power float

-- Convert data for calculation
select @WK_periods = @periods,
@WK_principal = @principal,
@WK_One = 1

select @pmt =
round(
-- Do all multiplication before division
( @WK_principal * (@rate*power(@WK_One+@rate,@WK_periods)))
/ (power(@WK_One+@rate,@WK_periods)-@WK_One)
,9)

return @pmt

end

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online