setdata

Overwrites some or all of a large object (LOB).

Syntax

setdata(locator_name, offset_value, new_value)

Parameters

locator_name – is a locator that references the LOB value you are modifying.
offset_value – is a position within the LOB to which locator_name points. This is the position where the the SAP ASE server begins writing the contents of new_value. The value for offset_value is in characters for text_locator and unitext_locator, and in bytes for image_locator. The first character or byte of the LOB has an offset_value of 1.
new_value – is the data with which you are overwriting the old data.

Examples

Example 1 – The final select statement in this example returns the string “SAP ABC/IQ/ASA” instead of the original string, “SAP “ASE/IQ/ASA”:

declare @v text_locator
  select @v = create_locator
    (text_locator, convert(text, "SAP ASE/IQ/ASA")
  select setdata(@v, 8, "ABC")
  select return_lob(text, @v)

Usage

setdata modifies the LOB value in-place. That is, the SAP ASE server does not copy the LOB before it is modified.
If the length of new_value is longer than the remaining length of the LOB after skipping the offset_value, the SAP ASE server extends the LOB to hold the entire length of new_value.
If the sum of new_value and offset_value is shorter than the length of the LOB, the SAP ASE server does not change or truncate the data at the end of the LOB.
setdata returns NULL if the offset_value is longer than the LOB value you are updating.

See also deallocate locator, truncate lob in Reference Manual: Commands.

Permissions

Any user can execute setdata.