Problem:

With ALL08M30 there are three new commands used for setting up a stored procedure environment.

Resolution:

These are typically issued by a COBOL program and the values are retrieved from IDE settings.  You can execute these SQL statements from any client including the ODBC driver to instruct the server how to set up the environment for the stored procedure.

SET XDB_STORED_PROC ANIMATE [ON|OFF]

SET XDB_STORED_PROC PATH string-constant

where string-constant is something like "C:\\LOADLIB;C:\\MY PROJ\\LOADLIB"

SET XDB_STORED_PROC ENVIRONMENT string-constant

where string-constant is something like "TESTCOVER=C:\\FOOBAR & ENTRYNAMEMAP=C:\\MFUSER\\PROJECTS\\MYPROJ\\MFENTMAP.DAT"

With the ENVIRONMENT string-constant, multiple environment variables can be sent by delimiting the variables with the & character.  In the previous example, both TESTCOVER and ENTRYNAMEMAP are set within the same SQL statement.