Hello again to all,

Thx for everyone's responses. Just wanted to note that I tried the blob
examples that come with version 3.0.JC3 of the JDBC driver and they too
fail with the same error when I try to do the insert. I modified the
example to include the PUT for the blob columns in a specific space but
even the example complains about no sbspace number if a default not
configured when running version 10 of informix so I am at a loss. thx
again for any insights u may have.
===========
Test Starts
Creating Table demo1_1 and demo1_2 ...
Trying to insert data into demo1_1..

Inserting data ...

FAILED to Insert into tab: java.sql.SQLException: Smart-large-object
error.
java.sql.SQLException: Smart-large-object error.
at
com.informix.util.IfxErrMsg.getSQLException(IfxErr Msg.java:373)
at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3208)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3518)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java :2353)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.j ava:2269)
at com.informix.jdbc.IfxSqli.executeFastPath(IfxSqli. java:5640)
at com.informix.jdbc.IfxSqli.executeFastPath(IfxSqli. java:5565)
at
com.informix.jdbc.IfxSmartBlob.IfxLoCreate(IfxSmar tBlob.java:376)
at com.informix.jdbc.IfxSmBlob.i(IfxSmBlob.java:770)
at com.informix.jdbc.IfxSmBlob.a(IfxSmBlob.java:505)
at com.informix.jdbc.IfxResultSet.b(IfxResultSet.java :282)
at com.informix.jdbc.IfxStatement.c(IfxStatement.java :1253)
at
com.informix.jdbc.IfxPreparedStatement.executeUpda te(IfxPreparedStatement.java:408)
at demo1.set_execute(demo1.java:382)
at demo1.main(demo1.java:237)
Caused by: java.sql.SQLException: Smart Large Objects: No sbspace
number specified.
at
com.informix.util.IfxErrMsg.getSQLException(IfxErr Msg.java:373)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3523)
... 12 more