I'm trying to create an auto-increment column in a table using a sequence.
The problem is that I can't create a trigger that would set the new.auto_id column to my_sequence.nextval.
In other words i'd like to translate the following Oracle trigger to an Informix one:
create or replace trigger my_trigger before insert on my_table for each row
SELECT my_sequence.nextval INTO :new.auto_id FROM dual;