Re: BLOB's on AS/400?

[Gade_R_Reddy@xxxxxxxxxxxxxxxxxx]

Binary Large Objects




"Mike Silvers" <msilvers@hbs-inc.com>@midrange.com on 05/02/2000 11:21:34
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?


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



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