[CLOSED] Dirty Read using TABLE FILE requests

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6487002096

May 21, 2018, 10:08 AM

Doug

[CLOSED] Dirty Read using TABLE FILE requests

I know that we can use a 'dirty read' using SQL Passthru.

How do we do that in a TABLE FILE request in 8201+?

Reference: Previous Focal Point post

Thanks, Doug

This message has been edited. Last edited by: FP Mod Chuck,

In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206

May 21, 2018, 10:23 AM

FP Mod Chuck

Doug

Depending on the adapter there are settings for Isolation level to read uncommitted. In the adapter administration guide you can see if the adapter you are using supports it.

Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats

May 21, 2018, 12:40 PM

Doug

Thanks Chuck,

We'll check it out as needed and update this accordingly.

See you at Summit?

~ Doug

May 21, 2018, 06:32 PM

FP Mod Chuck

No, I am a part time employee just monitoring FP so I will not be at Summit. Enjoy it though it is always a great event.

Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats