Compatibility of client and server DataBlade API modules

You can execute a UDR from an SQL statement and from a client application with little or no modification to the code. Any function that does not require interactive input from the client application can be written as a UDR. However, not all application code are in a C UDR. You must balance the load between the client and the database server to achieve optimal performance.

To avoid interfering with the operation of the database server, you can develop functions on the client side even if they are intended to run from the server process eventually. When you develop a C UDR on a client computer, you can use the same DataBlade® API functions on the client and the server computers, in most cases, without changing the code. Almost all of the DataBlade API functions behave identically in a client LIBMI application and a C UDR to provide portability for DataBlade API modules. If you are writing code that might execute in either a C UDR or a client LIBMI application, you can use the mi_client() function to determine at run time where the code is running.