Results 1 to 6 of 6

Thread: current SQLID

  1. #1
    Join Date
    Dec 2005
    Posts
    16

    Red face Unanswered: current SQLID

    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 ???

  2. #2
    Join Date
    Oct 2005
    Posts
    109
    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)
    Juliane

  3. #3
    Join Date
    Dec 2005
    Posts
    16
    No ...it is not working ....
    It not CASE sensative

  4. #4
    Join Date
    Oct 2005
    Posts
    109
    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 ...
    Juliane

  5. #5
    Join Date
    Dec 2005
    Posts
    16
    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

  6. #6
    Join Date
    Dec 2005
    Posts
    16
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •