Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Posts
    34

    Unanswered: Setting SQL ID woes

    You have all helped me so much before, another question:

    I read you can set the current SQL ID so instead of:
    select * from sqlID.table
    you can:
    select * from table

    This is done (I read) by doing this:
    set Current SQLID='sqlID';

    Don't know if this is correct because when I execute:
    set Current SQLID='sqlID'
    I get an error "sqlID" is not a valid authorization ID'

    but if I execute select * from sqlID.table, it works.

    What am I doing wrong with setting the current sqlid?
    Thanks

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Setting SQL ID woes

    I think it should be

    SET CURRENT SCHEMA=sqlID

    HTH

    Cheers

    Sathyaram

    Originally posted by elomon
    You have all helped me so much before, another question:

    I read you can set the current SQL ID so instead of:
    select * from sqlID.table
    you can:
    select * from table

    This is done (I read) by doing this:
    set Current SQLID='sqlID';

    Don't know if this is correct because when I execute:
    set Current SQLID='sqlID'
    I get an error "sqlID" is not a valid authorization ID'

    but if I execute select * from sqlID.table, it works.

    What am I doing wrong with setting the current sqlid?
    Thanks

  3. #3
    Join Date
    Oct 2002
    Posts
    34
    I tried:
    SET CURRENT SCHEMA='sqlID';


    and got:
    SQL0104N An unexpected token "SCHEMA" was found following "".

Posting Permissions

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