i have a table with 3 columns(serial,varchar and blob).This is in the database that is created on a dbspace 'space1'.I don't know if the blob column is residing in sbspace.when i am trying to insert record into this table from dbaccess i see the following errors.

9810: Smart-large-object error.
12053: Smart Large Objects: No sbspace number specified

what is the problem.how do i alter the table to move the blob column only to the sbspace.

when the application is trying to insert record into this table the following error is thrown "failed to add message to the table"...

how do we find out what column of each table resides in what dbsapce.
.Need help at the earliest.pls reply.

thanks

Problem Solved.

The table was not created with the blob being stored in the sbspace.
I had to set the default SBSPACENAME parameter in the onconfig file and create a sbspace.This way any inserts will direct the blob to be stored in the sbspace.

Thanks

this cause is no blob dbspace to store blob data for short term

You can either specify the smart blobspace name when you create or alter the table. Check the sql syntax guide (web) or you can set the SBSPACENAME parameter in your $ONCONFIG, which is the default place.