DSXchange

Hi all,
from the target ODBC stage am using a seq. file to load the rejected records.

settings made :
ODBC
output reject records - True

Seq. file.
file - /........./............/............./test.txt
file update - overwrite
Cleanup on failure - True
Reject mode - continue

When I ran this job. error msg thrown
Could not find input field "sqlcode"

How do I overcome this.Help me out.

thanks
Kumar

What are your column definitions and it would seem you are using user-defined SQL, so what do you have there?

ArndW wrote:What are your column definitions and it would seem you are using user-defined SQL, so what do you have there? ...

Hi ArndW,

There are abt 20 columns. 18 are VARCHAR and 2 TIMESTAMP.
I am using Auto-generated SQL. When I add that rej. link a new column sqlcode is adding as you.

thanks

that makes sense, the "sqlcode" is added in the reject link so that you can analyze the error cause. Which stage is giving this error?

ArndW wrote:that makes sense, the "sqlcode" is added in the reject link so that you can analyze the error cause. Which stage is giving this error? ...

Seq. file stage.

The output reject link of your Oracle stage should have "sqlcode" as an integer column, is that correct? Are you writing straight to a sequential file or going through another stage?

ArndW wrote:The output reject link of your Oracle stage should have "sqlcode" as an integer column, is that correct? Are you writing straight to a sequential file or going through another stage? ...

Yes, you are right, sqlcode is integer column. and yes I am writing straight to seq. file as below


ODBC stage 1 ---------> Trfm -----------> ODBC stage 2 - - - - - - -> Seq. file.

This is how my job looks and now we are concerned with ODBC stage 2 and Seq. file stage.

thanks
Kumar

Kumar,

I am running into the same issue and trying to resolve it. Were you able to find a resolution yet?