Is there any way to pass variable to a query during batch job?
Then I have an SQL select statement for my extract that uses the variables above.
//SYSIN DD *
FROM U1BANCS.GECT WHERE
INST_NO = '003' AND
ACCT_NO LIKE ACCTNO AND
TRAN_DATE = TRANDATE AND
(TRAN_TYPE = 1 OR TRAN_TYPE = 20)
ORDER BY INST_NO ASC,
ACCT_NO ASC ,
But when I run the job, I get an error. Is there a way to use the variables declared in the job?