Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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?


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

    cod_value1='';
    Chris Lang

    Comment

    Working...
    X