Re: Blob Spaces?

When you create the table with the blob column you specify which blobspace you want the blob to be stored in. Example: create table t1 (col1 text in blobspace1, col2 byte in blobspace2, col3 text in table); This table with 3 blobs will store col1 in the blobspace called blobspace1, col2 in the blobspace blobspace2, and col3 will be stored in the table itself as blob pages within the table extents. Jacques Jerry A. Van Zant wrote: > I just called Informix and asked them how do you control which > blobspace a blob will go into (I could not find anything in the docs). > > They told me that the only way to control this was by using esql-c and > that you can't control this with SQL? Is this true? They told me if > I create a blobspace, online would use it by default. > > IDS 7.24.UC6, HP/UX 10.10 > > Thanks > Jerry Van Zant > jvz@opendata.com -- ******************************************************************** * Jacques P. Renaut "I'd dazzle you with brilliance * * Informix Advanced Support if I only had the knack..." * * email: jrenaut@informix.com #include <disclamier.h> * ********************************************************************