Re: Copy BLOB to IFS

Seems like it may be something we will see in the future. It appears that mainframe DB2 handles it via EXPORT.

db2 export to myfile.del of del lobs to mylobs/
lobfile lobs1 modified by lobsinfile
select * from emp_photo

This is from https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.admin.dm.doc/doc/c0004562.html


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Feb 22, 2017, at 4:09 PM, Raul A Jager W <raul@xxxxxxxxxx> wrote:

Not sure, I did a program that read an image (to IFS) and stores in a blob, Probably is easy to revert, I forgot the details, but it is very likely you can find them searching for blob_file.

D blob s sqltype ( blob_file)

RPG or sql preprosesor creates a data structure with blob_nl, blob_name, blob_dl, blob_fo where you load the ifs name, the name length, the data length, etc.


On 02/22/2017 05:37 PM, Rob Berendt 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

-- Este e-mail fue enviado desde el Mail Server del diario ABC Color -- -- Verificado por Anti-Virus Corporativo Symantec --
--
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