Hi,

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
BEGIN
SELECT my_sequence.nextval INTO :new.auto_id FROM dual;
END;

Has anyone faced the same problem?

Thx