Midrange News for the IBM i Community

Posted by: Chris Proctor
Programmer Analyst
Columbia Sports Company
Portland, OR
Soft code the program name in an external stored procedure?
has no ratings.
Published: 11 Feb 2013
Revised: 14 Feb 2013 - 2226 days ago
Last viewed on: 20 Mar 2019 (4294 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

Soft code the program name in an external stored procedure? Published by: Chris Proctor on 11 Feb 2013 view comments(4)

Happy Monday! I was wondering, I have the following stored procedure created, thanks to Chris Ringer, and I want to soft code the program library somehow. You see, this stored procedure is going to be called by BizTalk and they only have the data library to access the stored procedure. If I take out the qualified program name, the software won't be able to find the program because it's in a different library.

Is there any way to handle this? Perhaps some kind of logic that knows where to call the program based on which data library is being used (if that can be retrieved)?

We have 3 environments, development, QA and production. The program could be in any or all, so I'd need to be able to to start with whichever environments data library the stored procedure is being called from and work my way up from there, looking for the program.

Maybe I'm making this too difficult. Any help would be greatly appreciated.


Return to midrangenews.com home page.
Sort Ascend | Descend