Convert SQL function into RPG (or C) language

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]


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)



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 =


-- Do all multiplication before division

( @WK_principal * (@rate*power(@WK_One+@rate,@WK_periods)))

/ (power(@WK_One+@rate,@WK_periods)-@WK_One)


return @pmt


Skills: C Programming, C++ Programming, MMORPG, Script Install, SQL

See more: convert sql rpg, the c language, sql programming language, s programming language, rpg programming language, programming sql, programming in sql, programming function, original programming, needs for c# programming, language programming, go programming language review, function programming, function in programming, float programming, float c programming, create a programming language, c programming power, c programming function, programming language go, go programming language, all programming language, sql programming, Sql 2012, rpg

About the Employer:
( 91 reviews ) Cairo, Egypt

Project ID: #1584712

4 freelancers are bidding on average $30 for this job


hi I can do this for you in C

$30 USD in 1 day
(5 Reviews)

Hey I am a computer engineer and I have IBM DB2 certification and can surly convert your SQL function to C code.

$30 USD in 1 day
(0 Reviews)

Hello! I'm good at c so I can convert it to c language.

$30 USD in 1 day
(0 Reviews)

That's easy, I'll do it in C and guarantee max quality work.

$30 USD in 1 day
(0 Reviews)