Rejection with ODBC Stage in PX job

[laxman.ds]

Hi!

I am working on PX job. The Source is Dataset and target is SQLServer. To populate target i am using ODBC Stage,While doing Rejection process i am Getting following error:--
XfmReject: Error when checking operator: Could not find input field "sqlcode"

Can you please help me to come out with the same.

Regards,
Laks

[mdan]

can you post the design of the reject capture ?

Hi!
XfmReject: Error when checking operator: Could not find input field "sqlcode"

[laxman.ds]

Hi...the structure of rejuction table:--

Data_Record Varchar 4000
Sql_Error_Code Varchar 100
Load_Sys Varchar 100
Load_Table Varchar 100

[laxman.ds]

Hi...the structure of rejuction table:--

Data_Record Varchar 4000
Sql_Error_Code Varchar 100
Load_Sys Varchar 100
Load_Table Varchar 100

[laxman.ds]

Hi...the structure of rejuction table:--

Data_Record Varchar 4000
Sql_Error_Code Varchar 100
Load_Sys Varchar 100
Load_Table Varchar 100

Hi...but the problem occured in sqlcode generated after the record is rejected....
for this i take copy stage and remove the sqlcode from output then its working fine...
Please clearify get the value of sqlcode....

Regards,
Laksman

[mdan]

Hi laxman.ds,
between the ODBC and your reject target add a modify stage and write into spec sqlcode=sqlcode. Be sure that you have the sqlcode column in the output.
It should work.

Dan