Re: Copy BLOB to IFS

[Jack Tucky <jacktucky@xxxxxxxxx>]

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;