Re: BLOB's on AS/400?

["L. S. Russell" <leslier@xxxxxxxxxx>]

Binary Large OBject, this is a relatively new gadget in DB2. I have some
info I could send if you like.

Mike Silvers wrote:
> 
> I am probably not the only one wondering this, but what is BLOB?
> 
> ----- Original Message -----
> From: <jpcarr@TREDEGAR.COM>
> To: <RPG400-L@midrange.com>
> Sent: Tuesday, May 02, 2000 11:39 AM
> Subject: Re: BLOB's on AS/400?
> 
> >
> >
> > Jim
> >
> > I would look into Data Links instead of Blobs.   Data Links would allow
> you
> > to
> > store the documents in the IFS as a native .DOC, .ETC  whatever the format
> > is.
> >
> > It would "Link" the directory path(URL,  ie  /MYDIRECTORY/MYDOC.DOC)  in
> > the IFS
> > and associate that document with a field in a data base record.  For
> > example,
> > if you did this,  you could not delete the document without deleting the
> > DB2/400
> > record that contained that URL first.
> >
> > The downside with Blobs, Clobs, DClobs, Data Links, etc is that you won't
> > be able
> > to see them in RPG or even use that file or it's logical's in RPG.
> >
> > As a side question,   How many would like it if Rochester changed the Data
> > Link
> > function so that we would see the URL field as just a Character type field
> > in RPG?
> >
> > Something like we were able to do in RPGIII with DATE/TIME/TIMESTAMP data
> > types?
> >
> > I think if we lean on Rochester they would do that for us. They just don't
> > know
> > we need it.
> >
> >
> > John Carr
> >
> >
> >
> >
> > I'm sure it's been asked and answered, but here goes...
> >
> > Part of our e-commerce strategy may be to 'store' the document created by
> > the user as a BLOB.  I'm not finding any documentation on if/when/how the
> > AS/400 will support this.
> >
> > Anybody have the answer?
> >
> > Thanks,
> > JN
> >
> >
> >
> >
> >
> >
> > +---
> > | This is the RPG/400 Mailing List!
> > | To submit a new message, send your mail to RPG400-L@midrange.com.
> > | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> > | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
> > | Questions should be directed to the list owner/operator:
> david@midrange.com
> > +---
> 
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---

--
L. S. Russell Programmer/Analyst
Datrek Professional Bags, Inc.
2413 Industrial Drive
Springfield, TN. 37172
mailto:leslier@datrek.com
http://www.datrek.com
--
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---