On Fri, 2007-01-12 at 08:18 -0700, Laurie Gustin wrote:
> We are trying to move some of our data to Smart Large Objects in sbspaces....
>
> We are currently looking at unloading each TEXT field to a file using unload from a cron job, one row at a time - we cant seem to get unload to work from within a stored procedure. Then using the FILETOCLOB function from within and stored proc to load the data into the CLOB field.
>
> Does anyone know of an easier way to do this without writing a lot of C code?

TEXT/BYTE can be cast directly to CLOB/BLOB.

select cat_descr::CLOB from catalog

select cat_picture::BLOB from catalog

Hope this helps,

--
Carsten Haese | Phone: (419) 861-3331
Software Engineer | Direct Line: (419) 794-2531
Unique Systems, Inc. | FAX: (419) 893-2840
1687 Woodlands Drive | Cell: (419) 343-7045
Maumee, OH 43537 | Email: carsten@uniqsys.com