RE: Accessing DB2 blob data from Domino

It's a start...

I was able to write a RPG program to insert records into my DB2 database 
with blob fields.  My blob field was in the ifs as a pdf file.  This 
program put it directly into the blob field:
http://archive.midrange.com/midrange-l/200307/msg00622.html
Now my Notes developer seems to be having a rough go actually retrieving 
this blob field.  He can retrieve other DB2 data without much difficulty.

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 





"Scott Johnson" <sjohnson@xxxxxxxxxxxxx>
Sent by: domino400-bounces@xxxxxxxxxxxx
07/14/2003 01:48 PM
Please respond to Lotus Domino on the iSeries / AS400
 
        To:     "'Lotus Domino on the iSeries / AS400'" 
<domino400@xxxxxxxxxxxx>
        cc: 
        Fax to: 
        Subject:        RE: Accessing DB2 blob data from Domino



Rob,

These may not be the exact answer you are looking for, but may provide 
some
help.

<
http://www-10.lotus.com/ldd/46dom.nsf/55c38d716d632d9b8525689b005ba1c0/0b3ca155

6aeb86ec85256b3c0069ecad?OpenDocument>

<
http://search400.techtarget.com/ateQuestionNResponse/0,289625,sid3_cid508423_ta

x285216,00.html>

>http://publib-b.boulder.ibm.com/Redbooks.nsf/9445fa5b416f6e32852569ae006bb65f/9
db2f1ab1865969a862567a70060deaa?OpenDocument>

-- Scott Johnson

> -----Original Message-----
> From: domino400-bounces@xxxxxxxxxxxx
> [mailto:domino400-bounces@xxxxxxxxxxxx]On Behalf Of rob@xxxxxxxxx
> Sent: Monday, July 14, 2003 12:49 PM
> To: Lotus Domino on the iSeries / AS400
> Subject: Accessing DB2 blob data from Domino
>
>
> Anyone access DB2 blob data from Domino?  If so, how?
>
> Let's say you had this sample database from ibm:
> http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/sqlp/rb
afymst384.htm#HDREMPLOYEEPHOTO

How would you go about inserting and retrieving data from it via Domino?

We already access DB2 data for inquiries via Domino.  The trip is the BLOB
field.

Our application is this.  We will have a iSeries based application
generate a PDF file.  Then we want to associate that PDF file with
particular other DB2 data.  We were thinking a blob field made sense. Once
the iSeries based application did that, then Domino could access that
data.

Rob Berendt


_______________________________________________
This is the Lotus Domino on the iSeries / AS400 (Domino400) mailing list
To post a message email: Domino400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/domino400
or email: Domino400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/domino400.