Anyway to use local Subprocedures inside sql as host variables? uzumymw_

​Hey guys,
I have a SQLRPGLE program that has a subprocedure getMessage() which extracts a message from db based on a message ID.
I am using json functions to build a json_object consisting of some other data as well. I want to call getMessage() from sql.
I have tried using procedure names as host variables but that doesn’t work. I don’t want to create a seperate udf for this specific purpose.
Any thoughts?
submitted by /u/uzumymw_[link][comments] Read More 

Verified by MonsterInsights