Skip to Content
0

how to add schema to ConnectINIt parameter

Feb 05 at 06:41 PM

31

avatar image
Former Member

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

I would appreciate any help on this.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Jacqueline Rahn
Feb 05 at 09:39 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Jacqueline Rahn
Feb 05 at 09:42 PM
0

  • 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')
Share
10 |10000 characters needed characters left characters exceeded