Home | Previous Page | Next Page   Developing a User-Defined Routine > Planning the Routine >

Adhering to Coding Standards

The SQL/PSM standard is available for UDR development. In addition, a collection of standards is available for DataBlade module development from the IBM Informix Developer Zone at www.ibm.com/software/data/developer/informix. The most important rules govern the naming of data types and routines. DataBlade modules share these name spaces, so you must follow the naming guidelines to guarantee that no problems occur when you register multiple DataBlade modules in a single database.

Tip:
It is recommended that you use the DBDK, Version 4.0 or later, to manage DataBlade development. It is especially important to use the SQL registration scripts that the DBDK generates so that BladeManager can correctly process DataBlade upgrades.

In addition, the standards for 64-bit clean implementation, safe function-calling practices, thread-safe development, and platform portability are important. Adherence to these standards ensures that UDR modules are portable across platforms.

Ask yourself the following questions when you code your UDR:

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]