isolation-clause (select-statement query)

The optional isolation-clause specifies the isolation level at which the statement is executed, and whether a specific type of lock is to be acquired.

Read syntax diagramSkip visual syntax diagramWITH RRlock-request-clauseRSlock-request-clauseCSUR
  • RR - Repeatable Read (row-organized tables only SQLSTATE 42858)
  • RS - Read Stability (row-organized tables only SQLSTATE 42858)
  • CS - Cursor Stability
  • UR - Uncommitted Read

The default isolation level of the statement is the isolation level of the package in which the statement is bound. When a nickname is used in a select-statement to access data in IBM® family and Microsoft SQL Server data sources, the isolation-clause can be included in the statement to specify the statement isolation level. If the isolation-clause is included in statements that access other data sources, the specified isolation level is ignored. The current isolation level on the federated server is mapped to a corresponding isolation level at the data source on each connection to the data source. After a connection is made to a data source, the isolation level cannot be changed for the duration of the connection.