Registering with the SYSBldPrepare( ) function

You can use the built-in SYSBldPrepare( ) function to register one or more DataBlade® modules or to unregister a DataBlade module, as an alternative to using the BladeManager application. This enables you to register DataBlade modules from any client API that supports SQL, such as DB-Access, SPL, C API, ESQL, JDBC, or ODBC, and without requiring that BladeManager be installed.

The following restrictions affect which databases can support the SYSBldPrepare( ) function for DataBlade module registration:
  • No cross-database support. You cannot use SYSBldPrepare( ) to register or unregister a DataBlade module in any database except the local database to which your session is currently connected. To use this function in another database, you must first connect to that database and then invoke SYSBldPrepare( ).
  • No transaction support. Do not invoke SYSBldPrepare( ) within transactions that you begin explicitly.
  • Currently there is no support for unlogged or ANSI/ISO-compliant databases. The function is valid only in databases that support explicit transactions.
  • You cannot register a DataBlade module on a secondary server in a cluster. Register DataBlade modules on the primary server in a cluster.