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
Could not find input field "sqlcode"
Moderators: chulett, rschirm, roy
What are your column definitions and it would seem you are using user-defined SQL, so what do you have there?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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