I have no problem do it on batch, use SQL to create a hold file. Anyway how to do it online?
SQL DB2
SELECT A.POL_ID, A.CO_ID, A.CVG_NUM,
B.CLI_ID,
C.CLI_FIRST_NM,
C.CLI_LAST_NM
FROM TABLE1 A, TABLE2 B, TABLE3 C
WHERE A.CO_ID = B.CO_ID AND
A.POL_ID = B.POL_ID AND
A.CVG_NUM = B.CVG_NUM AND
B.CLI_ID = C.CLI_ID AND
C.EFF_DATE = (
SELECT MAX(A.EFF_DATE)
FROM TABEL1 A, TABLE2 B, TABLE3 C
WHERE A.CO_ID = B.CO_ID AND
A.POL_ID = B.POL_ID AND
A.CVG_NUM = B.CVG_NUM AND
B.CLI_ID = C.CLI_ID AND
C.EFF_DATE <= A.PAY_OUT_DATE );
......
This is one hold file I created, I have another two to create, then create the report. User doesn't want to do it batch coz need to submit ticket every time.. Our online webfocus environment already connect to DB2 tables mentioned above...
SQL DB2
SELECT A.POL_ID, A.CO_ID, A.CVG_NUM,
B.CLI_ID,
C.CLI_FIRST_NM,
C.CLI_LAST_NM
FROM TABLE1 A, TABLE2 B, TABLE3 C
WHERE A.CO_ID = B.CO_ID AND
A.POL_ID = B.POL_ID AND
A.CVG_NUM = B.CVG_NUM AND
B.CLI_ID = C.CLI_ID AND
C.EFF_DATE = (
SELECT MAX(A.EFF_DATE)
FROM TABEL1 A, TABLE2 B, TABLE3 C
WHERE A.CO_ID = B.CO_ID AND
A.POL_ID = B.POL_ID AND
A.CVG_NUM = B.CVG_NUM AND
B.CLI_ID = C.CLI_ID AND
C.EFF_DATE <= A.PAY_OUT_DATE );
......
This is one hold file I created, I have another two to create, then create the report. User doesn't want to do it batch coz need to submit ticket every time.. Our online webfocus environment already connect to DB2 tables mentioned above...