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.