Re: Design Change Request form - SQL: Combine the functions of a VIEW with an IN

On the System/38 we used a logical file to provide the functional
combination of a view with an index.  I haven't done a lot of design or
coding recently...

What am I missing in this discussion?

-- Charly

"If you wanna end the war and stuff you gotta
sing loud." -- Arlo Guthrie

For their next act, they'll no doubt be buying a firewall running under NT,
which makes about as much sense as building a prison out of meringue.  --
Tanuki

Charly Jones
253 265-6244
Gig Harbor
Washington USA




>From: rob@dekko.com
>Reply-To: midrange-l@midrange.com
>To: midrange-l@midrange.com
>Subject: Re: Design Change Request form - SQL:  Combine the functions of a
>VIEW with an INDEX.
>Date: Wed, 21 Nov 2001 13:42:16 -0500
>
>
>
>Rob Berendt
>
>==================
>"They that can give up essential liberty to obtain a little temporary
>safety deserve neither liberty nor safety."
>Benjamin Franklin
>----- Forwarded by Rob Berendt/DEKKO on 11/21/2001 01:39 PM -----
>
>                     "James Vessey"
>                     <v40915@us.ibm       To:     rob@dekko.com
>                     .com>                cc:
>                                          Fax to:
>                     11/21/2001           Subject:     Marketing Field
>Requirement -- MR111201337
>                     12:01 PM
>
>
>
>
>
>
>Your Requirement has been closed. Below is the developers response:
>
>Title - Combine the functions of a SQL VIEW with those of a SQL INDEX.
>Status - Recognized
>IBM agrees with the request and a solution appears to be a desirable
>objective. A solution however may not presently appear feasible or
>implementable. No IBM commitment is made or implied as to the eventual
>delivery of an acceptable solution.
>
>If you have need of further programming assistance you can contact IBM at
>1-800-237-5511 option 2 and ask for AS/400 Consult Line. They are a group
>that may be able to assist you further with this requirement.
>
>*******************************************************
>  James Vessey
>  Business Operations Desk
>  Rochester Support Center
>
>
>
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.
>


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp