Hi
I'm using DB2 as source. In DB2 I wrote user defined SQL Query.
select
A.ACCT_NBR,A.CHKDGT,A.ACCT_OPN_DT,A.ACCT_CLOS_DT,B.ACCT_BAL_SMRY_AMT,B.ACCT_NBR,C.CR_LIM_AMT,C.ACCT_NBR,D.CR_LIM_AMT,
D.ACCT_NBR from AGMNT A, ACCT_BAL_SMRY_DD B,ACCT_CR_LIM C,
ACCT_FTR D where A.ACCT_NBR= B.ACCT_NBR AND A.ACCT_NBR= C.ACCT_NBR AND A.ACCT_NBR= D.ACCT_NBR
When I run the job for every input column I'm getting the error as
"Error when checking operator: Could not find input field "CHKDGT".
Error when checking operator: Could not find input field "ACCT_OPN_DT".
For all input columns I'm getting this error.I'm unable to solve this,
Please help me to solve the problem.
Thanks,
Error when checking operator: Could not find input field
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: