The following transform is not putting spaces into the column in DataStage 8.1. It works fine in DS 7.5.2. The code was converted. The column contains null in DS 8.1
IF NullToValue(TO_Transform.PROV_LOC_CD,"999") = "900" THEN NullToValue(TO_Transform.BZET_PRO_ID," ") ELSE Space(10)
Transform logic not working in DS8.1 working in DS 7.5.2
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
What is the datatype of the column and what do you mean by 'null' - empty string or a null value?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>