Re: Query400 question

[qsrvbas@xxxxxxxxxxxx (Tom Liotta)]

Further, perhaps the CASE statement could be part of an SQL VIEW, created via 
RUNSQLSTM, OpsNav or QM query, and the view could be read by Query/400.

Tom Liotta

midrange-l-request@midrange.com wrote:

>   9. Re: Query400 question
>
>Not in Query/400, as far as I know. However, it is possible in SQL with the 
>CASE statement
>
>CASE when xpto='EXW'
>                 then var1=value*0,3
>             else
>                  var1=value*0,4
>END CASE
>
>This can be placed directly into a SELECT statement.
>
>At 03:30 PM 1/20/03 +0000, you wrote:
>>Hi,
>>
>>It is possible to define conditions to use on variables defined in a query
>>?
>>
>>IF  xpto='EXW'
>>var1 = value*0,3
>>else
>>var1 = value*0,4
>>
>>var1 is a variable define on the query (definition of a result field)

-- 
-- 
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/