BusinessObjects Board

"For Fetch Only" in connection definition

building semantic layer
#1

I was sure that this had been discussed before, but I couldn’t find it. I’m looking for the proper syntax to add “for fetch only” at the beginning of each query. In this case, the database is DB2.

Am I remembering incorrectly? Is this possible? I thought it was.

Thanks.

Dave

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

DB2 configuration
Query Performance on DB2 UDB
ZABO-DB2 uncommited reads
How can I add '(nolock)' to my SQL code?
#2

Not sure if I understand your question. In case you want uncommitted reads…

C:\Program Files\BusinessObjects\DB2\db2v5en.prm

Add the below line…

END_SQL=FOR SELECT ONLY WITH UR

or

END_SQL=FOR FETCH ONLY WITH UR

Dinesh.

Dinesh (BOB member since 2002-08-22)

Using Hints with SQL Server 2000
#3

You understood perfectly. Thanks!

Dave

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

#4

Hello Dave,

This may be a wild shot, but if you are using the DB2 middleware CLI/ODBC you can set the isolation level to uncommitted read instead of the default cursor stability (configure the advanced settings of the DSN)
Never experienced much of a difference though)

blom0344 :netherlands: (BOB member since 2002-09-04)

#5

Thanks, I’ll pass that along to my client. It can’t hurt to check.

Dave

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