RE: Can I do this in Query

[qsrvbas@xxxxxxxxxxxx (Tom Liotta)]

Mark:

For me, if I were forced to use Query/400 rather than create a QM query, the 
easiest way would be to create a view and then query the view. The view might 
be like:

 ===>  create view MyLib/MyQryView as (
   select (case  when  substr(item,1,3) = 'DST' then '2'
                 when  substr(item,1,1) = 'X'   then '3'
                                                else '1'
           end)  as GrpType ,
                    Item
   from    MyLib/MyFile
  )

or something similar. Make sure that the sequence of items in the CASE phrase 
sets the result value properly and that you include all the detail columns you 
want in addition to your GrpType column.

Then just query the view and summarize/control break as you need.

Tom Liotta


midrange-l-request@midrange.com wrote:

>  11. Can I do this in Query (Mark Allen)
>
>Need 3 separate sections (i.e. level break) in a single Query report as
>follows
>
>Section 1:  All items that do not have an X in pos 1 and do not have DSL
>in pos 1-3
>
>Section 2:  All items that have DSL in item # pos 1-3
>
>Section 3:  All items that have X in item # pos 1
>
>I know I could make it 3 separate queries with appropriate selection,
>output to a file, then print vs that file but if at all possible would
>like to do in 1 query=85..

--
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788 x313
Fax    253-872-7904
http://www.powertechgroup.com


__________________________________________________________________
The NEW Netscape 7.0 browser is now available. Upgrade now! 
http://channels.netscape.com/ns/browsers/download.jsp

Get your own FREE, personal Netscape Mail account today at 
http://webmail.netscape.com/