coding User Defined Routines for Informix in C Language

Even if the custom Stored Procedures are frequently used in Informix databases, your preferred RDBMS offers you a number of easy to use tools that will allow you to reach a further level in the development of User Defined Routines. Although the SPL language responds to a wide and identified range of requirements, it is possible to create your own UDRs while using the power of the C language, which is always plebiscited for its performance level as well as for its virtually infinite possibilities
This small post is an introduction to Informix UDRs in C language, describes the functionnal interest you may have at using them, and shows some simple examples that, I hope, will make you feel like exploring those too weakly visited development landscapes.
Click here to discover more about the Integration of C language  with Informix UDRs

, , ,

2 Responses to “coding User Defined Routines for Informix in C Language”

  1. John November 28, 2013 at 11:21 pm # Reply

    Do you know if it’s possible to write a C UDR function for Informix Extended Parallel Server (XPS). I understand it’s possible with Dynamic Server (IDS) but not sure about XPS.


  1. Excute Perl Script - dBforums - May 24, 2013

    […] Totally agree Rasputin. Avoid database access in the Perl script because it will be a totally different session, then considered as a totally different user. UDRs can be written only in C, SPL and JAva. Perl is not in the list. When developping a C based UDR, you will have to indicate whether the function can be multi-threaded or not and whether parameters can change structure or not. These questions are typically in the same range as the one induced by invoking an external script accessing the database. If interested in developping your own Informix UDRs based on C, check this bootstrap article […]

Leave a Reply

%d bloggers like this: