CREATE PROCEDURE
    do_syslog(priority integer, message lvarchar)
EXTERNAL NAME
    "/usr/informix/lib/logger.so(do_syslog)"
LANGUAGE C
END PROCEDURE;

create trigger "informix".proto_gyslog_trigger insert on "informix"
    .protocol referencing new as new
    for each row
        (
        execute procedure "informix".do_syslog( 5  ,new.user_name 
    || ':' || new.event || ':' || NVL (new.event_str ,'' )));


#include <syslog.h>
#include "mi.h"

/*
 * LOG_EMERG       0       system is unusable
 * LOG_ALERT       1       action must be taken immediately
 * LOG_CRIT        2       critical conditions
 * LOG_ERR         3       error conditions
 * LOG_WARNING     4       warning conditions
 * LOG_NOTICE      5       normal but signification condition
 * LOG_INFO        6       informational
 * LOG_DEBUG       7       debug-level messages
 */
void
do_syslog(mi_integer priority, void *message)
{
    mi_string *message_ptr = mi_lvarchar_to_string(message);

    if (message_ptr != NULL)
        syslog(priority, "%s", message_ptr);

    if (message_ptr != NULL)
        mi_free(message_ptr);
}