Need to pass DATE To DB2 query
Posted: Fri Dec 28, 2012 10:27 am
Hi,
I have a COBOL-DB2 program which is reading a file containing date. Lets say TODATE.
TODATE is moved to SQLDATE
One of the query from program is like
Now,
For some reasons, I need to remove this query from program. And will be executed seperately through JCL.
Is there anyway to pass this SQLDATE (i.e. TODATE) to this SQL query, rather than hardcoding it?
I have a COBOL-DB2 program which is reading a file containing date. Lets say TODATE.
TODATE is moved to SQLDATE
MOVE TODATE TO SQLDATE.
One of the query from program is like
INSERT INTO TMP_ADJ
SELECT
A.COMPANY
,A.PRODUCT
,A.ACTIVFROM
,SUM(A.AMOUNT
) AS
AMOUNT
FROM BILDET A
WHERE A.COMPANY = 1
AND A.ATRNTYPE IN('MN','TI','PO')
AND A.ACTIVFROM > :SQL-TODATE
AND A.TRANDATE <= :SQL-TODATE
GROUP BY
A.COMPANY
,A.PRODUCT
,A.ACTIVFROM
SELECT
A.COMPANY
,A.PRODUCT
,A.ACTIVFROM
,SUM(A.AMOUNT
) AS
AMOUNT
FROM BILDET A
WHERE A.COMPANY = 1
AND A.ATRNTYPE IN('MN','TI','PO')
AND A.ACTIVFROM > :SQL-TODATE
AND A.TRANDATE <= :SQL-TODATE
GROUP BY
A.COMPANY
,A.PRODUCT
,A.ACTIVFROM
Now,
For some reasons, I need to remove this query from program. And will be executed seperately through JCL.
Is there anyway to pass this SQLDATE (i.e. TODATE) to this SQL query, rather than hardcoding it?