RE: Query400 question

[pnelson@xxxxxxxxxx]

   I've said it before and I'll say it again:

   IMHO, all of this can b= e done much more easily with SEQUEL from Advanced
   Systems Concepts (www.asc= -iseries.com)

   Contact me off-line and I'll show you some SEQUEL views= with 20-30 CASE
   conditions/statements.

   Contact ASC, and you can get = a free evaluation copy.

   "Rubino, Jim" &= lt;Jim.Rubino@Fike.com>
   Sent by: midrange-l= -bounces@midrange.com
   01/20/2003 11:08 AM CST</FON= T>
   Please respond to Midrange Systems Technical Discussio= n

   To: "'Midrange S= ystems Technical Discussion'"
   <midrange-l@midrange.com><B= R> cc:
   bcc:
   Subject: RE: Query400 question

   <= BR>

   I agree with Peter........you wo= uld need to create two queries.
   In another posted reply you said that yo= u would need to have these to
   combined.  You could still run two qu= eries, each of the results to an
   outfile and then copy these to files in= one file and run a query or
   report
   of this new file.
   NOTE: YOU WOULD= NEED TO BE SURE THAT THE TWO OUTFILES YOU CREATED HAVE
   THE
   SAME FIELDS = AND SIZES IN ORDER FOR YOU TO COPY THEM INTO ONE FILE.
   <FONT = FACE="Monospace,Courier">Does this make sense?
   Jim

   -----Original Message-----
   From: pedro.reis@valeo.com [mailto:pedro.r= eis@valeo.com]
   Sent: Monday, January 20, 2003 9:30 AM
   To: midrange-l@= midrange.com
   Subject: Query400 question

   Hi,
   It is= possible to define conditions to use on variables defined in a
   query
   ?<= BR>
   IF  xpto='EXW'
   var= 1 = value*0,3
   else
   var1 = value*0,4
   var1 is a variable define on the query (definition of a r= esult field)

   Cor= dialement,
   Best regards,
   --------------------------------------------= -----------------------
   Pedro Reis
   Information System
   e-mail: pedr= o.reis@valeo.com
   Phone: 351-258 350 725
   Fax: 351-258 350060
   ------= --------------------------------------------------------------
   VALEO - E= lectronics & Connective Systems
   Viana do Castelo - Portugal
   -----= ---------------------------------------------------------------
   <= BR>"This e-mail message is intended o= nly for the use of the named
   recipient(s).
   The information contained = therein may be confidential or privileged, and
   its
   disclosure or repr= oduction is strictly prohibited. If you are not the
   named
   recipient, ple= ase return it immediately to its sender at the above
   address
   and destroy= it."

   ____   _________________________   __________________
   This is the Midra= nge Systems Technical Discussion (MIDRANGE-L) mailing
   list
   To post a mes= sage email: MIDRANGE-L@midrange.com
   To subscribe, unsubscribe, or change= list options,
   visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l   or email: 
MIDRANGE-L-request@midrange.com
   Before posting, please= take a moment to review the archives
   at http://archive.midrange.com/midrange-l.
   <BR= >
   ____________   _________________________   __________
   This is the Midrange Systems Technical Di= scussion (MIDRANGE-L) mailing
   list
   To post a message email: MIDRANGE-L@m= idrange.com
   To subscribe, unsubscribe, or change list options,
   visit:= http:/= /lists.midrange.com/mailman/listinfo.cgi/midrange-l
   or email: MIDRAN= GE-L-request@midrange.com
   Before posting, please take a moment to review= the archives
   at http:/= /archive.midrange.com/midrange-l.