Write Simple large object to a file using JDBC 2.x

Is there any function that lets you write a byte column to a file ..something like lotofile for smart large objects. Alternate way is to get the inputstream from .getByteStream and write to a file, I was just thinking of letting JDBC driver do it for me.

On Tue, 2007-07-17 at 16:46 -0700, mohitanchlia@gmail.com wrote: > Is there any function that lets you write a byte column to a > file ..something like lotofile for smart large objects. Alternate way > is to get the inputstream from .getByteStream and write to a file, I > was just thinking of letting JDBC driver do it for me. You should be able to cast BYTE to BLOB and then use lotofile: select lotofile(bytecol::blob, 'blob????????.dat', 'client') from sometable HTH, -- Carsten Haese http://informixdb.sourceforge.net