Re: blob space question

Hi, You could mentioned the "dbspace" where you intend to store the blob columns at the moment you create the table: ( if you're using IDS 7.31 ) create table blob1a (col1 int, col2 byte in dbsblob1, col3 text in dbsblob2) in dbspace1 extent size .... next size .... lock mode .... ; ( if you're using IDS 9.3 or 9.4 ) You must use 'put'.... BR R. FErronato Paul Watson <paul@oninit.com> wrote in message news:<40A1C25B.78E9DF31@oninit.com>... > If you didn't use 'put' for the column then the data will be with > the table. Normally you would create a separate blobspace and > put the data in that. You could run an alter table to move it. > > Nathan Hattersley wrote: > > > > I have never used the blob data type before and I have a question. > > After setting up a test table with a column defined as BLOB, I have > > managed to successfully insert into and retrieve data from this table. > > My question is probably pretty straight forward, but, where is the > > data being stored? I have not specified the blobspace to be used for > > storage. Have I done something wrong? > > > > Thanks in advance, > > > > Nathan Hattersley > > mailto:nathan.hattersley@sensis.com.au