FORCE_WITH_UR
- FORCE_WITH_UR
- Specifies whether ZDT/Db2 should always append
WITH UR
to any SELECT statement processed by the ZDT/Db2 editor. The default is N; ZDT/Db2 does not add theWITH UR
clause to SELECT statements processed by the ZDT/Db2 editor.Specify Y when there is a requirement to reduce the number of Db2® locks taken as a result of the use of the ZDT/Db2 editor.
- Y
- When Y is specified there are two effects:
- The Concurrency and Keep Locks editor options, which appear on the seventh editor options panel, are not displayed, and all ZDT/Db2 users are unable to specify either option.
- The
WITH UR
clause is automatically added to any SELECT statement processed by the Z Data Tools Db2® editor. This includes the Browse (B), View (1), Edit (2), Basic Prototyper (4.1), Advanced Prototyper (4.2), Enter, execute and explain SQL statements (4.3) and Edit and execute SQL statements from a data set (4.4).
- N
- When N is specified:
- The Concurrency and Keep Locks editor options, which appear on the seventh editor options panel, are displayed, and all ZDT/Db2 users are able to change either option to their preference. The values selected by each user are applied to ZDT/Db2 editor sessions arising from the Browse (B), View (1) and Edit (2) functions.
- Select statements entered using the following functions are not
affected:
- Basic Prototyper (4.1)
- Advanced Prototyper (4.2)
- Enter, execute and explain SQL statements (4.3)
- Edit and execute SQL statements from a data set (4.4)