Re: SQL Blob CCSID

["Art Tostaine, Jr." <atostaine@xxxxxxxxx>]

Sorry here is my SQL

D BLOB            s                   SQLTYPE(BLOB_FILE)

EXEC SQL  Declare C1 Cursor for
  Select  iimage
  from    images
  where  fid = :ppMid  and IIMAGE_F IS NOT NULL;

EXEC SQL          Fetch Next from C1 into :blob;

On Thu, Feb 20, 2020 at 3:16 PM Art Tostaine, Jr. <atostaine@xxxxxxxxx>
wrote:

> Using SQL to retrieve a JPG to a STMF.  How do  I specify the CCSID?  I'm
> setting these variables:
>
> BLOB_NAME = filepath
> blob_nl = %len(filepath)
> blob_fo =SQFOVR
>
> I'm googling trying to figure this out.  Thank you.
> --
> Art Tostaine