I have the need to unload BLOB data (actually, .pdf documents) that are kept in a DB2 for i table.
Since I'm more a DB2 LUW person, I can't find a way to do this....
Anyone out there who knows how to do this...?
Your help would be greatly appreciated....!!
Buenos Aires - ARGENTINA
This topic has been locked.
5 replies Latest Post - 2012-12-07T19:06:50Z by SystemAdmin
Pinned topic DB2 for i - UNLOAD/EXPORT of BLOB column
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-12-07T19:06:50Z at 2012-12-07T19:06:50Z by SystemAdmin
Re: DB2 for i - UNLOAD/EXPORT of BLOB column2012-11-28T18:57:34Z in response to SystemAdminI haven't used BLOB's but here is the link to the InfoCenter where it talks about using them in SQL
Re: DB2 for i - UNLOAD/EXPORT of BLOB column2012-11-29T11:15:55Z in response to SystemAdminHi Scott:
Thanks for your answer...
I don't think it can help me though.... :-(
I'm trying to help a friend of mine who contacted me as a DB2 knowleadgeable person.
In doing so, I found that DB2 for iSeries is a rather different animal than DB2 for LUW or DB2 for zOS...
This is so simple to do in DB2 for LUW.....(export..lobsinfile..etc)
krmilligan 120000MDWP436 Posts
Re: DB2 for i - UNLOAD/EXPORT of BLOB column2012-12-07T13:59:10Z in response to krmilliganHi:
I browsed thru the CPYTOIMPF command/utility but, since I'm not a iSeries knowledgeable person, I found it rather criptical....
But the DB2 CONNECT option was something that I did not consider.....and it sounds pretty easy on paper....
I'll hand it over to my friend so that he can try it....I'll keep you posted.
Many, many thanks !!
Re: DB2 for i - UNLOAD/EXPORT of BLOB column2012-12-07T19:06:50Z in response to SystemAdminHere is an article that just came out today showing how to do it via embedded SQL in RPG