Re: Copy BLOB to IFS

Dang! Thanks

On Wed, Feb 22, 2017 at 3:37 PM, Rob Berendt <rob@xxxxxxxxx> wrote:

Yes, you have to take the blob data and write it out as an IFS file.
Unless someone has any detail on a function to do this?


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Jack Tucky <jacktucky@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>,
"RPG programming on the IBM i (AS/400 and iSeries)"
<rpg400-l@xxxxxxxxxxxx>
Date: 02/22/2017 03:21 PM
Subject: Re: Copy BLOB to IFS
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



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;

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD