Thank you very much for the response. I know it's possible, but I'm hesitant to implement it in my environment. Technically, this is a very good solution, but difficult to implement among the many JMP users I support. They will need to convert to custom SQL in the early stages of query construction to partially test their query. At this early stage, MANY bugs appear (ex: missing key which involves a cross join with millions of records selected in error). This is the phase where they most need protection “with ur”. And to get it, they would have to use a one-way process and forgo using the Builder.
I'm in discussion with the DBA to see if we could do something about the DB2 client app. on the PC. It might be possible to add an "uncommitted read" command in the connection tool config. This would remove the need for the "with ur" in the SQL statement. This would allow safe use of the excellent JMP query generator.
I'll mark my question as "accepted", because it's technically valid and it tells me that there aren't more options in JMP to reach my goal.
If we succeed to solve the problem by a config to the db2 client, would you be interested to know it?
Thankyou very much, Best regards