DSXchange

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"."

Try using a copy stage which connects the ODBC and Sequential file stage and drop the SQLCODE field.

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

The copy solution also works, as mentioned by Kumar. I haven't seen a solution that allows the capture of the sqlcode though.

thx

:D

Use modify stage and keep the column sql code and write it to the file..