Re: multi-tenant issues with stored procedures

On Mon, Nov 27, 2017 at 3:43 PM, <dlclark@xxxxxxxxxxxxxxxx> wrote:

For the second step, we have a method in place which allows us to
switch between "tenants" without having to log out and back in. We
extended this to our stored procedures by passing a "tenant" id as the
first parameter and call QCMDEXC to execute the same switching process
that would be used for an interactive session. What this switching
process does is to replace the current job's library list based on the
initial library list found in a job description that corresponds to the
"tenant" id. We use the QWDRJOBD API to extract the library list from the
job description and the QLICHGLL API to apply that library list to the
current job.

The only issue that might remain is files left open from the
previous "tenant".

​Dave,

So the RPG program/procedure used as an external stored proc is calling a
process to change the library list?

Are you using programs, procedures​, or both as external stored procs?

Does your library list change only change the data librar? (So every
tenant runs the same version of programs/procedures?)

Didn't you have an issue with data being returned incorrectly from an
existing ODP that you worked around by moving to dynamic SQL?

Thanks!
Charles