Re: SQL View

[rob@xxxxxxxxx]

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.