Re: Blobs - Was - Floating Point Question

Rob Berendt wrote:
> 
> I went SQL gung ho for awhile for creating files.  There are still
> somethings easier to do with DDS.  Like have a single file be a
> combination of an INDEX and a VIEW.

Yes, but understand what you are REALLY trying to do with an index is
tune the performance, and what you do with a view is akin to security.
They are two different things that AS/400 people see as one. In SQL, you
do not specify the index you are going to use. You ask for the data and
get the data. If (and that can be a big if) the index is there, then
performance will be good. If the index is not, then performance can
range from good to not good.

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