Re: Converting TEXT/BYTE to CLOB/BLOB

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