Hi All,
I have hash file as input to a transformer and two outputs( one for target table and one for target error table)
In transformer I gave constraints as link1.rejected for the error table
link1 is output to target table
I am not getting the rejected row in error table but a warning which says
"DSP.Close Error -100 in $DSP.Close."
Anyone has the idea about this warning...
Thanks
Rejected row
Moderators: chulett, rschirm, roy
What are the stages (ODBC, OCI, database please) and can you view data (connections are proper) and what is the SQL action?
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Re: Rejected row
Hi.pkomalla wrote:Hi All,
I have hash file as input to a transformer and two outputs( one for target table and one for target error table)
In transformer I gave constraints as link1.rejected for the error table
link1 is output to target table
I am not getting the rejected row in error table but a warning which says
"DSP.Close Error -100 in $DSP.Close."
Anyone has the idea about this warning...
Thanks
what is ur target error table is it a database table or seq file ?,
use caps in link1.REJECTED
on error output link is it show'g you number of rows rejected?
are there any primary key violation in the target table.?
it will be helpfull if you provide above details
rachitha.
constraints is right, check your input link
I think nothing wrong with your constraints.
check your database and input data are matching.
check your database and input data are matching.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
$DSP.Close is a function exposed by a plug-in stage. That is, the problem is not with the Hashed File stage or the Transformer stage. Get your DBA to trace what's happening on these connections.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.