Adding SYSBldTstSBSpace() to your registration script

About this task

To add SYSBldTstSBSpace() to your registration script:

Procedure

  1. In BladeSmith, define the DataBlade® module object that has a data type of BLOB or CLOB.

    For example, create an opaque type called BigType that has a member of type BLOB.

    See Create data types for instructions.

  2. Choose Edit > Insert > SQL File.
    The New SQL File wizard appears.
  3. In the Descriptive name for SQL text box, type a name for the SQL file.
    For example, type SbspaceTest.
  4. In the Custom SQL create text text box, type the following statement: 
        EXECUTE FUNCTION SYSBldTstSBSpace("opt_name");
  5. Click Next.
  6. To specify which data types in your DataBlade module contain smart large objects, click the appropriate objects in the These objects require this SQL box.
    For example, click BigType.

    For more information about dependencies, see Object dependencies.

  7. Click Finish.

Results

When BladeManager prepares the DataBlade module for registration, the database server executes the SYSBldTstSBSpace() function before the SQL statement to create the BigType data type. If the sbspace specified in SYSBldTstSBSpace() exists, the database server creates the dependent data type (BigType). If the sbspace does not exist, the database server writes an error to a BladeManager log file.

For more information about BladeManager, see the HCL OneDB™ DataBlade Module Installation and Registration Guide.