Fwd: inserting blobs

For a simple large object (types BYTE and TEXT) you deffine the blobspace into which to place the BLOB column in the column's definition line: ... some_text TEXT in my_blobspace, ... For smart blob columns you use a PUT clause after the EXTENT clause: ... some_slob_col CLOB, ... ) IN somedbspace PUT (some_slob_col) in mysmartblobspace...; For smart blobs, if you leave off the PUT clause the engine will distribute the values in the existing smart blobspaces. For simple blobs, you either have to specify 'IN TABLE' or 'IN some_blobspace' Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Sep 22, 2009 at 1:20 PM, Floyd Wellershaus <floyd@fwellers.com>wrote: > Our developers want to insert pdf files into the ids10.0.fc5 database now. > It will be stored as a row in a table where the other fields are not blob > types. > I am going to make a blob dbspace or an sbspace. > Do I need to do something with the table storage parameters to make the > blob go there, or does Informix just know that anything you try to insert > into a blob datatype row, will automatically get stored into the blob space > ? > > Thanks, > floyd > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >