create DB2 Store Proc calling RPGLE get returns value
Budget: $15 – $25 USD
I need an SQL stored procedure that simply wraps an existing RPGLE program and returns customer information for data-retrieval purposes. The RPGLE routine is already written and delivers two character fields; the job here is to expose those two string values cleanly through a stored procedure that can be called from any standard SQL interface on IBM i.
Please write the CREATE PROCEDURE statement, handle the parameter mapping so both strings come back as OUT parameters (or a result set, if that proves more straightforward), and include a quick example of how I should invoke it from STRSQL or a JDBC client. Once I can run CALL mylib/getcustinfo (…) and receive the two strings without errors, I’ll consider the work complete.
Please write the CREATE PROCEDURE statement, handle the parameter mapping so both strings come back as OUT parameters (or a result set, if that proves more straightforward), and include a quick example of how I should invoke it from STRSQL or a JDBC client. Once I can run CALL mylib/getcustinfo (…) and receive the two strings without errors, I’ll consider the work complete.