Re: Copy BLOB to IFS

I've managed to get the data from the BLOB so far. I would like it to be
on the IFS instead. Do I need to take blob_data and write it to a STMF?

Here is the code I'm using.

Thanks
D Info DS QUALIFIED
D BLOB SQLTYPE(BLOB:15728640)

EXEC SQL Set option naming =*SYS;

EXEC SQL Declare C1 Cursor for
Select lwiimage
from lwimages;

EXEC SQL Open C1;
EXEC SQL Fetch Next from C1 into :info;
EXEC SQL Close C1;
return;


On Wed, Feb 22, 2017 at 1:29 PM, Jack Tucky <jacktucky@xxxxxxxxx> wrote:

I need to send a BLOB via FTP to another server. It's a JPG.

I'll have to do 5-10 images at a time so I think i'd like to copy the BLOB
to the IFS and then send all of the images in the IFS.

I've been googling, found some examples here but not sure where the image
will go.

I tried this code in SQL and am getting an error that the field LWIIMAGE_F
is not usable.

EXEC SQL Declare C1 Cursor for
Select LWIIMAGE_F ,
audfid
from lwimages;

EXEC SQL Open C1;
EXEC SQL Fetch Next from C1 into :LWIIMAGE_F,
audfid;