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

["Peter Dow" <pcdow@xxxxxxxxx>]

Hi Charly,

Logical files still work fine.  The missing piece is that IBM appears to be
moving towards SQL for defining files, so in order to have the same
capability as DDS, SQL needs a way to create a combined view/index.
Otherwise you end up with some SQL stuff to create tables, views and
indexes, and some DDS to create keyed logical files.

Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax


----- Original Message -----
From: "Charly Jones" <charly301@hotmail.com>
To: <midrange-l@midrange.com>
Sent: Wednesday, November 21, 2001 9:18 PM
Subject: 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
>
> _______________________________________________
> 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.


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com