Extending Informix Dynamic Server 2000 Developing a User-Defined Routine

This chapter describes how to design and create user-defined routines (UDRs). It covers the following topics:

• Planning the routine
• Creating the shared-object file
• Registering the UDR

Although the SQL statements that you use to define SPL routines and external routines are the same, the specific clauses and modifiers that you can use with the SQL statements differ somewhat. For this reason, SPL routines and external routines are often documented separately.

For information about how to create and use SPL routines, see the chapter on SPL routines in the Informix Guide to SQL: Tutorial.