DB2 allows the specification of an 'isolation-clause' on the select statement. Our DBAs has requested us to use this clause on many select statements so that DB2 won't escalate a lock to a table lock. (These queries are mainly used to select data for some of our reports that we have to generate from a batch job).
I haven't figured out how to specify it with jOOQ. Specifically, we have to add ' WITH UR' at the end of the sql statement (UR = uncommittted read). I am using a SelectQuery object to dynamically build the query. Obviously I can get the SQL string when the query is build & append it myself; but I was hoping for a more elegant solution. Would creating a custom QueryPart be the way to accomplish what i need? -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
