Re: Stored procedure test environment

[CRPence <crpbottle@xxxxxxxxx>]

On 08-Jun-2015 10:39 -0600, Justin Taylor wrote:
> A test user ID sounds like an easy way to set the proper library
> list.
>
> What about choosing the proper stored procedure (SP)? Right now, all
> our SP calls include the schema name. I seem to recall I you don't
> specify a schema, DB2 tries to use the user ID as the schema. We
> don't [want] to have to change the calls between test and production
> environments.

  Unqualified names on CALL and use either the default path with *SYS 
naming or use SET PATH with *SQL naming when the default path of the 
authorization Id is undesirable [likely to be undesirable when testing 
while using a setup that is established according-to User Profile name, 
except in the unlikely case the non-test environment already operates 
according to the UsrPrf name].