Hi,
does datastage 7x have a functionality to return or write to a file the records that failed and the name of the column that failed with out using a transformer in the designer for validation?
lets say I have 1000 records having 10 columns, record number 50 failed in column 5..
can datastage write that in a sequential file or can the director be set to display the said information?
thanks...
returning failed record and feild
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 13
- Joined: Thu Jan 03, 2008 7:54 pm
Yes, DataStage PX/EE does this by having the designer put a "reject" link out of the passive output stage. For databases this will contain the SQL error code but in neither case does it explicitly tell you which column caused the reject.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The log will contain any error message generated by the database server. This may or may not contain the name of a column. It may, for example, contain the name of the constraint that was violated. It's then up to you to examing the column values (also logged) to determine which value(s) caused the problem.
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.
-
- Participant
- Posts: 13
- Joined: Thu Jan 03, 2008 7:54 pm
ray.wurlod wrote:...This may or may not contain the name of a column...
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 13
- Joined: Thu Jan 03, 2008 7:54 pm