RE: SQL View

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

Uh..... no.

SQL by definition separates the view from the index.  The combination of the
two in a single object exists only on OS400.  That's a logical file.  In SQL
world, combining the two would limit capability.  Separation allows any view
to be accessed by any index.

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: Smith, Dave [mailto:DSmith@tshsc.com]
Sent: Friday, December 13, 2002 2:08 PM
To: midrange-l@midrange.com
Subject: SQL View


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.