The lld_delete() function

This function deletes the specified large object.

Syntax

API

mi_integer lld_delete(conn, lob, error)
   MI_CONNECTION*               conn; 
   LLD_Locator                  lob;
   mi_integer*                  error;

ESQL/C

int lld_delete (lob, error);
EXEC SQL BEGIN DECLARE SECTION;
   PARAMETER ROW lob;
EXEC SQL END DECLARE SECTION;
   int* error;

SQL

CREATE FUNCTION LLD_Delete (lob LLD_Locator) 
   RETURNS BOOLEAN;

conn: The connection descriptor established by a previous call to the mi_open() or mi_server_connect() functions. This parameter is for the API interface only. In the ESQL/C and SQL versions of this function, you must already be connected to a server.
lob: A pointer to an lld_locator row, identifying the object to delete.
error: An output parameter in which the function returns an error code. The SQL version of this function does not have an error parameter.

Usage

For large objects other than smart large objects, this function deletes the large object itself, not just the lld_locator row referencing it. For smart large objects, this function does nothing.

To delete a smart large object, delete all references to it, including the lld_locator row referencing it.

Return codes

For an API function, returns MI_OK if the function succeeds and MI_ERROR if it fails.

For an ESQL/C function, returns 0 if the function succeeds and -1 if the function fails.