Dynamic SET CURRENT SQLID Help!

["Maculsay, Gary R" <Maculsay.Gary@EMERYWORLD.COM>]

I'm a DB2/OS390 DBA who has been asked to develop an interface between Brio
Reportbuilder and our DB.  I've played around a little with the SQR
language, but I'm very green.  Here's my problem:

We have many different environments, or schemas, in our development world,
along with production.  We will only have two connection logon id's
available, one for the development environments, and one for production.  To
be able to keep the table references in the begin-select clause unqualified,
it would be nice to be able to use the SET CURRENT SQLID statement.  I find
this works fine, if I hardcode the value of the sqlid, and if I use the
begin-sql block within the begin-setup block.  If I place the begin-sql
block anywhere, it passes syntax, but does not work - it's as if the
begin-select statement has already been parsed and it uses the connection
identifier as the owner of the tables - not want I want.

Ultimately, I would like to pull the value of the sqlid from an environment
variable, and then issue the SET CURRENT SQLID statement using this value,
but this requires a  LET, and I can't use that in the begin-setup, etc.

I'm so confused.

Thanks for any ideas!