Figure 4-52 shows an example of search results when a data guarantee level is specified. UAP1 is a UAP that searches the PRODUCT table, UAP2 is a UAP that inserts data into the PRODUCT table, and UAP3 is a UAP that updates PRODUCT table data. The numbers 1. to 4. show the execution sequence of UAP1, UAP2, and UAP3.

Figure 4-52 Example of search results when a data guarantee level is specified

When the UAPs are executed as shown previously, the search results of 1. and 4. of UAP1 are as shown as follows. In this example, UAP1, UAP2, and UAP3 are all executed at the same data guarantee level.

Data guarantee level	UAP1 search results		Explanation
	1.	4.
0	TV 100 VIDEO 80	TV 100 VIDEO 200 AMPLIFIER 50	Although the same data is searched twice in the same transaction, the search results of 1. and 4. are different. Because the data is not guaranteed, the processing for 2. and 3. is reflected in the search results for 4.
1	TV 100 VIDEO 80	TV 100 VIDEO 200 AMPLIFIER 50	Although the same data is searched twice in the same transaction, the search results of 1. and 4. are different. Although the data is guaranteed during search processing, the data is no longer guaranteed once a search process ends. Consequently, the processing for 2. and 3. is reflected in the search results for 4.
2	TV 100 VIDEO 80	TV 100 VIDEO 80 AMPLIFIER 50	Although the same data is searched twice in the same transaction, the search results of 1. and 4. are different. When the data is searched in 1., the TELEVISION and VIDEO rows are guaranteed. However, because the data is not guaranteed in 2., the processing of 2. is reflected. However, the processing for 3. enters wait status because the data is guaranteed, and the processing for 3. is not reflected in the search results for 4.