Re: External Stored Procedures / Library Lists

Alan Campin already described a way for the program to do it, which is essentially what we do. He recommended a command to set libraries using a table with libraries and identifiers; our environment is pretty simple, so I just past a parameter to the
program ("test" or "live") that triggers a series of RMVLIBLE and ADDLIBLE commands (I like to RMVLIBLE first just in case -- that way I know I end up with the libraries I care about in the right order).

That program may just be a wrapper (I like using RPG, but CL would work fine), or, if it's simple enough, it may do the whole thing. I just make all the file opens in the progam user controlled and open all the files after setting the library list.

I'm calling the SQL from Domino agents, so I can pull the parameter from a profile document in the Domino database, and it works really well. My test databases all have the value set to "test" and the live ones to "live", and the code in both is exactly
the same.

HTH . . .


Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> writes:

Shouldn't we be talking about how to set the library list via an SQL
connection? (Which should certainly be possible!)

Or how to write a CL wrapper for the stored procedure that (perhaps
based on a parameter) sets the library list before invoking the RPG?

Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA 01376
413-863-4357 x444
mnaughton@xxxxxxxxxxxx