Syntax

#include "milo.h"

...
mi_integer mi_lo_specget_sbspace(LO_spec, sbspace_name, length)

		MI_LO_SPEC *LO_spec;

		char *sbspace_name;

		mi_integer length; 


LO_spec
is a pointer to the LO-specification structure from which to obtain the sbspace name.

sbspace_name
is a character buffer into which mi_lo_specget_sbspace() puts the name of the sbspace for the smart large object.

length
is an integer value that specifies the size, in bytes, of the sbspace_name buffer.





 



Valid in Client Application?

Valid in Server Routine?

Yes
Yes

Important: Before you call mi_lo_specget_sbspace(), you must put storage characteristics into an LO-specification structure.

You can use any of the following to initialize the LO-specification structure:

• The mi_lo_colinfo_by_ids() or mi_lo_colinfo_by_name() function put storage characteristics that are associated with a particular CLOB or BLOB column in an LO-specification structure.
• The mi_lo_stat_cspec() function puts storage characteristics of an existing smart large object in an LO-specification.
• The mi_lo_specset_sbspace() function sets the sbspace name in an LO-specification structure.

Return Values

MI_OK	The function was successful.
MI_ERROR	The function was not successful; the LO-specification structure might be invalid.

In Chapter 3, "Handling Smart Large Objects," see "Storage Characteristics" for more information on the sbspace name of a smart large object. See "The LO-Specification Structure", and "Defining User-Specified Storage Characteristics" for information on how to use the mi_lo_specget_sbspace() function.