Add custom SQL to test for an sbspace

Because you are creating smart large objects, you must have a default sbspace defined in your database server. If you do not have an sbspace, you cannot register your DataBlade module. See the HCL Informix® Administrator's Guide for information about creating an sbspace with the onspaces utility.

When a user registers a DataBlade module, BladeManager can execute a routine, SYSBldTstSBSpace(), to check for the required sbspace. If the sbspace is found, BladeManager successfully registers the DataBlade module. If the sbspace is not found, BladeManager does not register the DataBlade module, and an error appears in the registration log explaining the problem. You instruct BladeManager to run SYSBldTstSBSpace() by adding a custom SQL file to your DataBlade module project.

When you are creating a DataBlade module, you can use the DBDK Visual C++ Add-In to register the DataBlade module and check for the required sbspace. If the sbspace is not found, the add-in launches Notepad with the log explaining the problem.

To add custom SQL:

Choose Edit > Insert > SQL File, type the following information in the New SQL File wizard, and leave all other fields in the wizard as their default values.
Custom SQL property Value

Descriptive name for SQL SbspaceTest

Custom SQL create text EXECUTE FUNCTION SYSBldTstSBSpace(" ");

These objects require this SQL Poem
Click Finish and then choose Project > Save to save your project.

Custom SQL property	Value
Descriptive name for SQL	SbspaceTest
Custom SQL create text	EXECUTE FUNCTION SYSBldTstSBSpace(" ");
These objects require this SQL	Poem