Order by clause when Creating views...

[T.Holt]

The SQL standard does not allow the order by clause when creating tables or views. You use the order by when selecting data from the table or view. The system looks at the existing access paths & figures out the best way to get the data. There is also a create index command you can use to create other access paths.

[Guest.Visitor]

This is true and you really do not want that option. You can select info from your (non order by) view and order in your select. i.e. Select * From Myview Order By NewKey Cheers!

[Guest.Visitor]

Is this not allowed? Create View MyView as Select * From MyTable Order By NewKey Why not? Also why does query/400 read a logical file by RRN instead of by the key defined in the logical? I just learned about this the other day. What's the deal?

[Guest.Visitor]

I'm taking your word for it since I did see a complex eplination of this in my ANSI SQL manual. It kinda caught me by suprise b/c I was always under the assumption that running a LF thru query/400 would retain the LFs key sequencing. I guess I'll just try to keep this in mind for the future.