David

I believe it's in V5R2. You use a common-table-expression, which can have
an order by clause, as well as a fetch first n rows only clause, now.

So

create view libname/viewname (column1, coumn2, ....) as with temptable as
select field1, field2, ... from somelib/somefile order by field1 select *
from temptable

create view libname/viewname (column1, coumn2, ....) as select * from
temptable as select field1, field2, ... from somelib/somefile order by field1

or something like that.

So it's not in the definition of the view, it's in the definition of the
temp result table that the view is built over.  Heh! Heh!

See
<http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/db2/rbafzmsthcview.htm>.

Regards

Vern

At 03:07 PM 12/13/02 -0500, you wrote:
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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.