FORCE_WITH_UR
- FORCE_WITH_UR
- Specifies whether FM/Db2 should always append
WITH UR
to any SELECT statement processed by the FM/Db2 editor. The default is N; FM/Db2 does not add theWITH UR
clause to SELECT statements processed by the FM/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 FM/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 FM/Db2 users are unable to specify either option.
- The
WITH UR
clause is automatically added to any SELECT statement processed by the File Manager 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 FM/Db2 users are able to change either option to their preference. The values selected by each user are applied to FM/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)