How can I INSERT data in TEXT datatype field? (Informix)

Question

 CREATE TABLE updater
 (
    nzp_up SERIAL PRIMARY KEY,
    version VARCHAR(50),
    status INT,
    report TEXT
 );

INSERT INTO updater (version, status,report) values ('TestVersion' , 0,"123123123");

-617 SQL error: A blob data type must be supplied within this context.

Answer 1

Using a | (pipe) delimited file, you can use the LOAD command to insert values into blob & text data types. I had the same problem in the past - go to link in my comment