Page 1 of 1

Error when checking operator: Could not find input field

Posted: Tue Sep 20, 2011 1:39 am
by eswar1
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,

Posted: Tue Sep 20, 2011 1:44 am
by ray.wurlod
Do you have identically named columns on the Columns tab?