Hi,
I'm mapping varchar18 to varchar(15) in transformer stage. I'm not using substring here. I'm just doing direct mapping. I have data in length 18 from source. I expected warning in data stage log and this record will get dropped and the job status will be finished with warnings. But it doesn't throw any warning. Transformer stage passed first 15 characters only to target and job status is finished. Is this actual behavior of transformer stage? Do I need to set any environment variable to raise warning and make the record to get dropped from transformer stage?
Thanks,
Poovalingam.
mapping higher to lower length transformer
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 111
- Joined: Mon Nov 30, 2009 7:21 am
- Location: Bangalore
There is no variable or setting you can change to make DataStage warn you automatically when you explicitly change to a smaller length.
You can of course program a transform stage to reject and output a warning to the log file when this happens.
You can of course program a transform stage to reject and output a warning to the log file when this happens.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 111
- Joined: Mon Nov 30, 2009 7:21 am
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code it yourself. Use a constraint expression such as Use an Otherwise/Log output link to capture the too-long strings.
If you want to generate a warning, you can create a routine that passes its argument through unchanged but called DSLogWarn() in its code.
Code: Select all
Len(InLink.TheString) <= 15
If you want to generate a warning, you can create a routine that passes its argument through unchanged but called DSLogWarn() in its code.
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.
That's strange, according to this technote, the env variable should work on all DS versions : http://www-01.ibm.com/support/docview.w ... wg21586920
Eric
Eric