Re: SQL View

[rob@xxxxxxxxx]

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
I think I am starting to see the light on this.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




"Michael R" <michaelr_41@hotmail.com>
Sent by: midrange-l-admin@midrange.com
12/13/2002 03:42 PM
Please respond to midrange-l

        To:     midrange-l@midrange.com
        cc:
        Fax to:
        Subject:        Re: SQL View


Rob -

Do we want them to 'fix' it? Wouldn't putting the view and the index
together violate SQL standards?






>From: rob@dekko.com
>Reply-To: midrange-l@midrange.com
>To: midrange-l@midrange.com
>Subject: Re: SQL View
>Date: Fri, 13 Dec 2002 15:32:09 -0500
>
>This is a multipart message in MIME format.
>--
>[ Picked text/plain from multipart/alternative ]
>Michael,
>
>You're right, and you are wrong.  A view is an SQL thing.  Yes a DDS
>logical file can do this.  But SQL can be used to create logical files.
>There are some things in views unavailable in DDS logical files.
>There are some things in DDS logical files unavailable to views (or the
>related Index).
>Even though they are physically the same thing on disk.
>
>Duh! Maybe what you meant was that this is unavailable via sql and only
>via DDS, and I didn't read it that way.  In that case you are right -
>currently - but we can get them to fix this.
>
>
>Rob Berendt
>--
>"They that can give up essential liberty to obtain a little temporary
>safety deserve neither liberty nor safety."
>Benjamin Franklin
>
>
>
>
>"Michael R" <michaelr_41@hotmail.com>
>Sent by: midrange-l-admin@midrange.com
>12/13/2002 03:16 PM
>Please respond to midrange-l
>
>         To:     midrange-l@midrange.com
>         cc:
>         Fax to:
>         Subject:        Re: SQL View
>
>
>Nope...dount if it will happen...that's not an SQL thing, that's a
logical
>file thing.
>
>Hi Dave...
>
>
>
>
>
>
> >From: "Smith, Dave" <DSmith@tshsc.com>
> >Reply-To: midrange-l@midrange.com
> >To: <midrange-l@midrange.com>
> >Subject: SQL View
> >Date: Fri, 13 Dec 2002 15:07:32 -0500
> >
> >Will our mighty iseries ever allow us to Create a SQL View with an
Order
>By
> >clause?  Anybody have any info on this? IBM?
> >
> >I did some searching on this and did not find much other than a design
> >change request by Rob Berendt about a year ago and the response from
IBM:
> >"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."
> >
> >David Smith
> >Tri-State Hospital Supply Corp.
> >IT Consultant
> >dsmith@tshsc.com
> >517.546.5400
> >_______________________________________________
> >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.
>
>
>_________________________________________________________________
>Help STOP SPAM with the new MSN 8 and get 2 months FREE*
>http://join.msn.com/?page=features/junkmail
>
>_______________________________________________
>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.
>
>
>_______________________________________________
>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.


_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8.
http://join.msn.com/?page=features/junkmail

_______________________________________________
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.