FOR_BROWSE_ACCESS clause, can this be set on universe connection

[Former Member]

Hello:

We are using HP Neoview as our database, and I would like to know if there is a way to include the FOR_BROWSE_ACCESS cluase in every sql that is sent to neoview.

Is there a way to make this special condition apply to the universe connection?

For Browse access only tells the Neoview database not to exclusively lock the database while quering it for results.

And example of how the statment syntaxwould look.

SELECT a

from t046a where b=1

UNION

SELECT b from t046b where a=2

for browse access;

Is there a way to set this "for browse access" to apply to all queries?

[PPaolo · Accepted solution]

In the Universe properties try setting the

END_SQL parameter to

"for browse access;"

all queries generated by Web Intelligence with that Universe will have the text appended to the end of the SQL.

Regards

PPaolo

[Former Member]

found END_SQL universe parameter which allowed it to work.

I did not have the syntax correct when I tried it the first time.

After replacing the default "blank" value in END_SQL.... I was able to accomplish this.

Problem solved.