** 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
** 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
Comment