Search code examples
sqlinsertblobinformixisql

Informix 7.3 isql insert statement - text/blob/clob field insert error

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.

Solution

  • 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