| -----Original Message----- | [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Vern Hamberg
| You need to have a literal that is different for each query. You | can define | a result field, I think, with a literal value, then use that in | your query.
Bingo! Define the result field as a constant 'T' in first QRY, 'P' in second and put select that result field for output. No HLL pgm needed.
| -----Original Message----- | Sent: Thursday, September 25, 2003 3:14 AM
| JT:awaiting your bill :) | Thanks , | Murali.
Pleasure will be ALL mine, Murali, and bill will be in low six figures, USD...;-D (If/when paid, I'll make sure to throw a few hundred to Vern, Rich and Booth...!...;-)
This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact