Skip to Content
avatar image
Former Member

how to add schema to ConnectINIt parameter

I was trying to add a schema to the present connection and not able to d it .

I would appreciate any help on this.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 05 at 09:39 PM

    Hi Anita, I have a wiki page with some examples HERE: Using Connectinit

    Also, for example in Oracle to Alter session

    alter session set optimizer_index_caching = 0;
    alter session set optimizer_index_cost_adj = 100;

    So it should depend on the database script.

    Hope that helps,

    Jacqueline

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 05 at 09:42 PM

    • For example:
    • The 'ConnectInit' parameter is used to declare database specific session statements only when the connection is established.
    • These statements are not parsed and should therefore be carefully set.
    • The syntax shown in the examples below is based on an Oracle database syntax:
      • At connection initialization, the current schema can be changed to the specified one: ALTER SESSION SET CURRENT_SCHEMA=scott
      • Same as above, but this time the schema will be accordingly the current session login: ALTER SESSION SET CURRENT_SCHEMA=@Variable("BOUSER")
      • At connection initialization, the oracle CLIENT_IDENTIFIER is changed to the specified one: BEGIN dbms_session.set_identifier('my identifier'); end;
      • Same as before, but this time, the CLIENT_IDENTIFIER will be accordingly the current session login(Be careful to use the appropriate quote): BEGIN dbms_session.set_identifier('@Variable('BOUSER')'); end; OR BEGIN dbms_session.set_identifier('logged user = @Variable('BOUSER')'); end;
    • The @Variable function is used to call the value assigned to one of the following types of variables:
      • BO username : @Variable('BOUSER')
      • BO username : @Variable('BOUSER')
      • Universe Name : @Variable('UNVNAME')
      • Document Name: @Variable('DOCNAME')
      • Data Provider name : @Variable('DPNAME')
      • Data provider Type : @Variable('DPTYPE')
    Add comment
    10|10000 characters needed characters exceeded