Re: SQL View

["Michael R" <michaelr_41@xxxxxxxxxxx>]

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