In this query I am creating a computed "HOLD FLAG" column. Can I use
this computed column in evaluating the "ON-HOLD COMMENTS" column, or do
I have to run the sub-select query like I am doing now?
Thanks
Chris
select
(CASE
WHEN
(SELECT COUNT(*) FROM AMFLIB.MBCKREP
WHERE
AMFLIB.MBCKREP.CKCVNB =
AMFLIB.MBCDREP.CDCVNB AND
AMFLIB.MBCKREP.CKBCDT > 0 AND
AMFLIB.MBCKREP.CKBDDT = 0 ) > 0 THEN
1
ELSE 0 END) AS "HOLD FLAG",
(CASE
WHEN
(SELECT COUNT(*) FROM AMFLIB.MBCKREP
WHERE
AMFLIB.MBCKREP.CKCVNB =
AMFLIB.MBCDREP.CDCVNB AND
AMFLIB.MBCKREP.CKBCDT > 0 AND
AMFLIB.MBCKREP.CKBDDT = 0 ) > 0 THEN
'UNCONTROLLED DELAY'
WHEN
(SELECT COUNT(*) FROM AMFLIB.MBCKREP
WHERE
AMFLIB.MBCKREP.CKCVNB =
AMFLIB.MBCDREP.CDCVNB AND
AMFLIB.MBCKREP.CKBCDT > 0 AND
AMFLIB.MBCKREP.CKBDDT = 0 ) = 0 AND
AMFLIB.MBC6REP.C6UUCA = ' ' THEN
'_________________'
WHEN
(SELECT COUNT(*) FROM AMFLIB.MBCKREP
WHERE
AMFLIB.MBCKREP.CKCVNB =
AMFLIB.MBCDREP.CDCVNB AND
AMFLIB.MBCKREP.CKBCDT > 0 AND
AMFLIB.MBCKREP.CKBDDT = 0 ) = 0 AND
AMFLIB.MBC6REP.C6UUCA = 'X' THEN
'*UNCONTROLLED DELAY'
ELSE '_________________' END) AS
"ON-HOLD COMMENTS",
from
...
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.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 on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.