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 HCL Informix® DataBlade Developers Kit User's Guide.

For more information about the CREATE TABLE statement, see the HCL Informix Guide to SQL: Syntax.


Copyright© 2019 HCL Technologies Limited