BusinessObjects Board

FETCH ONLY WITH UR

server administration Web Intelligence 6.x Servers
#1

Has anyone been able to successfully add the uncommitted read to the .prm files on E6 for the END_SQL parameter for use with db2? I tried adding it to my db2udb.prm file, but it’s not picking it up?

dchrista :us: (BOB member since 2002-08-19)

DB2 SQL Problem to include WITH UR
#2

Did you see this thread (read it to the end)?

Andreas :de: (BOB member since 2002-06-20)

#3

Thanks for the info. I actually found what I was looking for in Designer with E6.5.1. If you go into the File-Parameters, there’s a new Parameters tab in the menu where you can set additional parameters at a Universe level. END_SQL is one of those parameters, and it’s set to “blank” by default. As soon as I built my parameter to “FOR FETCH ONLY WITH UR” in this setting and re-deployed my universe, it worked as I expected. I have mixed thoughts on whether this will be a good thing to set at a universe level rather than a global setting, but all-in-all, it’s just a change of workflow for a Universe developer. :smiley:

dchrista :us: (BOB member since 2002-08-19)