RE: Table Definitions DDS or SQL?

Isn't that what views are for?  I think the use of views would really make 
queries a lot easier.  What's the biggest complaint most people have about 
Query/400?  Probably
1 - figuring out what tables and columns.
2 - How to join them together

And you can make them easier by doing a little math in the view
create view qtemp/OpenOrders as 
 (select hord as Order#, 
         hcust as Customer#, 
         hedte as OrderDate, 
         decimal(lqord-lqshp,11,3) as QtyRemain,
         lprod as Item# 
  from ppidivf/ech join ppidivf/ecl 
  on hord=lord 
  where hstat<>'C') 

Then it's a simple matter of
select * 
from openorders 
order by customer#, item#

The biggest thing the new gui tools do is to strongly encourage you to do 
all this in the 'set up' phase.  They just do it under the covers so that 
it doesn't look like this is what you are doing.

Rob Berendt