how to add schema to ConnectINIt parameter

[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.

[former_member193452]

• 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')

[former_member193452]

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