FORCE_WITH_UR

Read syntax diagramSkip visual syntax diagram
                  .-N-.   
>>-FORCE_WITH_UR=-+-Y-+----------------------------------------><

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 the "WITH 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)
    ZDT/Db2 processes the SELECT statement from these functions without any additions.