Append set command to the query

[system]

I have to append set command to the query before SELECT statement and I need to do it everytime the query is generated from the universe.

For example here is the output I need from self generated query from Business Objects.

set quoted_identifier on
SELECT
Table__20.a,
Table__20.b
FROM
“123” Table__20

The SELECT query gets generated without any issues but the thing in red is the problem.

Is there any way I can implement this in Universe level?

---

chetanmaniar (BOB member since 2008-02-06)

[system]

Any takers for this???
I will put it in different way… How can we setup sybase connection to have property quoted_identifier on when setting up Universe Connection to Sybase. Sybase version is 12.5.0.3.
I do see connection properties which has option to setup Binary File Size, password Encryption and ConnectInit.
I checked Sybase.prm file as well but that is not helpful either.

Please let me know if you have any pointers.

---

chetanmaniar (BOB member since 2008-02-06)

[system]

This topic shows a conversation about using ConnectInit to set some initial parameters:

120×120 10.4 KB

Hi all, My question resides around whether or not it is possible within Designer to automatically set the NLS values at execution of a query. I need to set the following values every time a query is run over a specific database: dbms_application_info.set_client_info(906); execute immediate 'alter session set nls_language="AMERICAN"'; Is it even possible to do this and if so how. The one thing I don’t want to do (and I don’t even know if this would work) is to create a dimension in the unive…

---

Dave Rathbun (BOB member since 2002-06-06)

[system]

Thanks Dave. That was very useful. I have just put “set quoted_identifier on” inside ConnectInit and it worked.

---

chetanmaniar (BOB member since 2008-02-06)