How can I insert a null value with Mirth to an Informix DB table?

[alvarodb]

Hi.
When I try to insert a null value in a Informix DB table with the destination:

INSERT IGNORE INTO table1 (value1) VALUES (${cod_value1}));

with cod_value1 NULL the mirth doesn´t work (there is a syntax error).
I tried in the transformer:
cod_value1=null;
cod_value1=NULL;
cod_value1='null';
cod_value1.setNull();
........

How can I insert a null value with Mirth to an Informix DB table?

[chrisl]

Re: How can I insert a null value with Mirth to an Informix DB table?

cod_value1='';