clob informix java,Informix 7.3 isql插入语句-text / blob / clob字段插入错误

Is a way around this??

I am trying to insert some data into a table whose structure is:

Column name Type Nulls

crs_no char(12) no

cat char(4) no

pr_cat char(1) yes

pr_sch char(1) yes

abstr text yes

The type of the last field reads 'text', but when trying to insert into this table, I get this error:

insert into crsabstr_rec values ("COMS110","UG09","Y","Y","CHEESE");

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

Error in line 1

Near character position 66

So this field is some sort of blob apparently, but won't take inserts (or updates). Normally, these records are inserted into a GUI form, then C code handles the insertions.

解决方案

in iSQL....

Load from desc.txt insert into crsabstr_rec;

3 row(s) loaded.

desc.txt is a | (pipe) delimited text file and the number of fields in the txt have to match the number of fields in the table