setdata

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

Syntax

setdata(locator_name, offset_value, new_value)

Parameters

Examples

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.

Related reference
create_locator
locator_valid
return_lob