Re: Blobs - Was - Floating Point Question

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxx>]

John P Carr wrote:
> 
> >Mike its actually better that the object is stored in the root IFS as its a
> >byte stream file system rather than being in QSYS, which makes it faster to
> >serve. The database link will then allow you to put constraints against the
> >object so it cant be deleted as it exists in the database. I am also quite
> >happy with it being SQL only and look forward to the functionality.
> >Thanks
> >Bleddyn
> >***********************************************************
> >http://www.ignite400.org Your AS/400 Internet User Group
> >*****
> 
> Hey,   This is neat stuff.   Look at it this way.   The relational theory
> traditionally
> dealt with rows and columns.  That was it.   Well the world has gotten more
> complicated.  We have LOBs, BLOBs,  CLOBS, DCLOBS ,  etc.
> Imagine,  having a column in a data base that linked(via a URL)  or
> referenced a "Related"  attribute of the entity in question.
> 
> If you deleted an employee out of your Relational Data base(using the
> most repeated example),   Wouldn't you like to also "Erase" the employee's
> Resume, picture, etc???    Well using the new features thats the level of
> "Relationalship" control we are starting to acheive.
> 
> It's in the IFS,  sure,  that's where it belongs.   The Relational linking,
> and/or control is where we need to be going.
> 
> I just wish that we had some native RPG affinity with this stuff.
> 
> John Carr

John, that's part of b.

The ability to store the large object (picture, text, etc.) can be done
physically, or logically. In the logical, you specify where in the world
the large object is and the database locks it and keeps track of it.

-- 
===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified AS/400 Professional System Administrator
 -- IBM Certified AS/400 Professional Network Administrator

"The sum of all human knowledge is a fixed constant.
    It's the population that keeps growing!"
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---