Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2005
    Posts
    25

    Unanswered: Current Schema, Current Path

    Hi!

    I has a problem. I need set values on CURRENT SCHEMA and CURRENT PATH automatically for any connections to the database.

    Can somebody help me if it is possible?

    Thanks

    P.S.
    I can not execute SET CURRENT SCHEMA and SET CURRENT PATH after each
    connection. I need something like trigger!

  2. #2
    Join Date
    Oct 2005
    Posts
    109
    default schema (or default sql id) is always the userid. Thats it.
    To change it after connecting you have to set it.

    Whats wrong that you can't do it ?
    What application interface are you using?

    In ODBC there is an option to set the CURRENT SCHEMA or CURRENT SQL ID as an parameter under advanced settings in your Configuration Assistant/ODBC data source manager/db2cli.ini .

    Also: specifying fully qualified table names in your application might help.
    Juliane

  3. #3
    Join Date
    Jul 2005
    Posts
    25
    Thanks a lot

    I am using ODBC

Posting Permissions

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