Re: BLOB's on AS/400?

[Gade_R_Reddy@xxxxxxxxxxxxxxxxxx]

Russell.

Could you please send me the info about BLOB to my email address
gade.r.reddy@gtfc.com

Appreciate it.
Gade.





"L. S. Russell" <leslier@datrek.com>@midrange.com on 05/02/2000 11:54:37 AM

Please respond to RPG400-L@midrange.com

Sent by:  owner-rpg400-l@midrange.com


To:   RPG400-L@midrange.com
cc:
Subject:  Re: BLOB's on AS/400?


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
+---



+---
| 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
+---