Isolation on sysmasters database

We have an application which uses the sysmasters database to retrieve lock information - who and on what table. We use a join between the sysmasters and tables in our application database, for example: SELECT INITCAP ( MAX(us.fullname) ) INTO l_user FROM caps:pres_event_group peg, sysmaster:syslocks sl, sysmaster:syssessions ss, caps:users us WHERE peg.peg_serial = gPeg AND sl.tabname = "pres_event_group" AND sl.rowidlk = peg.rowid AND sl.dbsname = "caps" AND sl.owner = ss.sid AND us.login = ss.username; caps is the application database. In all cases we use SET ISOLATION TO DIRTY READ. However, as this only applies to the caps database, if there are locks on the sysmasters tables then we get an error back. What we would like to do is set isolation to dirty read on sysmasters as well. We use 4GL, SPL and VB for client/server access. Does anyone know how we can do this? Graeme Norton Senior Developer, Granada Media 0113 2227457 ********************************************************************** Please visit the official Granada website at www.granadamedia.com for the latest company news. This email and any files transmitted are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error, please notify postmaster@granadamedia.com Thank you. **********************************************************************