The BLOB data of file 2 is extracted from the BLOB data (column C2) in row A that was stored in Addition update of BLOB data.
![[Figure]](figure/zu041302.gif)
- Explanation
- The SUBSTR scalar function is used to extract data from the starting position (byte (100
1024 + 1) = byte 102401) of the data column for file 2 in column C2 of row A. Only the amount of data equivalent to the length of the data column in file 2 (200
1024 = 204800 bytes) is extracted.