I've added a reject link to a SEQ file from a ODBC stage in enterprise. When I look at the columns in the output link I find a extra columns added (columns name: sqlcode)
When I run the job I get the following error
"Transformer_53: Error when checking operator: Could not find input field "sqlcode"."
Could not find input field "sqlcode" ERROR
Moderators: chulett, rschirm, roy
I have this same issue when I drop a reject link off my odbc stage. I have to pass a dummy column(sqlcode) to the odbc stage. Otherwise I get the error "could not find input field sqlcode" in odbc stage. When I do this my dummy value overwrites any sqlcode that may be generated in the reject link.
I would actually like to capture the sqlcode value if possible.
Maybe this is a feature in Datastage.
Thanks
I would actually like to capture the sqlcode value if possible.
Maybe this is a feature in Datastage.
Thanks
We don't see things as they are;
We see them as we are.
We see them as we are.