Re: Create view using CTE as to have an ORDER BY

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

++++++1!!!

On 6/6/2013 9:56 AM, CRPence wrote:
> On 05 Jun 2013 12:34, Needles,Stephen J wrote:
> > The goal is to convert existing DDS-defined DB objects to DDL.
> > <<SNIP>>
>     I can pretend to infer there are specific reasons for effecting such
> a conversion for each chosen file, even while knowing how unlikely that
> is [esp. with an implication of "all"].  Yet, I must ask rhetorically...
>
>     Why do so many choose to waste so much time and effort when there are
> certainly more productive activities; e.g. code enhancements :-(
> Hopefully asked often enough, some will stop and ask themselves "Why?"
> to think upon their choice, before possibly effecting nothing more than
> a change for the sake of change.  Amazing in contrast, how many would
> allow code to remain unchanged for decades because there is nothing
> inherently wrong with leaving the source and programs unchanged, yet for
> some reason [even those same] people are motivated to make the change
> from DDS to SQL with no logic supporting their actions.
>
>     And I must remind... Always make the change to SQL for programs
> *before* changing from DDS to DDL, to best avoid problems; for one, the
> mindset of ordered data outside of the ORDER BY in the SELECT query
> should already have faded.  Irrespective of implications by some [snake
> oil salesmen], the transition to DDL from DDS has *nothing* to do with
> /modernization/ of applications, except when an unsupported data type or
> feature of the DDL is required for the design which probably has already
> changed to use the SQL as part of its transition to no longer depend on
> the tight coupling of program to the file layout in the apparently
> /legacy/ RLA ways.