Inserting Blob TEXT data
How do I include Blob data in an Insert statement? In the following SQL
statement, the description field in the categories table is a TEXT data
type.
INSERT INTO categories ( name, parent_cat_id, fileroot,
short_description, description, active_flag, sort_order ) VALUES
('Test', 1, 'testroot', 'short description', 'description', 1, 1);
Checking the syntax or executing this SQL gives the following error:
[Informix][OnLine Dynamic Server][videoranch] SQL Error (-617) : A blob
data type must be supplied within this context.
Taking out the description field and the description value (since they
are not required) makes the statement work just fine:
INSERT INTO categories ( name, parent_cat_id, fileroot,
short_description, active_flag, sort_order ) VALUES ('Test', 1,'testroot', 'short description', 1, 1);
I am running an Informix Online Workgroup Server ver 7.12 on Sun Solaris
2.5.1
How do I do this? How would I go about adding a graphic file if I had a
BYTE data field?
Thanks for the help,
Tauren
tauren@groovee.com