Hello,
Can I have a SQL like the one below in a COBOL-DB2 program.
SELECT R25.ACCTG_PREM
FROM UP1DBAP.TDB01R25 R25,
(SELECT MAX(ST_ACTION_DATE)
AS THFMAX
FROM UP1DBAP.TD4101R1
WHERE SOL_TRANS_CONT_NO = :H-POL-NO
AND ST_CODE NOT LIKE '%R') AS TEMP
WHERE R25.POL_NO = :H-POL-NO
AND TEMP.THFMAX BETWEEN R25.ACCTG_PREM_FST_DUE AND
R25.ACCTG_PREM_LST_DUE
Thanks in advance.
Ramkumar
Can I have a SQL like the one below in a COBOL-DB2 program.
SELECT R25.ACCTG_PREM
FROM UP1DBAP.TDB01R25 R25,
(SELECT MAX(ST_ACTION_DATE)
AS THFMAX
FROM UP1DBAP.TD4101R1
WHERE SOL_TRANS_CONT_NO = :H-POL-NO
AND ST_CODE NOT LIKE '%R') AS TEMP
WHERE R25.POL_NO = :H-POL-NO
AND TEMP.THFMAX BETWEEN R25.ACCTG_PREM_FST_DUE AND
R25.ACCTG_PREM_LST_DUE
Thanks in advance.
Ramkumar