Zitat:

Eine View kann die "Order by"-Klausel erhalten.
[/quote]
ab welchem Release ? Das würde einiges erleichtern

Gruß
Rolf

V4R4 Handbuch :
Code:
>>-CREATE VIEW--view-name--------------------------------------->
 
>-----+--------------------------------------------------------------------+>
      |    .-,------------------------------------------------------.      |
      |    V                                                        |      |
      '-(-----column-name--+-------------------------------------+--+---)--'
                           |     .-COLUMN-.                      |
                           '-FOR-+--------+--system-column-name--'
 
>----AS--+---------------------------------------+---subselect-->
         |       .-,--------------------------.  |
         |       V                            |  |
         '-WITH-----common-table-expression---+--'
 
>-----+-------------------------------------+------------------><
      |       .-CASCADED--.                 |
      '-WITH--+-----------+---CHECK OPTION--'
              '-LOCAL-----'