Practical SQL: Calling RPG from SQL, Part II

[venkateshv76]

** This thread discusses the article: Practical SQL: Calling RPG from SQL, Part II **
** This thread discusses the Content article: Practical SQL: Calling RPG from SQL, Part II **
** This thread discusses the Content article: Practical SQL: Calling RPG from SQL, Part II **

Joe,

Interesting article as ever coming from you. I always read your articles. I wonder should this be read as:

create function MCP.GETPRICE
(iItem char (15))
returns decimal(9, 4)
language sql deterministic
begin
declare oPrice numeric (9,4);
set price = 0; --> set oPrice = 0
call MCP.GETPRICE (iItem, oPrice);
return oPrice;
end;

I cannot see a declaration for variable "price" but there is reference to variable price?

Regards,
Venky

[J.Pluta]

** This thread discusses the article: Practical SQL: Calling RPG from SQL, Part II **
Thanks, Venky! You're absolutely right - that line should be setting oPrice to zero, not price.