Re: BLOB's on AS/400?

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

Ack!
The only two links I had were posted to the list by rjslaney. Please
look for his message.

Merrill Gordon wrote:
> 
> Could you please also send to my email address: mgordon@forsyth.cc.nc.us
> Thanks.
> Merrill
> 
> *****************************************************
> Merrill J. Gordon
> Forsyth Technical Community College
> 2100 Silas Creek Parkway
> Winston-Salem, NC 27103
> (336) 723-0371 X 7408, FAX (336) 725-0669
> mgordon@forsyth.cc.nc.us
> *****************************************************
> 
> >>> "L. S. Russell" <leslier@datrek.com> 05/02/00 12:54PM >>>
> 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
> +---

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