EXECUTE FUNCTION SYSBldTstSBSpace(" "); statement
The EXECUTE FUNCTION SYSBldTstSBSpace(" "); statement
executes the SYSBldTstSBSpace() function, which
tests for the existence of the default sbspace. If you want to assign
the smart large objects in your DataBlade® module
to another sbspace, you can do so by adding the name of the sbspace
between the quotation marks: for example, the following statement
tests for the sbspace named sbspace1:
EXECUTE FUNCTION SYSBldTstSBSpace("sbspace1");
If
you want assign smart large objects to an sbspace other than the default
sbspace, you must also specify the sbspace name in the CREATE TABLE
statement: for example, the following statement creates a table with
the Poem smart large object and assigns it to the poem_space
sbspace:
CREATE TABLE Poems
(id integer,
poem_col Poem)
PUT poem_col IN (poem_space);
For more information about using the SYSBldTstSBSpace() function, see the Informix® DataBlade® Developers Kit User's Guide.
For more information about the CREATE TABLE statement, see the Informix® Guide to SQL: Syntax.