Triggers and Stored Procedures

Genero db supports the Informix^® trigger and stored procedure language.

However, Genero db (<=3.81) does not support user function calls within queries, for example:

SELECT getage(patient_bd) FROM patient WHERE patient_id = 12345

See Genero db documentation for more details.

Solution

Until Genero db supports user function calls inside SQL queries, you need to extract the stored procedure/function and call it with a secondary statement handle as described here.