|
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.list
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.BLOB
I'll have to do 5-10 images at a time so I think i'd like to copy the
to the IFS and then send all of the images in the IFS.image
I've been googling, found some examples here but not sure where the
will go.LWIIMAGE_F
I tried this code in SQL and am getting an error that the field
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
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.