Hi frnds ....

I m tryting to execute statement :

set current sqlid= ''SCHEMA_NAME'

But it is giving me error that




------------------------------ Commands Entered ------------------------------
set current sqlid='mb1';
------------------------------------------------------------------------------
set current sqlid='mb1'
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0567N "mb1" is not a valid authorization ID. SQLSTATE=42503



So what i need to do ?
Does it has anything to do with USERID ???

try

SET CURRENT SQLID= mb1

or

SET CURRENT SQLID= "MB1"

(well, I don't know whether you need capitals or not, on z/OS capitals is ok)

No ...it is not working ....
It not CASE sensative

well, I was not quite right I guess,

we use :
SET CURRENT SQLID = 'DBSYSADM'

over and over and it works fine (z/OS)

still - if you check the SQL code:

SQL0567N "<authorization-ID>" is not a valid authorization ID.

Explanation:

The authorization ID specified by "<authorization-ID>" is not
valid for one of the following reasons:

o It begins with "SYS", "sys", "IBM", "ibm", "SQL", or "sql".

o It contains characters other than a through z, A through Z, 0
through 9, and the three special characters (#,@.$).

o It is delimited and contains lower case letters.

o It is GUESTS, ADMINS, USERS, or LOCAL.

o It is PUBLIC preceded by the keyword USER or GROUP in a GRANT
or REVOKE statement.

So better no lower case letters ...

Hi


o It contains characters other than a through z, A through Z, 0
through 9, and the three special characters (#,@.$).


this rule allow schema_name as 'mb1'
It was working finr till 2day noon (GMT+4.5 hrs) .....
But now it is giving some errors

Hey ,
got it working !

It was related to case + some Database Administration stuff.

The USER must have previlages to set sqlid on a particular Schema .

Anyways ... Thanks for replies