Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2002
    Location
    Bellevue,WA
    Posts
    20

    Unanswered: Blob problem--URGENT

    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

  2. #2
    Join Date
    Sep 2002
    Location
    Bellevue,WA
    Posts
    20
    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

  3. #3
    Join Date
    Mar 2002
    Posts
    112

    re

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

  4. #4
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    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.
    rws

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •