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


Kemahiran: Pengaturcaraan C, Pengaturcaraan C++, MMORPG, Memasang Skrip, SQL

Lihat lebih lanjut: 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

Tentang Majikan:
( 91 ulasan ) Cairo, Egypt

ID Projek: #1584712

4 freelancers are bidding on average $30 for this job


hi I can do this for you in C

$30 USD dalam sehari
(5 Ulasan)

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

$30 USD dalam sehari
(0 Ulasan)

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

$30 USD dalam sehari
(0 Ulasan)

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

$30 USD dalam sehari
(0 Ulasan)