Add custom SQL to test for an sbspace
About this task
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 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: